ICT285 Databases TMA 2017 Assignment 2 Worth: 20% of your final grade. Due: Sunday 30 July...

Question

ICT285 Databases TMA 2017 Assignment 2 Worth: 20% of your final grade. Due: Sunday 30 July XXXXXXXXXX:55PM Submit to: LMS, via the Assignments tool. Submit Parts 1 and 2, Part 3 sample data and Part 4 CREATE VIEW statements as a SINGLE Word document. Parts 3 and 4 should be completed in Oracle on arion. Ensure you complete the declaration that is part of the submission process. You do not need to include a separate cover sheet but you should include your name and student number as part of your document filename. Your name and student number should also be included within in the assignment document. Late assignments that do not have an extension will be penalised at the rate of 5% p
	
Document Preview: ICT285 Databases 
TMA 2017 
Assignment 2 
 
Worth:  20% of your final grade.  
 
Due:  Sunday 30 July XXXXXXXXXX:55PM 
   
Submit to:  LMS, via the Assignments tool. Submit Parts 1 and 2, Part 3 sample data and 
Part 4 CREATE VIEW statements as a SINGLE Word document.  Parts 3 and 4 
should be completed in Oracle on arion. 
 
Ensure you complete the declaration that is part of the submission process.   
You do not need to include a separate cover sheet but you should include 
your name and student number as part of your document filename. Your 
name and student number should also be included within in the assignment 
document.  
 
Late assignments that do not have an extension will be penalised at the rate of 5% per day. 
 
   This is an INDIVIDUAL assignment.  
 
This assignment requires you to implement the database you designed to address the 
requirements of the FastFoods4U case study in Assignment 1.  You will need to incorporate 
any changes you may need to make to your design as a result of the feedback on 
Assignment 1 both individually and as a class (e.g. on the online forum), and to address the 
additional/amended requirements listed in this document.   
 
The assignment addresses the following learning outcomes for the unit: 
 
3. Demonstrate practical skills in using SQL  
5. Demonstrate practical skills in normalisation and convert a conceptual database 
design to a logical design in 3NF 
6. Create a database from a given design using a DBMS and implement specified 
constraints using appropriate tools and approaches  
7. Explain and implement security as it applies in the database environment. 
 
Marks are distributed as follows: 
 
Part 1: Revised ERD and schema 10 
Part 2: Data dictionary 20 
Part 3: Implementation  30 
Part 4: Views 40 
Total 100Case study 
Re-read the description of the FastFoods4U case in Assignment 1 if you need to refresh your 
memory. 
Bill is pleased with your work so far and asked you to go on to implement your design. He has...

David · Accepted Answer

FastFoods4U
In this  project we define customer table where one customer  order delivered more than one address so we create customer table and address 
table so one customer have more than one address .Custid is primary key in Customer table and Foreign key in Address table.  
We define Driver table, dish table, Restaurant table, OrderMeal table,DeliveredOrder table .Driver can take more delivery order  more than one 
customer and area wise so area wise they collect the delivery order so define area code ,driver id primary key and in oredermeal and 
deliveredorder is foreign key so we can easily check order meal status and pending status.Dish Table store the information about Earth First 
Food so if customer want to show the information about the dishes information .Dish table primary key attach with delivery table and order meal
The Entity-Relationship Diagram
Driver
Customer
DeliveredOrder
Addresses
Dish
Restaurant
OrdererdMeal
DATA Dictionary
Dish Table 
Field Name    Data Type   Other information 
DishID                        Number                  primary key 
Name                    character      50 
Price      Number   
Number of dishes    Number   
Dish type     Text     20         
 Dish rating     Text                 20
Restaurant   Table 
Field Name    Data Type   Other information 
RestID                        Number                  primary key 
Name                    character      50 
amount     Number   
Order dishes       Number   
Address    Text     50         
 Dish Prepare     Text                 20
Customer   Table
Field Name    Data Type   Other information 
CustID                        Number                  primary key 
Name                    character      50 
AddId     Number
Address Table 
Field Name    Data Type   Other information 
custId      Number                  primary key 
Address                  character      50 
Areacode     Text     20 ,not null,

ICT285 Databases TMA 2017 Assignment 2 Worth: 20% of your final grade. Due: Sunday 30 July XXXXXXXXXX:55PM Submit to: LMS, via the Assignments tool. Submit Parts 1 and 2, Part 3 sample data and Part 4...

Solution

Answer To This Question Is Available To Download

Related Questions & Answers

Submit New Assignment