Logo
Home Study Material Contact Search
AI Chat FREE
  1. computer science
  2. programming
  3. cutting edge incorporated is a company engaged in

Cutting Edge Incorporated is a company engaged in the development of computer-aided design (CAD) software packages....

Free

70.2K

Verified Solution

Question

Programming

  1. Cutting Edge Incorporated is a company engaged in thedevelopment of computer-aided design (CAD) software packages. Themanagement of Cutting Edge wants to develop a project trackingsystem to accumulate and report data on current projects, employeesand departments. They have given you the following attributes theystore on an excel spreadsheet. A project can have several employeesassigned to it. An employee belongs to only one department. Makeany necessary assumptions and normalize to 3NF.

(ProjectNumber, ProjectName,StartDate, ProjectStatus, (EmployeeNumber, EmployeeName,DepartmentNumber, DepartmentName, JobTitle, ProjectHours))

Answer & Explanation Solved by verified expert
4.2 Ratings (670 Votes)

1). ANSWER :

GIVENTHAT :

1NF

(ProjectNumber, ProjectName, StartDate, ProjectStatus, EmployeeNumber, EmployeeName, DepartmentNumber, DepartmentName, JobTitle, ProjectHours)

2NF

Functional Dependencies:

ProjectNumber -> ProjectName, StartDate, ProjectStatus, ProjectHours

EmployeeNumber -> EmployeeName, JobTitle

DepartmentNumber -> DepartmentName

Tables in 2NF

Project(ProjectNumber , ProjectName, StartDate, ProjectStatus, ProjectHours)

Employee(EmployeeNumber , EmployeeName, JobTitle)

Department(DepartmentNumber , DepartmentName)

3NF

A project can have several employees assigned to it.

EmployeeNumber -> ProjectNumber

An employee belongs to only one department

EmployeeNumber -> DepartmentNumber

Tables in 3NF

Project(ProjectNumber , ProjectName, StartDate, ProjectStatus, ProjectHours)

Employee(EmployeeNumber , EmployeeName, JobTitle,DepartmentNumber,ProjectNumber)

Department(DepartmentNumber , DepartmentName)

underlined are primary keys and italicised are foreign keys.
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students

Algebra
1.2K views

Every day at Thomas's house they buy a baguette of bread that has the shape...

Accounting
1.2K views

1. Who can contribute to a traditional IRA, and how much? Nick, age 53, is single...

Statistics
1.2K views

8. Rollflex and Morgan Trust are two stocks traded on the New York Stock Exchange. For...

Biology
1.2K views

O USB derive O External hard disk RAM

Physics
1.2K views

snown connected between points A and B then the current in this wire will 3Q...

Basic Math
1.2K views

Minh a psychology student kept a record of how much time she spent studying for...

Basic Math
1.2K views

10 Find the sum of the first 30 terms of the arithmetic sequence whose first...

Basic Math
1.2K views

Determine the following trigonometric values of t using the picture of the unit circle below....

Statistics
1.2K views

Let A and B be events in a sample space S and let C S...

Accounting
1.2K views

Required information The Foundational 15 [LO13-1, LO13-2, LO13-3, LO13-5,...

Accounting
1.2K views

Sengupta Company expects to receive $100 at the end of each of the next 3...

Accounting
1.2K views

Romano's Frozen Pizza Inc. has determined from its production budget the following estimated production volumes...