Reference no: EM132390208
Data Modelling Assignment -
Task - You have been presented with the case study. You need to turn this into a MySQL database. These are the requirements:
1. Read the case study and develop an Entity-Relationship Diagram using the conventions for this unit. This diagram needs to describe all of the business rules in the case study.
2. Using this unit's Entity-Relationship to Relational Schema Algorithm, convert your Entity- Relationship Diagram into a relational schema.
3. Using MySQL create the database based upon your relational schema.
4. Enter two records into each of the relations that you have created in your MySQL database. One of the records MUST contain your name.
5. Correctly and appropriately comment your code so that it can be maintained by your client.
Submission Requirements
1. In a Word Document or PDF, submit your Entity-Relationship Diagram and relational schema INCLUDING all of the steps involved in the conversion algorithm to MyLO. Using Visio is recommended for the E-R Diagram, but any diagramming package, or a hand-drawn diagram included as an image in your Word Document or PDF is acceptable.
2. In a separate text document, submit your file called Assignment.sql to MyLO in which you have recorded all of the MySQL code to create and populate your database.
Attachment:- Case Study.rar
|
GRAD 695 Research Methodology and Writing Assignment
: GRAD 695 Research Methodology and Writing Assignment - Literature review, Homework Help, Harrisburg University of Science and Technology, Pennsylvania, USA
|
|
Write a claim refusal letter
: Write a claim refusal letter. You are the manager of a technology store. A customer purchased a laptop eleven months ago
|
|
COMP 1701 Human Resource Information System Assignment
: COMP 1701 Human Resource Information System Assignment Help and Solution, Level: 6, Middle East College, Oman - Manage components related to HRMS
|
|
CUC107 - Cultural Intelligence and Capability Assignment
: CUC107 Cultural Intelligence and Capability Assignment, Applying Cultural Capabilities Report, Assessment Help and Solution, Charles Darwin University Australia
|
|
Data Modelling Assignment Problem
: Data Modelling Assignment Help and Solution. Using MySQL create the database based upon your relational schema
|
|
Advanced education segment
: The decision to adopt ERM in the advanced education segment happens either in light of a sentinel occasion or at the bearing of the president, board
|
|
Strategic risk management return on investment
: How would you describe the "Strategic Risk Management Return on Investment" at LEGO? What are the advantages of using the PAPA model to categorize risks?
|
|
ITECH7201 Maze Game Assignment Problem
: ITECH7201 Software Engineering: Analysis and Design Assignment Help and Solution - Federation University, Australia - Implementation of various user stories
|
|
Uchs environment differs from the lego group environment
: Explain how ERM adoption and implementation in the UCHS environment differs from the LEGO Group environment.
|