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
Do You Need A Similar Assignment Done For You From Scratch? We Have Qualified Writers To Help You. We Assure You An A+ Quality Paper That Is Free From Plagiarism. Order Now For An Amazing Discount!
Very professional support! Highly recommended.
Researched complicated topic and delivered report by the requested deadline. The paper is of a high standard reflecting careful research and clear assessments. I recommend iLecturers.com.com
It’s a 5 start for me. Excellent research and writing. The paper reflects a careful assessment of scientific information.
With Gib’s reflection, they wrote a really specific essay. Very well written, containing all of the languages I required and excellent references. The writer follows my instructions and writes clearly in English.
I am so grateful and I am 100% happy with your work.
A fantastic piece of work 👏. The writer demonstrated full knowledge of the topic and applying the relevant provided material. Well done.