LOGICAL DATA MODELLING AND SQL Coursework Example | Topics and Well Written Essays - 1750 words - 1

LOGICAL DATA MODELLING AND SQL - Coursework ExampleIn this case study of the SOUNMISSION Company, we mother been given the conceptual diagram and we argon required to form the logical Entity Relationship Diagram (ERD) establish on the conceptual diagram. The logical info model is developed without considering the data beastly tools to be used for creation and effectuation of the database.The logical ER data model facilitates to identify and specify additional data entities include yet not limited to the Transactional and Operational data entities. Moreover, the logical ER data model contains more culture related to the relationships, primary and foreign keys, as compared to the conceptual data model. In the ER logical models the attributes of the entities are defined, refined and categorized in diverse attribute subjects include the derived attributes, composite attributes, multi-valued attributes, null and elementary attributes. Furthermore, relationships are established in t he logical ER data model. There are three (3) major(ip) types of the relationships include one-one (1 to 1), one-many (1 to many) and many to many relationship. The relationships are based on the primary key and foreign key. The base table contains the primary key that makes a relationship with the other data type contains the foreign key. Usually, this type of relationship is said to be one-to-many relationship. However, the same relationship can be changed by implementing constraint of uniqueness to the attribute / foreign key to restrict the duplicate values. This implies that the established relationship is one to one because twain the data entities contain the non-duplicate value (Tao, n.d).The document presents the conversion of the conceptual data model into the logical data model for the company named SOUNDMISSION. Moreover, the document can be considered as the base document for the development of the database for the company. In the beginning, it is required to identify t he