Advanced Database Management Systems Assignment

Part 1 – Questions

1. What are the main strategies for system acquisition? What are the selection criteria  for them? 
2. What are the main types for system architectures? What are the selection criteria  for them? 
3. Give another example of attributes over relationships. Draw the ER diagram for it. 
4. Sometimes the business rules related to ERD are vague and unclear. How to address  this issue? 
5. Write an SQL statement to select the names and emails of all students and all  staff involved in the unit 300977. 
6. Write an SQL statement to find out the guest who has booked at least 3 rooms in  the same hotel by using nested/sub queries. 

Part 2 – Practices

SAD – Entity Relationship Diagram (ERD). Draw an Entity Relationship  Diagram for the final project (Fitness centre System) based on the business  rules obtained in the analysis phase. Note: You need to submit your ERD,  which should be included in the final project report. Make sure that you 

1. have identified the basic entities, relationships and their associations;  Note that it’s very crucial to link logically closer entities together;
2. have identified the basic attributes needed in order to meet the  business requirements identified in the analysis phase; 
3. have correctly specified the constraints; 
4. have identified the primary keys of entities; 
5. have some advanced features, e.g., weak entities, attributes  over relationships and generalisation/specialisation. 

You need to at least create the ERD. You should draw your diagram  using Lucid chart to the above question.

Part 3 – Practices

SQL – outer join and nested query. 

1. Select the guest names and prices of the rooms they booked, if any. 
2. Select the guest names and the overall prices of the rooms they booked,  if any. 
3. Create a new table staff with the attributes (staffNo, staffName, email, address, salary) and specify that staffNo is the primary key and staffName  must be not null. 
4. Insert some values into staff table as follows: 
5. Show all staff names and guest names. 
6. Select the name of someone who is both a staff and a guest using the  intersect keywords. Is there some issue with this? 
7. Select those staffs who are not guests. 
8. Select all rooms with a price below half of the more expensive room. 
9. Select all the guest names who have booked a room with a price above  average. 
10. Select the guest names who have booked more than 3 rooms. 

Note: for comparison purposes, you’d better keep all records of your SQL  statements (simply save them in a separate .txt). Take screen shots. 

Get your Advanced Database Management Systems assignment solved by our Database Experts from Exam Question Bank . Our Assignment Writing Experts are efficient to provide a fresh solution to all 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 Turn tin file), expert quality assignment or order an old solution file that was considered worthy of the highest distinction.