Accommodation Office Case Study

Accommodation Office Case Study
May 26, 2016 by
Based on the description of the case determine the mission statement, objectives and system boundary of database project for The University Accommodation Office Case Study.
Identify the userviews and data entities they are interested in. Create Cross-reference of user views with main types of data used by each user group.
Complete the conceptual design of the data base using the top-down design approach. Identify each entity (class), the key attributes and other attributes to meet the current and long term needs of the The University Accommodation Office Case Study. You must enter short description of each entity (class) and attributes (in a separate word document). Draw UML Class Diagram (using UML class diagram notations provided by Visio). Make and list appropriate assumptions about the business rules. Document and justify each of the design decisions made.
Map the above model to relational tables. Identify primary and foreign keys.
Use the bottom-up design approach to get the third normal form relational database design. Use each of the user requirements including reports, forms, screens, files and transaction requirements as user views to be normalized. Integrate the normalized tables arrived from the analysis of each views.
Compare the relational tables arrived from top-down and bottom-up approaches and resolve and differences. The final relational design should be in third normal form. Clearly identify primary and foreign keys.
Validate your design to ensure that all user views can be recreated
Answer not yet available
To have this questions done by our pool of professional writers, kindly send us an email.
Email to
You can also browse for similar questions here
Reseach Reflection
Cultural differences influence on how we interpret our behavior and the behaviors of others

Don't use plagiarized sources. Get Your Custom Essay on
Accommodation Office Case Study
From $8/Page
Order Essay

Calculate the price of your paper

Total price:$26
Our features

Top Homework Writers is here for any paper writing help you need!

Need a better grade?
Custom Paper Writers got you covered.

Order your paper

Save More. Score Better. Use coupon code SPECIAL20 for a 20% Discount