scholarly journals Proposal of a Relational Database (SQL) for Zoological Research of Epigeic Synusion

MENDEL ◽  
2021 ◽  
Vol 27 (1) ◽  
pp. 23-28
Author(s):  
Vladimír Langraf ◽  
Kornélia Petrovičová ◽  
Stanislav David ◽  
Zuzana Krumpálová ◽  
Adrián Purkart ◽  
...  
Keyword(s):  
Molecular Biology ◽  
Relational Database ◽  
Database Design ◽  
Sql Server ◽  
Biological Information ◽  
Ecological Relationships ◽  
Database Program

In recent years, developments in the field of molecular biology and genetics have led to the increase in biological information stored in databases. The same increase in the volume of information occurred in the field of zoology, but the development of databases was not addressed in this area. We prepared a relational database and its diagram in the Microsoft SQL Server Management Studio (SSMS) database program. Our results represent experience with construction of a new database design for the zoology field with a focus on research of epigeic groups. The structure of the database will help with meta-analyzes with the objective to identify zoological and ecological relationships and responses to anthropic intervention.

Relational Database Design Using Semantic Objects

2000 ◽  
pp. 375-384
Author(s):  
Jong-Sung Lee ◽  
Bo Kai Wong
Keyword(s):  
Relational Database ◽  
Database Design

scholarly journals A generator of SQL schema specifications

2007 ◽  
Vol 4 (2) ◽  
pp. 81-100 ◽  
Author(s):  
Slavica Aleksic ◽  
Ivan Lukovic ◽  
Pavle Mogin ◽  
Miro Govedarica
Keyword(s):  
Information System ◽  
Normal Form ◽  
Relational Database ◽  
Sql Server ◽  
Database Schema ◽  
Intelligent Support ◽  
Case Tool ◽  
Design Environments ◽  
Data Constraints

IIS*Case is an integrated CASE tool that supports the automation and intelligent support of complex and highly formalized design and programming tasks in the development of an information system. IIS*Case, as a tool from the class of domain oriented design environments, generates relational database schemas in 3rd normal form with all relevant data constraints. SQL Generator is an IIS*Case tool that generates the implementation specification of a database schema according to ANSI SQL:2003 standard. The generator may also produce a database schema specification for Microsoft SQL Server or Oracle DBMSs. The paper describes SQL Generator's traits, considers aspects of its application, and shows its use in the implementation of a complex database constraint using procedural mechanisms of a particular relational DBMS. SQL Generator is implemented in Java and Oracle JDeveloper environment.

Sign in / Sign up

Export Citation Format

Share Document