VIII. ACCESS

1.    What fault can you see in the design of this database? (in terms of table structure) 
- Data duplication: Firstname, Surname,DOB, Course Name - Data integrity: Brown Mary has different DOB

2.    Describe a problem that would be caused by this fault.

Data duplication --> data integrity issue (like Brown Mary has different DOB, data storage (waste of disk space for storing same data (number, firstname...)

3. Describe briefly how you would redesign the database table to fix the fault.

Should create extra tables to separate the original tables:
- table 1: store student information (Number, FN, LN, DOB)
- table 2: store Course Information (CCODE, CN, Coordinator)
- table 3: store Student-Course enrolment (Number, Ccode, Enrolment Date)

4. You work for RMIT Consulting Services as a Systems Analyst. You have been called in to do an analysis of Just Juice’s ordering requirements.

6 MARKS

The sales management section at Just Juice keeps data on sales that are made. A preliminary analysis has indicated the following facts:

•  Each customer can place many juice orders, each order is placed by one customer. Information about the customer includes name, address, and contact number.

•  Each order can contain multiple soft drink items (item id, item price, and item description). Order date and order number are stored for each order.

•  Customers can require delivery of the order. Once an order has been delivered, it’s marked “delivered’ in the delivery status. 
Represent the situation as an Entity-Relationship diagram, taking into account the description above (resolve any many-to-many relationships).