Answered step by step
Verified Expert Solution
Question
1 Approved Answer
a. Job (JobID, JobName, JobBudget, AdvisorID, AdvisorName, EmployeeID, EmployeeName) Assumptions: An advisor advises more than one job; An employee works for more than one job;
a. Job (JobID, JobName, JobBudget, AdvisorID, AdvisorName, EmployeeID, EmployeeName) Assumptions: An advisor advises more than one job; An employee works for more than one job; and A job only have one employee and one advisor. Determinant(s): Primary key(s): Lowest normal form violated
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
Management Information Systems Managing The Digital Firm
Authors: Kenneth C Laudon, Jane P Laudon
14th Edition
013389830X, 9780133898309
