Assignment 1 – Modelling – College (10%) This assignment relates to the following Course Learning Requirements: Objectiv
Posted: Tue Jul 05, 2022 10:33 am
Assignment 1 – Modelling – College (10%)
This assignment relates to the following Course LearningRequirements:
Objective of this Assignment:
Fictional Situation: You have been given a contract to develop adatabase design for a new college. The college currently hasa single campus, but two more campuses are expected to beoperational within the next 5 years.
In this assignment, you will develop a model using MySQLWorkbench and manually create the necessary DDL statements to buildtables for this new college environment.
Pre-Assignment
Business Rules:
These business rules must be reflected in the model. Payclose attention to the wording of the rules to ensure the correctcardinality is used.
Data To Be Recorded:
Include the following data in your model, include any othercolumns you deem appropriate:
Assignment Tasks:
Step 1: Draw draft of the ERD
On paper, draw the ER diagram based on the business rules statedabove. Ensure the many-to-many relationship isresolved. The diagram must include the entity names,relationships, and cardinalities only. Do not includecolumn names. Note: Review the business rulescarefully so they are being correctly reflected in the model.
On the diagram, identify the three entities involved in theresolution of the many-to-many by placing an asterisk next to theentities.
Take a photo of your solution. Make sure the entire modelis visible and legible.
Step 2: Design ER diagram
Using MySQL Workbench, build the ER model based on the drawingfrom step 1.
Create an image of the model (File -> Export -> Export asPNG)
Step 3: Write DDL statements
Referring to the model created in Step 2, write the SQL DDLstatements to perform the following:
All DDL statements must be written manually. Do notreverse-engineer the SQL from MySQL Workbench.
Apply formatting to the SQL statements. Refer to this URLas a reference on formatting:https://learnsql.com/blog/24-rules-sql- ... -standard/
Make sure all DDL statements execute without error
Copy/paste all DDL statements in a single Word/Notepad file.
Assignment Submission:
Zip and upload the following to Brightspace:
Assignment 1 Grading Rubric (10%)
CRITERIA
POINTS
Complete model from Step1
/10
Proper resolution of M:N relationship in Step 1
/5
Complete model from Step 2
/10
Successful execution of SQL from Step 3
/10
Total Points
/35
This assignment relates to the following Course LearningRequirements:
Objective of this Assignment:
Fictional Situation: You have been given a contract to develop adatabase design for a new college. The college currently hasa single campus, but two more campuses are expected to beoperational within the next 5 years.
In this assignment, you will develop a model using MySQLWorkbench and manually create the necessary DDL statements to buildtables for this new college environment.
Pre-Assignment
Business Rules:
These business rules must be reflected in the model. Payclose attention to the wording of the rules to ensure the correctcardinality is used.
Data To Be Recorded:
Include the following data in your model, include any othercolumns you deem appropriate:
Assignment Tasks:
Step 1: Draw draft of the ERD
On paper, draw the ER diagram based on the business rules statedabove. Ensure the many-to-many relationship isresolved. The diagram must include the entity names,relationships, and cardinalities only. Do not includecolumn names. Note: Review the business rulescarefully so they are being correctly reflected in the model.
On the diagram, identify the three entities involved in theresolution of the many-to-many by placing an asterisk next to theentities.
Take a photo of your solution. Make sure the entire modelis visible and legible.
Step 2: Design ER diagram
Using MySQL Workbench, build the ER model based on the drawingfrom step 1.
Create an image of the model (File -> Export -> Export asPNG)
Step 3: Write DDL statements
Referring to the model created in Step 2, write the SQL DDLstatements to perform the following:
All DDL statements must be written manually. Do notreverse-engineer the SQL from MySQL Workbench.
Apply formatting to the SQL statements. Refer to this URLas a reference on formatting:https://learnsql.com/blog/24-rules-sql- ... -standard/
Make sure all DDL statements execute without error
Copy/paste all DDL statements in a single Word/Notepad file.
Assignment Submission:
Zip and upload the following to Brightspace:
Assignment 1 Grading Rubric (10%)
CRITERIA
POINTS
Complete model from Step1
/10
Proper resolution of M:N relationship in Step 1
/5
Complete model from Step 2
/10
Successful execution of SQL from Step 3
/10
Total Points
/35