Mother Goose Department Store has decided to hire your software company to build

Question

Mother Goose Department Store has decided to hire your software company to build a database for their organization. You have been selected to work on the database project. At the last team meeting, your team lead divided the final design tasks. Your assignment is to read in Employee data and provide methods for querying this information

Objectives:The objective of this assignment is for students to demonstrate a workingknowledge of :? structs? linked list operations

In your program you are required to:
1. Create an employeeData struct to represent employees. Your struct shouldhave the following fields:      -   An integer EMP_ID,      - name which stores the candidate

Explanation / Answer

Here's a simple normalization process.

This is not normalized, as explained. A normalized form could look like

Here, the Employee table is only responsible for one set of data. So where do we store which department the employee belongs to? In another table

This is not optimal. What if the department name changes? (it happens in the US government all the time). Hence it is better to do this

There are first normal form, second normal form and third normal form. But unless you are studying a DB course, I usually just go for the most normalized form I could understand.

Related Questions

Navigate

• Browse (All)
• Browse M
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.