Databases Pizza Delivery Shop Database Design Project
Term Project Guidelines (Due 12th week) 6th August 1159PM Complete this project either individually or in group of two. 1 Student: Min 5 Tables, 2 Students: min 10 Tables in the database Min 10 rows in each table 1. Choose a project of your choice e.g. e-Commerce, Car Rental etc. Search Google for ideas. 2. Create an initial database design (ER Model) for your project. 3. Generate business rules from the ER Model. 4. Indicate attributes, entities, primary key and relationships. 5. create all the tables using the information provided in the ER model. 6. Display all the table in table format with the data type and data description, length, default value – OR describe each column of the table as per the below format. Example Table Name: Attribute Description Key Type/ Constraint Data Type Filed length 7. Create and execute all the SQL statements needed to add the constraints 8. Create and alter the tables based on the needs (min 7 tables: 1 Student, min 10 tables: 2 Students, min 10 data rows in each table) 9. Save the changes permanently to the database 10. Insert appropriate values in all the tables 11. Query your database: Design and execute 5 SQL statements that involve these 5 operations – DML, Operators, Functions, Joins, and Grouping. (Hint: Ask a question and write an SQL to answer your question involving the above mentioned 5 clauses) 12. Document your work in word document. Rubrics 5% – ER model 5% – Table creation 5% – Query (DML, operators, Functions, joins, grouping) Examples: e-Commerce. Car Rental.
Collepals.com Plagiarism Free Papers
Are you looking for custom essay writing service or even dissertation writing services? Just request for our write my paper service, and we'll match you with the best essay writer in your subject! With an exceptional team of professional academic experts in a wide range of subjects, we can guarantee you an unrivaled quality of custom-written papers.
Get ZERO PLAGIARISM, HUMAN WRITTEN ESSAYS
Why Hire Collepals.com writers to do your paper?
Quality- We are experienced and have access to ample research materials.
We write plagiarism Free Content
Confidential- We never share or sell your personal information to third parties.
Support-Chat with us today! We are always waiting to answer all your questions.
