diff_months: 18

Food Restaurant-Database Design Assessment

Download Solution Now
Added on: 2022-11-04 06:16:21
Order Code: 474217
Question Task Id: 0

Scenario

You will Anthony’s Fast food restaurant as your project scenario. Please refer to Anthony’s Vision to get a background to the company and to understand their strategic directions. This will enable you to build a system which is in line with their goals and direction.

Tasks 

You will work on the design of a database for your project. This is an individual assessment, you may work on different parts of the system, but you need to submit your own individual work.

Complete the following artefacts:

  • Create the conceptual model of the database using UML domain model notation.
  • Convert/create the conceptual ER model using crow’s feet notation.
  • Create the Logical database schema, with the following annotations
    1. Default value, range control, null value control, referential integrity

CONSTRAINT (0 < managerID state=QLD)>

  • Data dictionary
    1. Use data dictionary template
  • Normalization (include this as an appendix in your Design Report)
    1. Exercise 1
    2. Exercise 2
  • Physical design, consisting of:
    1. Composite usage map (data volume and usage analysis)
    2. 1 example of denormalization – with justification
    3. 1 example of horizontal partitioning – for one table with justification
    4. 1 example of vertical partitioning – for one table with justification
    5. 1 example of an index – for one table with justification

You will be taught each technique/modelling tool. You then need to apply it to your part of the system to design the database. Submit your work, and the Instructors will give you feedback. You will correct any omissions or errors and re-submit your work. If they are satisfactory, the Instructor will sign off on the observation sheet.All the above artefacts will ultimately be part of your Design Report (Assessment Event 2 of 2). Refer to the template for content requirements. If it is satisfactory, the Instructor will sign off on the Feedback sheet.

You need to gain a satisfactory mark in both assessment events to achieve a Competent grade in this phase.

  • Uploaded By : Katthy Wills
  • Posted on : November 04th, 2022
  • Downloads : 0
  • Views : 209

Download Solution Now

Can't find what you're looking for?

Whatsapp Tap to ChatGet instant assistance

Choose a Plan

Premium

80 USD
  • All in Gold, plus:
  • 30-minute live one-to-one session with an expert
    • Understanding Marking Rubric
    • Understanding task requirements
    • Structuring & Formatting
    • Referencing & Citing
Most
Popular

Gold

30 50 USD
  • Get the Full Used Solution
    (Solution is already submitted and 100% plagiarised.
    Can only be used for reference purposes)
Save 33%

Silver

20 USD
  • Journals
  • Peer-Reviewed Articles
  • Books
  • Various other Data Sources – ProQuest, Informit, Scopus, Academic Search Complete, EBSCO, Exerpta Medica Database, and more