Take normalized tables to create erd

Assignment Help Software Engineering
Reference no: EM13854453

Sample Data

 

 

 

 

 

 

 

 

PROJ.
NUM.

PROJECT NAME

EMPLOYEE NUMBER

EMPLOYEE NAME

JOB CLASS.

CHG' HOUR

HOURS BILLED

TOTAL CHARGE

15

Evergreen

103

June E. Arbough

Elec. Engineer

$ 85.50

23.8

$ 2,011.10

 

 

101

John G. News

Database Designer

$105.00

19.4

$ 2,037.00

 

 

105

Alice K. Johnson*

Database Designer

$105.00

35.7

$ 3,748.50

 

 

106

William Smithfield

Programmer

$ 35.75

12.6

$    450.45

 

 

102

David H. Senior

Systems Analyst

$ 96.75

23.8

$ 2,302.65

 

 

 

 

Subtotal

 

 

$10,549.70

18

Amber Wave

114

Annelise Jones

Applications Designer

$ 48.10

25.6

$ 1,183.26

 

 

118

James J. Frommer

General Support

$ 18.36

45.3

$    831.71

 

 

104

Anne K. Ramoras*

Systems Analyst

$ 96.75

32.4

$ 3,135.70

 

 

112

Darlene M. Smithson

DSS Analyst

$ 45.95

45.0

$ 2,021.80

 

 

 

 

Subtotal

 

 

$ 7,172.47

22

Rolling Tide

105

Alice K. Johnson

Database Designer

$105.00

65.7

$ 6,793.50

 

 

104

Anne K. Ramoras

Systems Analyst

$ 96.75

48.4

$ 4,682.70

 

 

113

Delbert K. Joenbrood*

Applications Designer

$ 48.10

23.6

$ 1,135.16

 

 

111

Geoff B. Wabash

Clerical Support

$ 26.87

22.0

$     591.14

 

 

106

William Smithfield

Programmer

$ 35.75

12.8

$     457.60

 

 

 

 

Subtotal

 

 

$13,660.10

25

Starlight

107

Maria D. Alonzo

Programmer

$ 35.75

25.6

$    879.45

 

 

115

Travis B. Bawangi

Systems Analyst

$ 96.75

45.8

$ 4,431.15

 

 

101

John G. News*

Database Designer

$105.00

56.3

$ 5,911.50

 

 

114

Annelise Jones

Applications Designer

S 48.10

33.1

$ 1,592.11

 

 

108

Ralph B. Washington

Systems Analyst

$ 96.75

23.6

$ 2,283.30

 

 

118

James J. Frommer

General Support

$ 18.36

30.5

$     559.98

 

 

112

Darlene M. Smithson

DSS Analyst

$ 45.95

41.4

$ 1,902.33

 

 

 

 

Subtotal

 

 

$17,559.82

 

 

 

 

Total

 

 

$48,942.09

1. Normalize data to 3rd normal form

2. Consolidate forms and name remaining tables

3. Take normalized tables to create ERD

Reference no: EM13854453

Questions Cloud

Differences and similarities in how the branches of islam : Describe significant differences and similarities in how the branches of Islam (Sunni, Shiite, and Sufi) practice their traditions.
Which dsm-5 label might match this disorder : Everyday for at least the past week she felt irritable with persistently increased energy and talkativeness, was easily distracted and did not seem to need sleep and noticed that this behavior was interfering with her job. She reported that she felt ..
Political prisoners in the world : Yes, there are political prisoners in the world. Unfortunate men and women, certain classes, and political dissidents are still suffering in some areas of the world. Read the Wolman article, South Korea's response to human rights abuses in North Kore..
What are the major differences between baroque and rococo : What are a few of the major differences between Baroque and Rococo. Give an example of a work of art in Rococo you think is the most beautiful you've seen in this period (hating the enitre period is not an option, find the most beautiful or the le..
Take normalized tables to create erd : Normalize data to 3rd normal form and consolidate forms and name remaining tables and Take normalized tables to create ERD
The term oligopoly refers to : The term oligopoly refers to
An example of us revaluation in psychology : An example of US revaluation in psychology in diagram form. Use the appropriate abbreviations to label each component.
An example of overshadowing in psychology in diagram form : An example of overshadowing in psychology in diagram form. Use the appropriate abbreviations to label each component.
Find the indirect utility function : Find the indirect utility function

Reviews

Write a Review

Software Engineering Questions & Answers

  Define complete professional-development requirements

Once an activity has been completed, employees will use the system to submit the documentation. The system should support notifications to management personnel whenever their direct reports have submitted documentation. The system should also noti..

  Question about ranges and functions

Assume you have functions that you want to call for many individual year values, as well as ranges of years, and you are deciding on whether to use an if statement or a switch statement.

  Difference between encapsulation and information hiding

Discuss and explain the difference between encapsulation and information hiding. In addition, describe the role both of these concepts play in helping to make designs more robust and extensible.

  Describe purpose of the keyword super in programs

Describe purpose of the keyword super in programs

  Which of the following reasons contributed to that decision

Model-View-Controller pattern can be used within the Client-Server implementation to create the operator view?

  Create the diagram 0 dfd for new century

Create the diagram 0 DFD for New Century. Make sure to illustrate numbered processes for handling appointment processing, payment and insurance processing.

  Discuss how the erp software can be adapted

Please take an example of a service industry and discuss how the ERP software can be adapted to that industry. Will it be as effective in the service sector as in the manufacturing sector?

  Data entry screen for a hotel registration system

Design on sample data entry screen for a hotel registration system using the data entry guidelines provided in this chapter (see table 11-6). Support your design with arguments for each of the design choices you made

  Question about case tools

From your personal experiences explain how CASE tools have improved the system development cycle.

  Developing domain model class diagrams

The stock levels of each item are changed by the system with each purchase. However these levels need to be manually updated by a clerk in certain cases such as shipments of items from manufacturers, refunds, exchanges, etc.

  Draw entity relationship model for project management system

A consultant is not necessarily a project leader, but they can only be project leader for one project. Draw an entity relationship model for the project management System.

  Assignment on information technology

As the grading for the Current Events Ethics Analysis Assignment is criterion-based, you need to carefully read the assignment description (quoted below) and follow it like a checklist to make sure you address all assignment criteria.

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