I now must create a physical Entity Relationship diagram from this list table. While, I feel more comfortable creating new tables for better organization. I'm a little lost as to how to evolve my Entity Relationship Diagram into a physical ERD. IN 20 O inthy letohe b Aeen vDu - My Move o tbo 0 Tunte T tre TiD ake. a Anamcon Thark tworte te Nivara Masape C. irooran Doca 40k ho Oher bookmets ITD256, Online Eercise (2) ( pdf 1/2 21619 21523 10/23/2010 10/23/2010 KV29 Gs Rarge Treadmil 5495 00 $1290 00 Scenario This is a simple ist table of a company trying to kerep track of employe assiennent to company projects in other words, not a database but a fut one fable file), You wl design a datitbase for this company so that they won't be relying on a simple i table ist system to keep track of their data. Locking at the table below, idereity the separate enities and attributes and design a logical level Ereny Relationship Diagram for this company Project Project Name Project Project Employee Employee Department Department Hourly Name Mohan Code Marager Budget No. No Name Database Rate 21.00 Mr. Ajay 120s00 SI00 PCO10 Reservation System PCO10 Reservation Sytem PCO10 Reservation Syitem PCOL1 System DO3 Mr. Ajay 120500 Vipul D02 Testing 16.50 Mr. Ajay 120500 s02 Riyar D01 22.00 Mrs 500500 SI03 Pavan DO3 Dutabase 1850 Charu PCO11 HSystem Mrs S00S00 SI04 itendra D02 Testing 1700 Charu Mrs. PCOLI R System 500s00 Pooja D01 IT 2350 PCOL2 Atendance System PCO12 Atendance System PCO12 Attendance Sytem Charu Mr. Rajesh Mr. Rajesh Mr. Rajesh 730700 S37 Rahul DO3 Dutabane 21.50 710700 5218 Avneesh D02 Testing 15 50 710700 S109 Vkas DO01 20 50 Northen Viginia Commesly College Annendole Compus 4回9 950 M Type here to search

Computer Networking: A Top-Down Approach (7th Edition)
7th Edition
ISBN:9780133594140
Author:James Kurose, Keith Ross
Publisher:James Kurose, Keith Ross
Chapter1: Computer Networks And The Internet
Section: Chapter Questions
Problem R1RQ: What is the difference between a host and an end system? List several different types of end...
icon
Related questions
Question
I now must create a physical Entity Relationship diagram from this list table. While, I feel more comfortable
creating new tables for better organization. I'm a little lost as to how to evolve my Entity Relationship Diagram
into a physical ERD.
Modue ZEercze 1
TN 20- Cute 11
Erty-Relatontie Dx
Acadenc Toak : No
Entty eunonahe Di X
++c O Fle | CANestiesia Desktspifo256, Onine berdiel(26202)pdf
# Apps V VLDU- My Movie O tbo
Tunak T aroee TED ake |. a Araoncom Trank. avorite aie Nirara MassageC I irporam Docs 401k
Yahaol
AS + American S.
Other bookmarts
ITD256,Online Exercise (2) (2)pdf
1/2
21619
21523
10/23/2010
DR93
Gas Range
Treadmil
5495 00
$1290.00
| 10/23/2010
KV29
OR
Scenario 2
This is a simple ist table of a company trying to keep track of employee assignment to company projects in other
words, not a database but a flat one fable filel, You will design a database for this company so that they won't be
relying on a simple 1 table ist system to keep track of their data. Locking at the tabie below, identity the separate
entities and attributes and design a logical level Entity Relationship Diagram for this company
Project Project Name Project Project Employee Employee Department Department Hourly
No.
S100
Manager Budget
Mr. Ajay 120500
Code
Name
No.
Name
Rate
PCO10 Reservation
Mohan
D03
Database
21.00
System
PC010 Reservation
System
PC010 Reservation
System
PCO11 HR System
Mr. Ajay 120500
Vipul
D02
Tesing
1650
Mr. Ajay 120500
Riyat
S102
D01
IT
22.00
Mrs
500500
S103
Pavan
D03
Database
1850
Charu
PCO11 HR System
Mrs.
500500
SI04
itendra 002
Testing
17.00
Charu
Mrs
PCO11 HR System
SO0S00
S315
Pooja
D01
IT
23.50
Charu
PCO12 Attendance
System
Mr.
710700
S137
Rahul
D03
Dutaba
21.50
Rajesh
Mr.
Rajesh
Mr.
PCO12
Attendance
710700
5218
Avneesh
D02
Testing
15 50
System
PC012 Attendance
System
710700
5109
Vikas
D01
IT
20.50
Rajesh
Northern Virginia Community College
Annandole Campus
O ype here to search
950 M
2/2019
Transcribed Image Text:I now must create a physical Entity Relationship diagram from this list table. While, I feel more comfortable creating new tables for better organization. I'm a little lost as to how to evolve my Entity Relationship Diagram into a physical ERD. Modue ZEercze 1 TN 20- Cute 11 Erty-Relatontie Dx Acadenc Toak : No Entty eunonahe Di X ++c O Fle | CANestiesia Desktspifo256, Onine berdiel(26202)pdf # Apps V VLDU- My Movie O tbo Tunak T aroee TED ake |. a Araoncom Trank. avorite aie Nirara MassageC I irporam Docs 401k Yahaol AS + American S. Other bookmarts ITD256,Online Exercise (2) (2)pdf 1/2 21619 21523 10/23/2010 DR93 Gas Range Treadmil 5495 00 $1290.00 | 10/23/2010 KV29 OR Scenario 2 This is a simple ist table of a company trying to keep track of employee assignment to company projects in other words, not a database but a flat one fable filel, You will design a database for this company so that they won't be relying on a simple 1 table ist system to keep track of their data. Locking at the tabie below, identity the separate entities and attributes and design a logical level Entity Relationship Diagram for this company Project Project Name Project Project Employee Employee Department Department Hourly No. S100 Manager Budget Mr. Ajay 120500 Code Name No. Name Rate PCO10 Reservation Mohan D03 Database 21.00 System PC010 Reservation System PC010 Reservation System PCO11 HR System Mr. Ajay 120500 Vipul D02 Tesing 1650 Mr. Ajay 120500 Riyat S102 D01 IT 22.00 Mrs 500500 S103 Pavan D03 Database 1850 Charu PCO11 HR System Mrs. 500500 SI04 itendra 002 Testing 17.00 Charu Mrs PCO11 HR System SO0S00 S315 Pooja D01 IT 23.50 Charu PCO12 Attendance System Mr. 710700 S137 Rahul D03 Dutaba 21.50 Rajesh Mr. Rajesh Mr. PCO12 Attendance 710700 5218 Avneesh D02 Testing 15 50 System PC012 Attendance System 710700 5109 Vikas D01 IT 20.50 Rajesh Northern Virginia Community College Annandole Campus O ype here to search 950 M 2/2019
Expert Solution
steps

Step by step

Solved in 3 steps

Blurred answer
Recommended textbooks for you
Computer Networking: A Top-Down Approach (7th Edi…
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
Computer Organization and Design MIPS Edition, Fi…
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
Concepts of Database Management
Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
Prelude to Programming
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
Sc Business Data Communications and Networking, T…
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY