Please help wtih Database Design Normalization steps 1-6!

3. Project Description: Monster Video is a company that specializes in designing and installing home theater systems. Most of the time, these are complex systems costing thousands of dollars. Some vendors (notably Sony) are offering customized equipment that can be tailored for the specific environmentfor the truly discerning consumer. With multiple speakers, large video screens, and high-power amplifiers, these systems require careful design to match the room characteristics. It often takes several days to install the systemsmostly because of upgrades to the electrical and lighting systems. Installing cable for the speakers also takes timeparticularly in older houses. The company needs a database to track the customers, estimates, sales, and installations.

The database could also store the emails, addresses, and phone numbers of the customers. So it would be a unique way of telling apart from multiple customers that bought the same product.

4. What is needed for a database solution: There is a need for a database to be able to track customers in a organized fashion and also track estimates, sales, and installations so the company can have all this information for easy access without wasting time.

The database could also store information on who the installer was. Another thing that could be added is the user of the database could store more specific data such as, what was purchased. The database information can give the employees an idea of the flow of data and effective visual representation.

5. Rough ER diagram:

6. Summary: Our diagram address the projects problem because it presents the entities as what the company needs to keep track of and the attributes that it included in each entity to provide an organized database plan. This will allow the company to get an idea of their different needs and how they relate to each other. Examples include customers, estimates, sales, and installations.

Exercise 2:

All attributes: Address, Salesman, Install cost, Location, Products, Email, First name, Address, Last Name, Product Estimate,Total cost, Materials needed, Product ID.

Long name	Short name	Description
Address	Saddress	Address of where it was sold at.
Salesman	Ssalesman	Who sold it?
Installation Cost	Cinstallation	How much was the installation?
Installation Location	Linstallation	Where was the installation?
Product ID	Pid	Product installed?
Email	Cemail	Customers email.
First Name	Cfirst	Customers First name.
Address	Caddress	Customers address.
Last Name	Clast	Customers last name.
Total Products purchased	Tpurchased	Total products bought by customer
Total Cost	Tcost	Estimate of the cost
Estimated materials needed	Ematerials	Estimate of the materials needed.
Customer ID	Cid	Customer identification

Exercise 3: Normalization

Step 1 Identify All Attributes:

Customers -> Cfirst, Clast, Cemail, Caddress, Cid ~Primary Key: Cid~

Sales ->Saddress, Ssalesman, ~Primary Key: Saddress~

Installations -> Cinstallation, Linstallation, Pid ~Primary Key: Pid~

Estimates -> Pestimate, Ematerials, Tcost, ~Primary Key: Ematerials~

Step 2: Determine Dependencies

Cid DETERMINES Customers first and last name and their email address, home address

Saddress DETERMINES Salesmans the salesman and the salesman address

Pid DETERMINES Installation location and Installation cost

Ematerials DETERMINES Total cost, Product estimate

Step 3: 1NF:

Step 4: 2NF

Step 5: 3NF

Step 6: Name Tables Entity or Relationship