Please help me with this SQL database diagram and correct if you think something is wrong here you can use paper to explain this database model connecting all these entities using primary and foreign key also explain relationship between them.

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

Please help me with this SQL database diagram and correct if you think something is wrong here you can use paper to explain this database model connecting all these entities using primary and foreign key also explain relationship between them.

Project
HR
1 Employeeld
Workforce
ProjectName
EmployeeName
Employeeld
ProjectManager
DOB
NewEmployee
MODNumber
Address
SubContractor
РОP
StartDate
Contractor
CurrentYearOfPOP
Race
Position
AwardAmount
User
Organization
LabourCategory
FundingBaseYear
FirstName
CPProjectCode
ActualRate
CustomerName
LastName
[CS/HS]
BillingRate
CustomerAddress
CreatedBy
PayRate
DUNU
CustOfficerName
CreatedDate
AcualRate
Uniqueld
CustSpeciAddress
ModifiedBy
ReportMngr
CORName
ModifieDate
TimesheetApvr
CORAddress
EmailAddress
ТРОСName
TPOCAddress
Accounting
Invoicelnfo
NewCPProjectNo
InvoicePeriod
Contract
Schedule
CharglevelTimesheet
Id
PLCRate
InvoiceSubNote
ContractType
BillingRate
ContractNumber
Transcribed Image Text:Project HR 1 Employeeld Workforce ProjectName EmployeeName Employeeld ProjectManager DOB NewEmployee MODNumber Address SubContractor РОP StartDate Contractor CurrentYearOfPOP Race Position AwardAmount User Organization LabourCategory FundingBaseYear FirstName CPProjectCode ActualRate CustomerName LastName [CS/HS] BillingRate CustomerAddress CreatedBy PayRate DUNU CustOfficerName CreatedDate AcualRate Uniqueld CustSpeciAddress ModifiedBy ReportMngr CORName ModifieDate TimesheetApvr CORAddress EmailAddress ТРОСName TPOCAddress Accounting Invoicelnfo NewCPProjectNo InvoicePeriod Contract Schedule CharglevelTimesheet Id PLCRate InvoiceSubNote ContractType BillingRate ContractNumber
Expert Solution
steps

Step by step

Solved in 2 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