Reference no: EM133163857
Data Modelling and Database Design - 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 data 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:- Case Scenario.rar
|
Receive a income verification document
: You work in HR management: You receive a income verification document from an apartment complex to verify an employee's income. The document that was submitted
|
|
How does fortune or glassdoor obtain information
: How does Fortune or Glassdoor obtain their information to create their lists? Describe the criteria and methodology employed by Fortune and Glassdoor.
|
|
How about pricing strategies
: Look at your chosen product/service, how are they positioning it with competitors? How about pricing strategies? How are they pricing their product/service.?
|
|
Aging of the workforce
: Do you think that Japan, Korea, and China will be able to contend with the four major HR challenges that confront them? Why or why not? The four challenges are
|
|
Data Modelling and Database Design Assignment
: Examine the role of data in an organisation, and develop solutions related to the creation, storage and management of organisational data
|
|
Discuss branding and branding efforts
: What is branding in the context of your Course Project? Why is it important to consider and discuss branding? What should you and your team exclude? Why?
|
|
Receiving chemotherapy and radiation
: For the following scenarios, determine what condition(s) you would code and why. After discussing what conditions you would code, please provide the correct cod
|
|
Driving process improvement and motivating
: You have the following job description. After you read it carefully, you will be responsible to answer the below 5 questions taking into consideration that you
|
|
How much will carl accumulate
: If Carl reinvests his dividends each year and the dividends earn a return of 5 percent each year, how much will Carl accumulate in 14 years
|