User Account

All Pages

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

  Explaining content of document in natural language

Explain the content of this document in natural language;Design the graph representation of document;

  Ensure the security of organizations distributed database

How can you make your database more hacker proof? How do you ensure the security of an organizations distributed database?

  Potential sales and department store transactions

Identify the potential sales and department store transactions that can be stored within the database and design a database solution and the potential business rules that could be used to house the sales transactions of the department store.

  What is the highest normal form r is in

What functional dependencies can you conclude from the data above and what is the highest normal form R is in?

  Electronic spreadsheets in data modeling

Explain in detail with supporting illustrations the six stages of the problem solving process and explain when the choice for using electronic spreadsheets is the preferred tool of choice.

  Write sql statement to retrieve all data sorted in order

Generate the view called RepairSummary which shows only RepairInvoiceNumber, TotalCost, and TotalPaid. Illustrate the SQL statement to retrieve all RepairSummary data sorted by TotalCost.

  Integrity constraint prevent-data inserted in table

Integrity constraint prevent from happening when data is inserted in table which contains this constraint? Let INSERT, UPDATE, and DELETE actions on both child and the parent.

  Timetabling system - write an sql function

With the new UNSW timetabling system, the LIC of each course is required to specify what facilities they require in their classrooms as one of the inputs to the timetabling process. Write an SQL function to provide a list of rooms that contain a g..

  Describe the importance of using sub queries in a database

1. Extracting and interpreting data can be very valuable to an organization. Describe the importance of using sub queries in a database system. Provide at least two business case scenarios to support your response.

  Give preliminary information on data requirements for gis

You have been requested to give preliminary information on the data requirements for a GIS which is to be used to hold inventory of continental scale vegetation maps for coarse scale land surface

  Drawing active directory hierarchy in terms of forests

Draw Active Directory hierarchy in terms of forests, trees, domains, organizational units, and sites which are most suitable for this company and their security concerns.

  What problems could be caused by not having indexes

What problems could be caused by not having appropriate indexes and what problems could be cause by having too many indexes?

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!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

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