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.


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

Have any Question or Comment?

Leave a Reply

Have a similar question?

Ask your homework question

 

Enjoy Our Unique Features!

INDIVIDUAL APPROACH:
Chat with every writer who applies to your request, and view their skills and portfolio. Make the choice that’s right for you.
MANAGE YOUR ORDER:
Monitor progress and see any changes made. Have full control over every phase of the process.
COMMUNICATE:
Ask your writer questions and provide your ideas about your paper. Produce the exact result that you want.
ENJOY THE OUTCOME:
Get everything done on time with high quality. Writing papers is much simpler with us.

Submit Your Instructions to Writers for FREE!!

Ask your homework question

 

© 2017 theacademicessays. All Rights Reserved. Design & Developed by theacademicessays.

POST YOUR QUESTION FOR FREE

Click Here to get instant solution!
X myStickymenu
Loading...