StudentShare solutions
Triangle menu
We use cookies to create the best experience for you. Keep on browsing if you are OK with that, or find out how to manage cookies.

LOGICAL DATA MODELLING AND SQL - Coursework Example

Nobody downloaded yet
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
Cite this document
  • APA
  • MLA
  • CHICAGO
(“LOGICAL DATA MODELLING AND SQL Coursework Example | Topics and Well Written Essays - 1750 words - 1”, n.d.)
Retrieved from https://studentshare.net/information-technology/609042-logical-data-modelling-and-sql
(LOGICAL DATA MODELLING AND SQL Coursework Example | Topics and Well Written Essays - 1750 Words - 1)
https://studentshare.net/information-technology/609042-logical-data-modelling-and-sql.
“LOGICAL DATA MODELLING AND SQL Coursework Example | Topics and Well Written Essays - 1750 Words - 1”, n.d. https://studentshare.net/information-technology/609042-logical-data-modelling-and-sql.
  • Cited: 0 times

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…
LOGICAL DATA MODELLING AND SQL
Read Text Preview
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

Check these samples - they also fit your topic

Data Analysis
Data for unemployed persons was obtained from the Annual Population Survey (APS). The APS is conducted annually during which information on the number and percentage of people who are employed, economically active, unemployment rate and economically inactive is collected.
7 pages (1750 words) Coursework
Data Analysis by SQL
As it stated, the customers are the most valuable assets for any business. As an initial step, the customer database is segmented to find the most valuable and reliable customers. This is carried out by segmenting the customers based on their Recency, Frequency and Monetary value (RFM) of their purchases.
7 pages (1750 words) Essay
Analysing data
i Arabia in terms of evaluating the tabulated results from questionnaire that listed the purpose of performance appraisal as perceived by the employees and by the managers; and through a set of twelve interview questions directed to six managers of the organization. The
5 pages (1250 words) Coursework
Identifying Logical Fallacies
"To cast abortion as a solely private moral question,… is to lose touch with common sense: How human beings treat one another is practically the definition of a public moral matter. Of course,
1 pages (250 words) Coursework
Data Rules
It then provides useful information as output. This information assists the user of the system in decision making, identification and solution of problems. The article ‘Knowledge Acquisition, Synthesis and Validation’ focuses on a specific type of
1 pages (250 words) Coursework
Databases
In the case of a relational database, an RDBMS (relational database management system executes data storage, maintenance, and
4 pages (1000 words) Coursework
Data base
B. Who manufactures the DBMS Oracle and what is Oracle’s current version number? Oracle Corporation manufactures oracle DBMS and its current version number is 12c Release 1: 12.1.0.1.2 (Oracle, Introduction to Oracle Database). D. What
1 pages (250 words) Coursework
Object and Data Modelling
The various functions that each end user can perform are also highlighted in the use case model. A detailed design of the case model aims to showcase all the major attributes of the systems functions expected to be
7 pages (1750 words) Assignment
Big Data
This is because availability of more data and a variety of it may lead to results that are more accurate. The accurate results and analyses means that the business will make confident decisions, and this means the business will be efficient in its operations, reduction of
10 pages (2500 words) Coursework
Data Collection
systematic approach of gathering and measuring information on different variables so as to establish answers to research questions evaluate outcomes and test the hypotheses. A myriad of businesses across the globe depend on the collection of data for a number of reasons. Most
8 pages (2000 words) Coursework
Comments (0)
Click to create a comment
Let us find you another Coursework on topic LOGICAL DATA MODELLING AND SQL for FREE!
Contact us:
+16312120006
Contact Us Now
FREE Mobile Apps:
  • About StudentShare
  • Testimonials
  • FAQ
  • Blog
  • Free Essays
  • New Essays
  • Essays
  • The Newest Essay Topics
  • Index samples by all dates
Join us:
Contact Us