Solution-Take normalized tables to create erd

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

User Account

All Pages

Take normalized tables to create erd

Reference no: EM13854453

Reference no: EM13854453

Questions Cloud

Reviews

Write a Review

Software Engineering Questions & Answers

Open source technology is a reliable basis for system-level

Decide on the types of accounting and financial records

In software engineering one can find various life cycle

What is missing in qantas website and what can be improve

Define - bugs and flaws and defects

Language without exception handling facilities

Explain some important principles and practices which are

Inventory management

Why six-sigma efforts do not apply to software

Emergency control room for a call-logging component

Prepare a paper an 800 word paper incorporating answers to

Create a weather object using the no-argument constructor

Assured A++ Grade

Academics

Major Subjects

Majors

Get In Touch

TERMS & POLICIES

HELP & SUPPORT