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

  Create entity-relationship diagram for bookstore database

Create Entity-Relationship diagram for a bookstore database, that maintains information about books, professional journals, their authors, and publishers.

  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.

  Write an sql query

Write an SQL query to get the author of the book "The Alchemist"

  Explaining uses for views

Views are integral part of virtual private databases, yet views are utilized for many other reasons. Find out many other uses for views.

  List all the functional dependencies present in the relation

You must implement the entity relationship model provided in the model solution to Assignment 1. The model solution will be released on the course website approximately TWO (2) weeks after the Assignment 1 due date.

  Create an actual web page document

Modify the XML document in Exercise 2 to include a namespace URL from which the elements of the XML document in Exercise 3 will be associated with. Make any changes to the XML document that are necessary as a result of the namespace URL inclusion.

  Explain what do business rules require to be effective

What are the advantages of having the DBMS between the end user's applications and the database. What are some reasons for studying file systems. IT 645 - Database Management Systems

  Covert the extended entity relationship diagram

Covert the Extended Entity Relationship Diagram (EERD) for Orthopedic Alliance of Plano (OAP) described in assignment one to relations. See Lecture 5, slide 22 for relational schema.

  How to use spool command

How to interactively query a database by using SQL statements and SQL*PLUS commands and how to use spool command to save an interactive session within SQL*PLUS.

  Create database for easydrive school of motoring

Create mission statements and mission objectives for database systems explained in the following case study EasyDrive School of Motoring. Also in mission objectives include 10 reports that the database system must support

  Design tables in 3nf various codes for at least three fields

Create tables in 3NF. As you create the database, include different codes for at least three of the fields. Use sample data to populate fields for at least three records in each table.

  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.

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