Database Design & Development - PDF

Database Design &
Development
ASSIGNMENT ONE
Due 5 May 2018 (end of week 9) b
Group Work: (Both contributed equally)
Student Number: 19121345
Student Name: Hasibur Rahman
&
Student Number: 19506135
Student Name: Mamun Chowdhury

Q1. Basic database design and queries
1. Design a minimum database (a database of only essential attributes) to
fulfil this purpose, and draw the ER diagram for your design. Indicate on
the ER diagram the primary keys and the relationship multiplicities.
By minimum we mean that you don't need to add anything that is not
explicitly stated in the requirements, unless it's one of your artificially
generated keys. For instance, you don't need to include a telephone
number or email address for the entity corresponding to a buyer. (1.5
marks)
2. Draw the Global Relation Diagram (GRD) corresponding to the ER diagram
in the above, indicating all the primary keys and foreign keys. The GRD
should be in a form similar to Figure 17.9 (page 554 or 516 for edition 5)
of the textbook, but all the attributes should be kept there too. (1 mark)

3. Write an SQL script (of statements) that generates all the tables for your
designed database. (1 mark).

4. Write an SQL script to insert sufficient records into your tables. Each table
should contain no less than 3 records. At least 2 orders should each
contain 2 or more items of the ordered merchandise. Screenshots are
required for the records of all the tables. (1 mark