Reference no: EM132347482

Assignment 1 is designed so that students gain practical experience of designing a database. This assignment can be done either individually or in group of two maximum. Group members have to be from same tutorial. However you need to find the group member yourself. The details are given below.

Details

Consider a scenario where ‘ebay' has asked you to design a new database for their website

Part 1 (Business Rules)

To achieve this, you need to first understand what data will be stored and what business rules are associated with ebay. You need to also consider how data flows between different stakeholders.

Submission: You need to submit a document containing two things on Mylo

1. If done in group, your group details: names, student numbers

2. Business rules which you will cover in designing database for 'ebay'. Word limit- about 500 words

Note: You cannot change your group member or form a group later. However you are allowed to do it individually.

Part 2 (ER Diagram and Relational Model)

Your lecturer will send feedback on your Business rules and some updates will be suggested (Within 3 days). You need to update your business rules based on these feedbacks. These final updated business rules will be used to design conceptual model of database using ER Diagram. You need to use only conventions that are taught in tutorial. If ER diagram is not based on the updated business rules or does not follow conventions, you may lose considerable marks.

Using ER Model, you need to design your relational model using conversion algorithm as taught during tutorial. Give details of each step in the conversion.

You need to submit following in your final document (report):
a) Your Updated Business Rules
b) ER diagram with a short description talking about some optimisation in terms of design you did in your ER diagram.
c) Relational Model
d) Conversion steps from ER Diagram to Relational Model
e) If done in a group of two, a table specifying the contributions of each member.