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

  Developing the software development plan

The final step in developing the software development plan is to conduct a risk assessment for the project. This is an area often overlooked in software development plans, but it can make a tremendous difference in the success of the plan

  Creating a modularized body mass index program

Create a modularized Body Mass Index (BMI) Program which will compute the BMI of a team player.

  Sap community network portal

Identify any manufacturing company that belongs to the list of industries on SAP community network portal; who implement SAP system and enjoying its benefits.

  Identify all functional requirements the gui must support

Develop a persistence mechanism using data access objects for the domain objects involved in the CCRD use case.

  Identify the abstraction of classification entity types

Identify all the important concepts represented in the library database case study described here. In particular, identify the abstraction of classification entity types.

  Compare and contrast three basic approaches to training

Compare and contrast three basic approaches to training. What is the role of the operations group in the systems development life cycle (SDLC)

  Explain the results of all three performance measures

Analyze and explain the results of all three performance measures in 1-2 pages. 10% List the actions you will take to resolve any performance issues you discovered.

  Describe the role of the soap

Describe the three entities and three operations that represent the Web Services model defined by SOA. (Support your answer with a diagram) Describe the role of the following three core Web Service standards- i SOAP ii WSDL iii UDDI

  Process of designing an er diagram

Does the process of designing an ER diagram ever require more than one iteration? Why or why not?

  User experience is very important to the success

The quality of the user experience is very important to the success of an application. In the early days of computing, users often experienced long delays since computing power was poor and networks had comparatively slow throughput.

  1 describe each law in your own words illustrate with a

1. describe each law in your own words. illustrate with a practical example.2. your first task is to describe each

  Analysis of the company value proposition market position

the end result of this course is developing a strategic audit. in this module you will outline and draft a preliminary

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