Undergraduate
Coursework
Information Technology
Pages 7 (1757 words)
Download 0
In order to define the data model, three (3) types of diagrams can be developed include: the conceptual data model, logical data model and physical data model. The conceptual…

Introduction

In this case study of the SOUNMISSION Company, we have been given the conceptual diagram and we are required to form the logical Entity Relationship Diagram (ERD) based on the conceptual diagram. The logical data model is developed without considering the database tools to be used for creation and implementation of the database.
The logical ER data model facilitates to identify and specify additional data entities include but not limited to the Transactional and Operational data entities. Moreover, the logical ER data model contains more information 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 types include: the derived attributes, composite attributes, multi-valued attributes, null and simple attributes. Furthermore, relationships are established in the logical ER data model. There are three (3) major 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 both 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 the ...
Download paper
Not exactly what you need?

Related papers

Object data modelling
an online, web-based system that could allow their customers to (i) search for the availability and fares for the flight to the desired destination, (ii) make payments securely through a third-party payment system in order to book the tickets for the desired flight, (iii) view the real-time seating arrangement with available seats and select the desired seat in order to self-check-in, and (iv)…
SQL Training Course Experience
However, the primary difference between all these SQL training alternatives is the quality of education and price tag (SQLCourse, 2011). Recently I got experience of attending tutorial of SQL Course named “Interactive Online SQL Training for Beginners”. I got an amazing experience of learning through this course. I got a lot of knowledge and experience through this course. The feature of any…
Lanchester Liners Hospitality Database, SQL
Lanchester Liners Hospitality Database This report presents a detailed overview of design and Implementation of Hospitality Database for Lanchester Liners for holding information about their ships, the ports visited where hospitality is offered, and any corporate team-building events organised on-board. In addition, the report also offers a detailed discussion on multi-user access to a database…
Databases
The construction of a relational database is built around the concepts of relations. This theory include relational algebra (which is a set of mathematical operators which operate on relations and produce relation results), relation variables, and relational comparison operators. A database suitability of a given kind of database, either object oriented or relational databases, depends on the…
LOGICAL DATA MODELLING AND SQL
In this case study of the SOUNMISSION Company, we have been given the conceptual diagram and we are required to form the logical Entity Relationship Diagram (ERD) based on the conceptual diagram. The logical data model is developed without considering the database tools to be used for creation and implementation of the database. The logical ER data model facilitates to identify and specify…
LOGICAL DATA MODELLING AND SQL
In this case study of the SOUNMISSION Company, we have been given the conceptual diagram and we are required to form the logical Entity Relationship Diagram (ERD) based on the conceptual diagram. The logical data model is developed without considering the database tools to be used for creation and implementation of the database.…
Association between data virtualization and SQL Joins
Queries also analyze the services in the server.…