Question

Lab 5 "Your Business" is a spreadsheet from a poorly organized database/business. [See Excel file) You are a database consultant hired to review their data and create a new database. Write your answer in the provided space for each question and save it as a PDF file. Then submit one PDF file only. 1. Find all the dependencies: Solution: 2. Normalize to ZNF. Give each table a name and list the attributes in each table. Provide structural answers only in DBDL showing functionalities and tables. Solution: 3. Specify primary and foreign keys for each table (Tables that are in 3NF). Provide structural answers only in DBDL showing functionalities and tables. Solution: 4. Write a set of business rules to go along with your normalized tables Solution: Do not include the data. The data is provided for your reference. You may have to reuse attributes, but do not create any additional fields.

Answer 1

The task involves normalizing a poorly organized database to 3NF, specifying primary and foreign keys, and writing business rules to articulate the constraints and relationships in the database.

Step-by-step explanation:

Addressing the request for organizing and structuring a poorly organized database into a new, properly normalized database involves several critical steps. The objective is to find all the dependencies, normalize the data to the Third Normal Form (3NF), specify primary and foreign keys, and write a set of business rules.

Normalization Process

Normalization is a method used to minimize data redundancy and dependency by organizing fields and table of a database. The most common successive levels of normalization are the First Normal Form (1NF), Second Normal Form (2NF), and Third Normal Form (3NF). Each 'Normal Form' is a condition that a database must meet to ensure that it is organized properly.

After identifying dependencies, you would create tables that reflect the 3NF, ensuring that data is only stored once. You would then define primary keys, which are unique identifiers for the rows in a table, and foreign keys, which link rows of one table to another.

Business Rules

Business rules articulate the structure and constraints of the database. These rules govern relationships between tables, acceptable data entries, and ensure data integrity. Documenting these rules helps to ensure that the database operates correctly and efficiently.