Designing a database to manage references for a protein structure data Essay

Designing a database to manage references for a protein structure data set using MySQL - Essay ExampleThe database should be adequate to perform frequent searches on structure resolution, author name and initials, institution name, and structure release date. It should in like manner be able to frequently retrieve the instruction about journal articles, PDB code, and name of given protein structures. It should be able provide data in specified order for example, as per the resolution, or as per the moment of articles and institution, or both resolution and number of articles and institution, or even as per a specified institution, etceteraThe database is for storing and managing data regarding macromolecular structures that ar partly derived from the Protein Data Bank (PDB). The data is provided by organizations that deposit, process, and distribute the information about protein sequences. Due to the complexity of this data care needs to be taken to ensure stripped-down data e rrors like missing data, size, alignment, propagation, ambiguity, and labeling.The application should be designed such that, on a user level it provides data forethought across the various database domains shared, by using a outline that allows the call for data processing. The data should be retrieved, modified, and saved from tables using queries. The data is manipulated through applications that access the database in the database management system. The data model of the database defines data structure and behavior. Different aspects of the database are considered for creating models such as logical and corporeal model diagrams. It also gives detailed specifications of the arrogates, rows and columns for tables, and files apply to populate the database. 2. Logical schema of the databaseThe logical model is used to document the data. The defined schema components represent the navigation in the schema diagram. The logical schema is constructed as a model independent of the management system and other physical considerations. The logical schema for the comparative database design of the current database can be derived using normalization. Applying the normalization methods such as 1NF, 2NF, and 3NF obtains the physical schema result.2.1 The Tables and their normalization processI. 1st Normal form (1NF) Table ArticleHere, the entity Article has multiple authors as more than one people can author one articleabout various protein data structures. Therefore, to reduce circumlocution by normalization 2NF is performed. II. 2nd Normal form (2NF) Table ArticleHere, the entity Authors with its attributes have been created for the articles written by them. To further reduce redundancy, 3NF is performed.III. 3rd Normal form (3NF) Table ArticleHere, the protein table has been created for the entity Protein to reduce the redundancy. This was because the attribute for Authors had redundancy regarding the protein structure many authors can work on the same prot ein structure and therefore this was necessary.The logical structure of a database can be given graphically using an entity relationship (E-R) diagram.2.1.1 Entity-Relationship diagramAttributes that are common to all domains belong