1. Use the normalization steps to identify the various entities and attributes needed to capture and automate the manual processes for the business case. Define each of the entities using the parenthetical method (PM). Each relation in your database design must be a normalized relation (3NF). Any assumptions should be stated below the database design PM. An example of the parenthetical method for a STUDENT relation is:

STUDENT (StudentId, StudentName, Email, Age, Major)

*Note: Attributes which comprise the primary key should be underlined and attributes that are foreign keys should be italized.

2. Use any drawing tool (e.g., MS Visio or draw.io) and create an illustration of the proposed database design model. Because relationships are critical to the database design, identify the minimum and maximum cardinalities for each of the relationships. Provide brief justifications for the cardinalities depicted in the proposed data model. *Note: In addition to minimum and maximum cardinalities, relationship lines should be illustrated according to type of relationship (e.g., identifying and non-identifying) and weak and strong entities should be differentiated as well. This is NOT the diagram from SQL Server.

mOvinOn Inc. Employee Information Form (The following information to be filled out by MovinOn human resources manager) Hire Date: 1/22/1998 Termination Date: Position: General Manager Annual Salary: $72,000 or Hourly Rate: Date of last personnel review: Notes about this employee: \begin{tabular}{|l|l|} \hline PositionID & Title \\ \hline 1 & General Manager \\ \hline 2 & Warehouse Manager \\ \hline 3 & Administrative Assistant \\ \hline 4 & Accountant \\ \hline 5 & Maintenance \\ \hline 6 & Moving Assistant \\ \hline 7 & Information Systems \\ \hline \end{tabular} \begin{tabular}{|l|l|c|c|c|c|c|c|c|} \hline & \multicolumn{1}{|c|}{ A } & B & C & D & E & F & G & H \\ \hline 1 & WarehouselD & Address & City & State & Zip & Phone & Climate Control & Security Gate \\ \hline 2 & CA-1 & \#3 Industrial Park Way & Fullerton & CA & 90621 & 6572783721 & Yes & Yes \\ \hline 3 & NV-1 & 8798 Warehouse Rd & Las Vegas & NV & 89104 & 7024568734 & No & Yes \\ \hline 4 & AZ-1 & 54781 Hixson Pike & Phoenix & AZ & 85005 & 6238972341 & Yes & No \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|} \hline UnitID & WarehouselD & Unit Size & Rent \\ \hline 1 & CA-1 & 88 & 25.00 \\ \hline 1 & NV-1 & 1212 & 35.00 \\ \hline 1 & AZ-1 & 1212 & 45.00 \\ \hline 2 & CA-1 & 88 & 30.00 \\ \hline 2 & NV-1 & 1212 & 35.00 \\ \hline 2 & AZ-1 & 1212 & 45.00 \\ \hline 3 & CA-1 & 88 & 25.00 \\ \hline 3 & NV-1 & 912 & 30.00 \\ \hline 3 & AZ-1 & 1212 & 45.00 \\ \hline 4 & CA-1 & 812 & 30.00 \\ \hline 4 & NV-1 & 912 & 30.00 \\ \hline 4 & AZ-1 & 1218 & 70.00 \\ \hline 5 & CA-1 & 88 & 25.00 \\ \hline 5 & NV-1 & 1212 & 85.00 \\ \hline 5 & AZ-1 & 1218 & 70.00 \\ \hline 6 & CA-1 & 812 & 30.00 \\ \hline 6 & NV-1 & 1212 & 85.00 \\ \hline 6 & AZ-1 & 1212 & 45.00 \\ \hline 7 & CA-1 & 810 & 25.00 \\ \hline 7 & NV-1 & 1210 & 80.00 \\ \hline 7 & AZ-1 & 1212 & 85.00 \\ \hline 8 & CA-1 & 1515 & 95.00 \\ \hline \end{tabular} mOvinOn Inc. Job Order Information Form Customer: Piazza Real Estate Move Date: 9/15/2017 Address Moving FROM: 1789 Eighth Avenue spokane, WA Address Moving TO: 7899 Grandview Apt \#5 Pullman, WA Estimated Mileage: 60 Estimated Weight: 1250lbs Do you need packing service? Yes X No Do you need us to move any heavy items (such as a piano or freezer)? YesXNo Do you need to store any items? Yes No x mOvinOn Inc. Employee Information Form (The following information to be filled out by MovinOn human resources manager) Hire Date: 1/22/1998 Termination Date: Position: General Manager Annual Salary: $72,000 or Hourly Rate: Date of last personnel review: Notes about this employee: \begin{tabular}{|l|l|} \hline PositionID & Title \\ \hline 1 & General Manager \\ \hline 2 & Warehouse Manager \\ \hline 3 & Administrative Assistant \\ \hline 4 & Accountant \\ \hline 5 & Maintenance \\ \hline 6 & Moving Assistant \\ \hline 7 & Information Systems \\ \hline \end{tabular} \begin{tabular}{|l|l|c|c|c|c|c|c|c|} \hline & \multicolumn{1}{|c|}{ A } & B & C & D & E & F & G & H \\ \hline 1 & WarehouselD & Address & City & State & Zip & Phone & Climate Control & Security Gate \\ \hline 2 & CA-1 & \#3 Industrial Park Way & Fullerton & CA & 90621 & 6572783721 & Yes & Yes \\ \hline 3 & NV-1 & 8798 Warehouse Rd & Las Vegas & NV & 89104 & 7024568734 & No & Yes \\ \hline 4 & AZ-1 & 54781 Hixson Pike & Phoenix & AZ & 85005 & 6238972341 & Yes & No \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|} \hline UnitID & WarehouselD & Unit Size & Rent \\ \hline 1 & CA-1 & 88 & 25.00 \\ \hline 1 & NV-1 & 1212 & 35.00 \\ \hline 1 & AZ-1 & 1212 & 45.00 \\ \hline 2 & CA-1 & 88 & 30.00 \\ \hline 2 & NV-1 & 1212 & 35.00 \\ \hline 2 & AZ-1 & 1212 & 45.00 \\ \hline 3 & CA-1 & 88 & 25.00 \\ \hline 3 & NV-1 & 912 & 30.00 \\ \hline 3 & AZ-1 & 1212 & 45.00 \\ \hline 4 & CA-1 & 812 & 30.00 \\ \hline 4 & NV-1 & 912 & 30.00 \\ \hline 4 & AZ-1 & 1218 & 70.00 \\ \hline 5 & CA-1 & 88 & 25.00 \\ \hline 5 & NV-1 & 1212 & 85.00 \\ \hline 5 & AZ-1 & 1218 & 70.00 \\ \hline 6 & CA-1 & 812 & 30.00 \\ \hline 6 & NV-1 & 1212 & 85.00 \\ \hline 6 & AZ-1 & 1212 & 45.00 \\ \hline 7 & CA-1 & 810 & 25.00 \\ \hline 7 & NV-1 & 1210 & 80.00 \\ \hline 7 & AZ-1 & 1212 & 85.00 \\ \hline 8 & CA-1 & 1515 & 95.00 \\ \hline \end{tabular} mOvinOn Inc. Job Order Information Form Customer: Piazza Real Estate Move Date: 9/15/2017 Address Moving FROM: 1789 Eighth Avenue spokane, WA Address Moving TO: 7899 Grandview Apt \#5 Pullman, WA Estimated Mileage: 60 Estimated Weight: 1250lbs Do you need packing service? Yes X No Do you need us to move any heavy items (such as a piano or freezer)? YesXNo Do you need to store any items? Yes No x