Draw an initial entity-relationship model

Assignment Help Database Management System
Reference no: EM13328341

This case study is about a computer systems development company which requires a mechanism for keeping track of the allocation of staff to projects. Study the case study carefully and then submit the following:

1. Draw an initial Entity-Relationship model, stating any assumptions you make.

You will have to make judgements as to what level of detail is appropriate, by taking into consideration the requirements of part (3) below.

2. Normalise the Project Allocation form (Fig 1) to arrive at third normal form entities. Show all the steps of normalisation clearly.

3. Implement and submit adequate documentation for the following:

(a) Create all the database tables needed for implementing the staff-project- allocation system, and populate them with appropriate data of your choice.

Submit Oracle scripts for each table, showing its description and its contents.

(b) Produce the following reports:

• (R1) A list of employees assigned to a particular project.
• (R2) A list of projects which an individual employee is assigned to.
• (R3) A list of projects which complete before a given date.
• (R4) The Project Allocation form (Fig. 1) which appears in the case study.

(c) Now produce two additional reports (R5 and R6) which you believe will be useful in this environment.

Consider extending your schema with either extra data columns or tables for this purpose. Give a clear textual description of what each of your two reports is supposed to show. Use your judgement as to what information the reports should contain and how they should be formatted.

Reference no: EM13328341

Questions Cloud

Construct a spreadsheet simulation to simulate 100 customers : Supermarket customers load their carts with goods totaling between $5 and $200 uniformly (continuously) distributed; call this the raw order amount. Assume that customers purchase independently of each other.
Explain equation for a solution of propanoic acid : Write the Henderson-Hasselbalch equation for a solution of propanoic acid (CH3CH2CO2H, pKa = 4.874 ) using HA and A- in the expression. pH= ? Using this equation, calculate the quotient
Discussion using the milgram experiment : Discuss how regular employees of certain large corporations (such as Enron or Goldman Sachs, etc.) could ignore or support highly unethical and/or illegal financial activities
Explain why is the temperature increased for the second step : in the second step of the Mond process, the gaseous Ni(CO)4 is isolated and heated to 500 K. the equilibrium constant for the above reaction at 500 K is 1.21 x 10^-4. why is the temperature increased for the second step of the Mond process?
Draw an initial entity-relationship model : Normalise the Project Allocation form (Fig 1) to arrive at third normal form entities. Show all the steps of normalisation clearly.
Calculate table of interest rates for 5years based on info : Calculate a table of interest rates for 5 years based on the following information: The pure interest rate is 2% Inflation expectations for year 1 = 3%, year 2 =4%, years 3-5 =5%
Explain the structure of 1-butanol : Consider the structure of 1-butanol and explain why this alcohol does not undergo SN1 reactions.
Find how much can todd afford to borrow to buy a car : Todd is able to pay $360 a month for 6 years for a car. If the interest rate is 6.7 percent, how much can Todd afford to borrow to buy a car
Determine how far will she travel along the flat snow : A snowboarder starts from rest rides 30.31m down a snow covered slope that makes an angle of 34.19 degrees with the horizontal, How far will she travel along the flat snow

Reviews

Write a Review

Database Management System Questions & Answers

  Knowledge and data warehousing

Design a dimensional model for analysing Purchases for Adventure Works Cycles and implement it as cubes using SQL Server Analysis Services. The AdventureWorks OLTP sample database is the data source for you BI analysis.

  Design a database schema

Design a Database schema

  Entity-relationship diagram

Create an entity-relationship diagram and design accompanying table layout using sound relational modeling practices and concepts.

  Implement a database of courses and students for a school

Implement a database of courses and students for a school.

  Prepare the e-r diagram for the movie database

Energy in the home, personal energy use and home energy efficiency and Efficient use of ‘waste' heat and renewable heat sources

  Design relation schemas for the entire database

Design relation schemas for the entire database.

  Prepare the relational schema for database

Prepare the relational schema for database

  Data modeling and normalization

Data Modeling and Normalization

  Use cases perform a requirements analysis for the case study

Use Cases Perform a requirements analysis for the Case Study

  Knowledge and data warehousing

Knowledge and Data Warehousing

  Stack and queue data structure

Identify and explain the differences between a stack and a queue data structure

  Practice on topic of normalization

Practice on topic of Normalization

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd