LOGICAL DATA MODELLING AND SQL - Coursework Example

Only on StudentShare

Extract of sample
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 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 ...Show more

Summary

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…
Author : kiehnhayden
Save Your Time for More Important Things
Let us write or edit the coursework on your topic
"LOGICAL DATA MODELLING AND SQL"
with a personal 20% discount.
Grab the best paper

Related Essays

Object data modelling
8 Figure 5: Activity diagram for booking tickets 10 Figure 6: Activity diagram for self-check-in 12 Figure 7: Initial class diagram 15 Figure 8: Deployment diagram 16 Figure 9: Detailed class diagram 19 Figure 10: Object model for searching the desired flights 20 Figure 11: Communication diagram for booking tickets 21 Figure 12: Communication diagram for self-check-in 22 Figure 13: Sequence diagram for searching available flights 23 Figure 14: Sequence diagram for self-check-in 24 Figure 15: Behavioral state-machine diagram for searching available flights 25 Figure 16: Behavioral state-machine diagram for self-check-in 27 INTRODUCTION A new economy flight company, Happy Tour, is looking for
20 pages (5000 words) Essay
SQL Training Course Experience
Additionally, at the present IT professionals and students from all over the world have a lot of alternatives for SQL training and classes. In this scenario, they can learn SQL by attending instructor-led SQL training courses, they can gain knowledge from SQL books, and they are also able to take an online SQL course.
4 pages (1000 words) Research Paper
Lanchester Liners Hospitality Database, SQL
5 pages (1250 words) Essay
Databases
Some of these include flat databases and a relational databases. A flat database contains only one table. A database which contains one or several related tables is referred to as a relational database (Harrington, 2002). In a relational database, symbols are organized into a collection of relations.
4 pages (1000 words) Essay
LOGICAL DATA MODELLING AND SQL
The conceptual model is the most abstract level of the entity relationship diagram that contains only high level information. The logical data model is more comprehensive data model as compared to the conceptual data model. Whereas, on the other hand, one or more physical data models are developed for each of the logical data models formed earlier.
7 pages (1750 words) Coursework
Association between data virtualization and SQL Joins
Data virtualization model is made up of entities and relationships. The entities mainly consist of the tables. The query language establishes
1 pages (250 words) Research Paper
Find out how much would it cost
to get a custom paper written by a pro under your requirements!
Win a special DISCOUNT!
Put in your e-mail and click the button with your lucky finger
Your email
YOUR PRIZE:
Apply my DISCOUNT