Purpose
This task requires students to apply their understanding and ability to use Relational Database Management Systems (RDBMS) as well use of SQL in the modelling of the physical world. Students will be provided with a set of business scenarios and are required to design a database and provide related SQL queries.
Instructions
This is an individual assessment task. Students are required to submit a written report that describes the design and implementation of a small database project Students are also required to submit the associated SQL scripts.
>Read these instructions and the following four questions.
>Answer as many questions as possible.
>Place your name,ID and answers in your documents.
>Please submit your Word File with your answers and graphs (embedded) where appropriate as a SINGLE document in the Submission Portal.
Question1 (5 marks)
Problem statement:
A shop has a list of electronic products to sell,which includes mobile phone,TV, Movie, etc..Each product has a product number , a name , a price, a category, and a description.Each product is made by a single company only. Each company has an organization code ,an organization name, an address, and telephone.
People will visit the shop and purchase products. When a person makes an order, his/her name,address,phone number, and the order time will be recorded, the person will be given a unique customer ID.
A person can buy more than one products in our order.
Exercise 1:
Describe the elements (entities,attributes and relationships) of the table of this database system.
Exercise 2:
Draw the Entry Relationship Diagram (ERD) of the generated tables
