Prepare a modelling report that demonstrates your ability

Assignment Help Database Management System

Reference no: EM133168569

Data Modelling and Database Design

Assessment - Modelling Report

Learning Outcome 1: Examine the role of data in an organisation, and develop solutions related to the creation, storage and management of organisational data.

Learning Outcome 2: Apply contemporary database modelling to identify and address anomalies in data and recommend solutions.

Task Summary

This assessment requires you to prepare a modelling report that demonstrates your ability to assess business requirements along with a logical design that could be implemented in a relational database management system.

Context
When preparing to implement a new information system, it is essential that the initial design is well thought out from the outset. Modifying the database after implementation can often be an expensive process in terms of time, effort and cost. Often the first engagement step is to conduct interviews and workshops with end users and business subject matter experts to get a better understand of how the business runs. The output of these workshops becomes the foundation for the database design.

Task Instructions

Please read the attached Assessment 1_Case Study.

Based on the information provided in the case study, prepare a modelling report to answer the following tasks:

Task 1: An entity relationship diagram including all the significant entities, attributes and their relationships. Use Crow's foot notation.

Task 2: A relational model showing all fields, primary keys, foreign keys and concatenated keys. Your relational model should be in third normal form. List any assumptions/business rules you have made.

Task 3: A sample dummy input screen of scheduling an interview for one of the shortlisted candidates. You have to make sure all the data requirements are being captured.

You may use any tool you like to create this sample screen. Write a brief paragraph of about 200 words discussing the following:

- Does your database design allow the storage of all the required information?
- What changes, if any, did you make to your initial ER diagram and relational model after you created the sample input screen?

The front-end or user interface design enables accessing the data stored in a database. Prototyping the interface also enables capturing initial system and data requirements.

Attachment:- Modelling Report.rar

Reference no: EM133168569

Questions Cloud

What is the appropriate balance for allowance : Before any year-end adjustments, the balance in Tamarisk's Accounts Receivable account was $591,800. What is the appropriate balance for Allowance

Role of criminal justice practitioner : What is the role of criminal justice practitioners in the development and implementation of technology in the criminal justice system?

What can crime statistics tell us about the crime picture : What can crime statistics tell us about the crime picture in America? How has that picture changed over time? What additional changes might be coming?

Prepare the journal entry at january : Prepare the journal entry at January 1, 2021, to record the change in accounting principle

Prepare a modelling report that demonstrates your ability : Prepare a modelling report that demonstrates your ability to assess business requirements along with a logical design that could be implemented in a relational

What price must the guilderian pay for the same : A Guilderian trader buys a 50 Flop barrel of Florish pickles by exchanging 25 Gulps, What price must the Guilderian pay for the same 50 Flop barrel of pickles

Improve policing services : Does community policing offer an opportunity to improve policing services in the United States? Why or why not?

International market-regarding synthetic drugs : What is Canada's role on the international market, regarding synthetic drugs and how does this effect its economy?

What coupon rate should the company set on its new bonds : What coupon rate should the company set on its new bonds if it wants them to sell at par? Assume a par value of $1,000

User Account

All Pages