Database Phase 2
|
Pg. 02 |
|
Project Scenario |
|
|
|
|
Project - Phase II
Deadline: Wednesday 14/4/2021@ 23:59
[Total Mark for this Case Study is 5]
Introduction to Database
IT244
Project Scenario
For the ER Diagram below.
Question One
2.5 Marks
Learning Outcome(s):
LO (2)
Transform it into Relational data model, and transform it into normalized form.
Question Two
2.5 Marks
Learning Outcome(s):
LO 3
a. Write the SQL commands to create each table after normalization.
b. Write insert command to add 5 rows in each of the table.
c. Write a delete command to delete row from each table.
d. Write the commands to query following values.
1. Show product id and finish date for all products
2. Show product id and finish for all products, sort by product_line_id by ascending order
3. Show product id and finish for all products, sort by product_line_id by descending order
4. Show each product_line_id and the total number of products for the product_line_id