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

Previous Q& A

  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

  Explain what will the ph of the resulting naoh solution be

If .090 mole of solid NaOH is added to 1.0 liter of .180 M CH3COOH, what will the pH of the resulting solution be

  Determine what is the addition to retained earnings

Travis, Inc., has sales of $393,000, costs of $181,000, depreciation expense of $46,000, interest expense of $27,000, and a tax rate of 30 percent.

  What is the friction force acting on the bag

A child leaves her book bag on a slide. The bag, which is at the top of the slide, starts from rest and reaches the bottom in 1.40 s. What is the friction force acting on the bag

  What is the net present value of project given a required

At the beginning of the project, inventory will decrease by $16,000, accounts receivables will increase by $21,000, and accounts payable will increase by $15,000. All net working capital will be recovered at the end of the project.

  Compute eo, e and deltag for the cell reactions

Calculate Eo, E, and deltaG for the following cell reactions Mg (s) + Sn2+ (aq) Mg2+(aq) + Sn(s) [Mg2+]= 0.045 M, [Sn2+] = 0.035 M

  Describe in a paragraph what plants live in your biome

Write a paragraph that describes your biome. Describe where it is located in the world and specifically in the USA. Describe the climate and seasons of your biome.


Write a Review


Similar Q& A

  Sketch object-oriented model for private airport database

Sketch an object-oriented model for a small private airport database that is used to keep track of airplanes, their owners, airport employees, and pilots.

  Create a database design specification

Create a database design specification (Enhanced Entity Relationship Diagram (EERD) and Relational Data Model (RDM)) from the given business description. The RDM must be in 3rd Normal Form.

  Find the entities from the functional requirements

Find the entities from the functional requirements. Entities can come from Nouns in the text, they may also come from forms, reports and legacy code.

  Identify the data analytics tasks

Provide a clear statement of the aims and objectives of the data analytics study and the possible outcomes in terms of discovered knowledge and its potential application towards solution of the problem. In this section you need to discuss the busi..

  Create a new table named sportinggoods in database

Create a new table named SportingGoods to contain the columns PartNum, Description, OhHand, Warehouse, and Priced for all rows in which the item class is SG.

  Gathering information using cross indexed

Using data mining, it is possible to gather information which has been buried that can be manipulated and cross indexed which could be a valuable information gathering technique for entities.

  Create library database schema structure

The library System stores 3 type of informations: Users ( USID, USNAME, USMob, USEmail, USDept,USStartDate, NofBooks). Create the library database schema Structure.

  How do these change with variation in the condence values

Looking at the predictive accuracy (Percent correct) results for tree learning on these data sets, has learning improved accuracy over the baseline ?

  Analyse the credit approval data set

Analyse the  Credit Approval  data set - A data set description in terms of the attributes present in the data, the number of instances,missing values, and other relevant characteristics.

  How to create a biological database based on viruses

How to decide which attribute should be there in the table and schema? How to identify the primary keys, foreign keys, domain, E-R diagram and 20 Queries on the same database.

  Types of keys used in relational database

Explain with examples different types of keys used in relational database, how they help relating different tables.

  Recognize input data required for each of processes

Recognize input data required for each of processes. Recognize logical name for each data output item and kind of data output (real number, integer, text).

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