$20 Bonus + 25% OFF
Securing Higher Grades Costing Your Pocket?
Book Your Assignment at The Lowest Price
Now!
COMP1140 Database and Information Management
Referencing Styles :
APA | Pages :
13
- Course Code: COMP1140
- Course Title: Database and Information Management
- University: The University of Newcastle
- Country: AU
Task:
In this assignment, steps in the physical database design are conducted (as described below) as well as revising the concept database design and logic database design of assignment 1 and assignment 2, and a final report of the project is written.
This assignment has 3 parts as specified below.
1. Revise the concept database design and logic database design, based on your revision and the feedback provided by your marker. I.e., do the following three steps:
1.1 Do concept database design, including Requirement Specification (including data requirements, transaction requirements and business rules), and EER Diagram and Data Dictionary.
1.2 Map the EER model to the relational model. Document the relational schema in DBDL
1.3 Normalize the relational schema to Boyce-Codd Normal Form (Point out what norm form each relation is in, do the normalisation if any relation is not already in BCNF.). The final normalised schema must be documented in DBDL.
2. Complete major steps in the physical database design
2.1 Write SQL scripts that create the normalised Delitaste Pizza database, including all necessary tables with the right parameters such as primary key, foreign key, default value.
2.2 Write SQL statements satisfying the transaction requirements including:
2.2.1 Input proper data (as you consider legitimate) of at least three rows for every table, and
2.2.2 Implement the following queries (make sure to populate with enough and proper data into related tables so that non-void result is shown for each query. A query will be given zero mark if it has void output or no output). Note: in the queries, the values of ttt, xxx, yyy, zzz, etc., can be the corresponding values in your database.
Q.1 For an in-office staff with id number xxx, print his/her 1stname, lname, and hourly payment rate.
Q.2 List all the ingredient details of a menu item named xxx.
Q.3 List all the shift details of a delivery staff with first name xxx and last name ttt between date yyy and zzz
Q.4 List all the order details of the orders that are made by a walk-in customer with first name xxx and last name ttt between date yyy and zzz.
Q.5 List all the order details of the orders that are taken by an in-office staff with first name xxx and last name ttt between date yyy and zzz.
Q.6 Print the salary paid to a delivery staff named xxx in the current month. Note the current month is the current month that is decided by the system.
Q.7 List the name of the menu item that is mostly ordered in the current year. Note the current year is the current year that is decided by the system.
Solutions
OR
MyAssignmenthelp.com has gained popularity among Australian students due to its commitment to providing best quality assignment help. We keep up our reputation by appointing best-qualified experts from different cities of Australia. They are committed to providing extraordinary academic writing services to all students, who need assignment help to put up a good quality assignment. Students can also avail urgent assignment help from us in case they have a short deadline to meet.
We Can Help!
Are you confident that you will achieve the grade?
Our best Expert will help you improve your grade
Refer & earn
Just refer 5 friends to earn more than $2000.
Still in Two Minds? The Proof is in Numbers!
33845 Genuine Reviews With a Rating of 4.9/5.
Finance
Programming: 6 Pages, Deadline:
6 days
I am very happy with this web, and I will definitely recommend my friends to use this service.
User ID: 2***6 Sydney, Australia
Healthcare
Assignment: 7.2 Pages, Deadline:
16 days
I was about to fail in my last paper but because of my assignment help web, I have passed my last paper with fair marks.
User ID: 2***6 Sydney, Australia
Business Law
Assignment: 4 Pages, Deadline:
2 days
it was a very good exprience for making assignments from this website. the work was good.
User ID: 2***6 Sydney, Australia
It Write Up
Assignment: 6 Pages, Deadline:
4 days
I was very happy about this assignment. The works has been done perfectly and the solution was satisfying
User ID: 5***03 Australia
Business Law
Home Work: 10 Pages, Deadline:
4 days
I wasn’t expecting this good. This assignment was very helpful and the teachers were satisfactory with that
User ID: 5***03 Australia
Accounting
Home Work: 1 Page, Deadline:
6 days
Thank you for your professionalism and being on time with the deadline. Very much appreciated.
User ID: 4***65 Australia
Business Law
Essay: 1 Page, Deadline:
2 days
Great work. Very impressed. The assignment was completed thoroughly and as instructed. I will be happy to use this service again and will recommend it …
User ID: 8***91 United States
Healthcare
Assignment: 4.4 Pages, Deadline:
13 days
Great work with my assessment I will refer to my friends and other student to use this website aswell. They have a lovely team and goid discount.
User ID: 7***34 Melbourne, Australia
Biology
Assignment: 2 Pages, Deadline:
9 days
The solution came early than expected. Everything is set as I requested. The solution is detailed.
User ID: 7***78 United States
Assignment
Home Work: 0 Pages, Deadline:
20 hours
awesome work by the expert they put their everything into. Hopefully, I will get full marks, I will be over the moon. thank you so much.
User ID: 8***87 New Zealand
Finance
Programming: 6 Pages, Deadline:
6 days
I am very happy with this web, and I will definitely recommend my friends to use this service.
User ID: 2***6 Sydney, Australia
Healthcare
Assignment: 7.2 Pages, Deadline:
16 days
I was about to fail in my last paper but because of my assignment help web, I have passed my last paper with fair marks.
User ID: 2***6 Sydney, Australia
Business Law
Assignment: 4 Pages, Deadline:
2 days
it was a very good exprience for making assignments from this website. the work was good.
User ID: 2***6 Sydney, Australia
It Write Up
Assignment: 6 Pages, Deadline:
4 days
I was very happy about this assignment. The works has been done perfectly and the solution was satisfying
User ID: 5***03 Australia
Business Law
Home Work: 10 Pages, Deadline:
4 days
I wasn’t expecting this good. This assignment was very helpful and the teachers were satisfactory with that
User ID: 5***03 Australia
Accounting
Home Work: 1 Page, Deadline:
6 days
Thank you for your professionalism and being on time with the deadline. Very much appreciated.
User ID: 4***65 Australia
Business Law
Essay: 1 Page, Deadline:
2 days
Great work. Very impressed. The assignment was completed thoroughly and as instructed. I will be happy to use this service again and will recommend it …
User ID: 8***91 United States
Healthcare
Assignment: 4.4 Pages, Deadline:
13 days
Great work with my assessment I will refer to my friends and other student to use this website aswell. They have a lovely team and goid discount.
User ID: 7***34 Melbourne, Australia
Biology
Assignment: 2 Pages, Deadline:
9 days
The solution came early than expected. Everything is set as I requested. The solution is detailed.
User ID: 7***78 United States
Assignment
Home Work: 0 Pages, Deadline:
20 hours
awesome work by the expert they put their everything into. Hopefully, I will get full marks, I will be over the moon. thank you so much.
User ID: 8***87 New Zealand
COMP1140 Database and Informat… has been added in your library.
Create/Access Your Library
It is too easy to create or access your own library, just enter your email and make your search
easy.
Bookmark useful samples and answers
&
Enjoy all benefits of creating own library
Benefits of Your Own Library
MyAssignmenthelp.com stores a huge
COLLECTION OF QUESTIONS AND SAMPLES, which you can refer to any time you want.
Every time you find something useful, you can save that using the bookmark tool. From the next time,
you
can access that from your personalized library.
Have any Query?
- Assignment status: Already Solved By Our Experts
- (USA, AUS, UK & CA PhD. Writers)
- CLICK HERE TO GET A PROFESSIONAL WRITER TO WORK ON THIS PAPER AND OTHER SIMILAR PAPERS, GET A NON PLAGIARIZED PAPER FROM OUR EXPERTS
