Reference no: EM131429881
Assignment: Gourmet Pizzas Project
In this assignment, steps in the logicaldatabase design are conducted (as described below) as well revising the requirement analysis and conceptual design of assignment 1, and a report is written.
This assignment has 3 parts as specified below.
1. Revise requirements and EER diagram in Assignment 1, based on:
i. Either the EER Model submitted for your Assignment 1. Revise it based on feedback provided by your marker, or
ii. Alternatively, complete the partial EER model given at the end of this file, to meet the systems requirements.
2. Map the EER model to the relational model. Document the relational schema in DBDL (Sample format is given below)
ISBN (id, number, itemNo)
Primary Key id
Alternate Key number
Foreign Key itemNo references Book(itemNo)
ON UPDATE CASCADE, ON DELETE CASCADE
3. Normalize the schema to Boyce-Codd Normal Form (if any relation is not already in BCNF). The final normalised schema must be documented in DBDL.
The final report should include the following:
1. Requirement Specification (including data requirements, transaction requirements and business rules).
2. EER Diagram and Data Dictionary
3. Normalized Relational Schema in DBDL. Ensure that normalisation steps are shown if any.
Method of submission: Both softcopy and hardcopy submissions are required:
- zip all required files into one zip file (including the project report, the project database SQL backup file, and any files you consider as part of the assignment). The file name MUST be identified by 4 sections: A2, your first name, your surname, and your student number, e.g., A2SimonLee1234567.zip
- It must be submitted to Blackboard -> Assessment ->AssignmentsSubmission-> Assignment 2.
- Print the project report (with all related SQL codes), hand in the hardcopy to the lecturer at the beginning of the course lecture of week 12. The hard copy must have on the front a signed copy of the cover sheet which is available from: https://www.newcastle.edu.au/__data/assets/pdf_file/0008/75383/AssessmentItemCoverSheet.pdf (Note: pls make sure to fill in your lab session as well as other items.)
- Note: Ten percent of the possible maximum mark for the assessment item will be deducted for each day or part day that the item is late. Weekends count as one day in determining the penalty. Assessment items submitted more than five days after the due date will be awarded zero marks.
- Please note: if your hardcopy submission and softcopy submission are not at the same time, the time of the later submission will be counted as your assignment submission time.
Attachment:- Assignment-Specification.rar
Describe the angular velocities of links bc
: Determine expressions for the velocity and acceleration of points D and A. Express the equations for solutions of your unknowns in matrix form
|
Discuss about the supreme court philosophies and rulings
: Garnering all of the information about constitutional rights and the justice process you have received from this course and your understanding of the "personalities" of the U.S. Supreme Court, prepare a six page paper (not including the APA title ..
|
Architectual and compositional details
: Make notes as you look at different views from the works about what you notice and how it relates to architectual and compositional details from other works we have discussed this semester, or other works that you are familiar with from your own e..
|
Derive general expressions for the vertical velocity
: Derive general expressions for the angular velocities of links AB and EF. Put your equations for the unknown angular velocity terms in matrix equation format for solution.
|
Normalized relational schema in dbdl
: INFO6001: Database Management Requirement Specification (including data requirements, transaction requirements and business rules) and EER Diagram and Data Dictionary - Normalized Relational Schema in DBDL. Ensure that normalisation steps are shown i..
|
Differences between the revolutions
: What are the similarities and differences between the revolutions that erupted in England, the United States, France, and Haiti, in the 17th and 18th centuries? Pay attention to issues of social class, gender, and ideologies in comparing the diff..
|
Explain how the definition operates in relation to goods
: The Consumer Guarantees Act 1993 ("the CGA") only applies in relation to supplies of goods and services to "consumers". You are employed by a retail business and your manager has asked you to provide guidance in relation to the situations when the ..
|
Allied head of state at versailles
: What were Wilson's Fourteen; and how did they relate to the views of his fellow Allied head of state at Versailles? Why did United States not join the League of Nations?
|
Report on network design and management trends
: In this paper, you will research and report on network design and management trends over the last three years (present year minus 2) in the areas of virtualization, security, hardware, network management tools, software defined networking, and wir..
|