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

  Research report on software design

Write a Research Report on software design and answer diffrent type of questions related to design. Report contain diffrent basic questions related to software design.

  A case study in c to java conversion and extensibility

A Case Study in C to Java Conversion and Extensibility

  Create a structural model

Structural modeling is a different view of the same system that you analyzed from a functional perspective. This model shows how data is organized within the system.

  Write an report on a significant software security

Write an report on a significant software security

  Development of a small software system

Analysis, design and development of a small software system.

  Systems analysis and design requirements

Systems Analysis and Design requirements

  Create a complete limited entry decision table

Create a complete limited entry decision table

  Explain flow boundaries map

Explain flow boundaries map the dfd into a software architecture using transform mapping.

  Frame diagrams

Prepare a frame diagram for the software systems.

  Identified systems and elements of the sap system

Identify computing devices, which could be used to support Your Improved Process

  Design a wireframe prototype

Design a wireframe prototype to meet the needs of the personas and requirements.

  Explain the characteristics of visual studio 2005

Explain the characteristics of Visual Studio 2005.

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