Principles Of Database Management - IT/Computer Science Assignment Help

Assignment Task

Guidelines 
• This assignment must be handed in electronically as 1 pdf before December 11th, 2020,  4PM by mailing it to: Rafaël Van Belle rafael.vanbelle@kuleuven.be The subject of your  email should be: assignment PDBM. 
• The assignment has to be made individually. Multiple solutions may be possible. If certain  assumptions are made: please list them clearly in your solution!  
• Do not exceed the maximum number of pages. Marks will be subtracted for including  appendices. 
Question 1
Construct the EER model for the below problem. Document your solution: if there are aspects that  can’t be included in the EER model, list them clearly.  
One of your (hipster) acquaintances thinks he has the next billion dollar start-up idea for an  app: Pizza Delivery with Entertainment. He heard from other people that you are following the  course on database management, and asks you to design the EER model. Afterwards, he will  use the EER model to ask programmers to implement the app.  
He explains the basic functionality of the app as follows: customers can order pizzas from  restaurants to get delivered to a specific address, and if they want to, they can choose a special  ‘entertainment order’. When an order is an entertainment order, the delivery person stays with the  customer after delivering the pizza and entertains the customers (by e.g. singing, making jokes,  doing magic tricks, …) for a certain amount of time. Now follows a detailed explanation of the  range of capabilities of the app.  
When people create an account for the app and become app users, they have to indicate their  birthday and fill in their name and address. Every user should also be uniquely identifiable.  
Once the account is created, the users should be presented with three options. 
Also a special type of order can be made: the entertainment order. Not every order has to be an  entertainment order. But when a hungry customer indicates that he or she wants to be entertained  while eating the pizza, we not only want to register all the regular order information, but also the  type of entertainment the user requests, and for how long (a duration).  
The third option in the app to select is that of ‘entertainer’. When users select entertainer, they need  to provide a stage name, write a short bio about themselves, and indicate their price per 30 minutes.  Every entertainment order is fulfilled by exactly one entertainer. Every entertainer can choose for  which pizza restaurant(s) he or she wants to work. For each pizza restaurant an entertainer wants to  work with, he or she should indicate his or her availability by day (Monday, Tuesday, Wednesday,  …). 
Question 2 
Consider the following EER model for a governmental building permit request service. Each city  has a number of local authority services. These local authority services issue building permits,  which can be commercial building permits (but don’t have to be). In each city reside a number of  legal entities, which are either individuals or businesses. Only businesses can own commercial  building permits, but all legal entities can apply for building permits. 

Map the EER model to a relational database model. Also discuss the possible loss in semantics in  the relational database model.  
Include the following aspects:  
• Indicate the primary keys/foreign keys 
• NULL declarations (if there are any) 
• On Delete and On Update integrity rules 
• Extra integrity rules that could be enforced by the application code 
Question 3 
Map the EER of question 2 model to a UML data model. Also include some examples of operations  that could be added to model extra semantics. 
Question 4 
Given the following well-known normalized relational model which was also used in the course  (primary keys are underlined, foreign keys are in italics): 
• Write an SQL join query which retrieves the product number and supplier numbers of  all unique pairs of suppliers who supply the same product, along with their product  purchase prices. 
• Write a correlated SQL query to retrieve the number and status of all suppliers, except  from the eleven (11) suppliers with the lowest supplier status. 
• Write an SQL query using the (NOT) EXISTS operator to select the supplier name,  supplier address and supplier city of all suppliers who can at least supply 1 product.

 • Write an SQL query with ALL or ANY to retrieve the name of the supplier with the  highest supplier status. 
• Write an SQL query to retrieve the number and name and total ordered quantity of all  products that have been ordered, except for the product with the highest outstanding  ordered quantity.

This IT/Computer Science Assignment has been solved by our IT/Computer Science Experts at My Uni Paper. Our Assignment Writing Experts are efficient to provide a fresh solution to this question. We are serving more than 10000+ Students in Australia, UK & US by helping them to score HD in their academics. Our Experts are well trained to follow all marking rubrics & referencing style.

Be it a used or new solution, the quality of the work submitted by our assignment experts remains unhampered. You may continue to expect the same or even better quality with the used and new assignment solution files respectively. There’s one thing to be noticed that you could choose one between the two and acquire an HD either way. You could choose a new assignment solution file to get yourself an exclusive, plagiarism (with free Turnitin file), expert quality assignment or order an old solution file that was considered worthy of the highest distinction.