Test the queries you used to create and populate the database in MySQL. After successful completion of an SQL query:
(ENTER INFO FOR DRY CLEANER BUSINESS using info/diagram below)
Entity #1: EMPLOYEE INFORMATION Due to fact the EMPLOYEE entity differs will include some similar (First Name/Last Name) and unique attributes (ID) that identify it Attribute #1 (PK): EMP-ID Description: EMP_ID is a (PK) and unique identifier that will be used as a reference in other tables. Data Type: Numeric Sample Values: 111,222,333 Attribute #2: EMPLOYEE FNAME Description: EMP_FNAME will show the first name of an employee Data Type: Text. Sample Values: 'Kendrick, 'Wally', "Ashley", etc Attribute #3: EMPLOYEE LNAME Description: EMP_LNAME will show the last name of an employee. Data Type: Text Sample Values: 'Lamar', "Baxter', 'Bryant', etc Entity # 2: CUSTOMER INFORMATION Due to fact the CUSTOMER entity differs will include some similar (First Name/Last Name) and unique attributes (ID) that identifv it Attribute #1 (PK): CUSTOMER ID Description: CUS_ID is a (PK) and unique identifier that will be used as a reference in other tables. Data Type: Numeric Sample Values: 2320, 5500, 8888 Attribute #2:CUSTOMER FNAME Description: CUS_FNAME will show the first name of an employee Data Type: Text. Sample Values: 'Kobe, 'Joe', "Aaron", etc. Attribute #3: CUSTOMER LNAME Description: CUS_LNAME will show the first name of an employee. Data Type: Text Sample Values: 'Bryant', 'Wilson', 'Rodgers', etc Attribute #4: Customer Phone Number Description: CSPhone will show the phone number of the customer so were able to contact them Data Type: Numeric Sample Values: 703-771-8877, 703-771-9900, "571-222-1212", etc. Attribute #5: Customer Address Description: CUS_Address will show the address of a customer to incase any issues arise and send out deals to regulars Data Type: Text Sample Values: '555 Main Street-Fairfax, VA', "101 Greenbelt Circle-Baltimore, MD 321 University Drive- Fairfax, VA Entity #1: EMPLOYEE INFORMATION Due to fact the EMPLOYEE entity differs will include some similar (First Name/Last Name) and unique attributes (ID) that identify it Attribute #1 (PK): EMP-ID Description: EMP_ID is a (PK) and unique identifier that will be used as a reference in other tables. Data Type: Numeric Sample Values: 111,222,333 Attribute #2: EMPLOYEE FNAME Description: EMP_FNAME will show the first name of an employee Data Type: Text. Sample Values: 'Kendrick, 'Wally', "Ashley", etc Attribute #3: EMPLOYEE LNAME Description: EMP_LNAME will show the last name of an employee. Data Type: Text Sample Values: 'Lamar', "Baxter', 'Bryant', etc Entity # 2: CUSTOMER INFORMATION Due to fact the CUSTOMER entity differs will include some similar (First Name/Last Name) and unique attributes (ID) that identifv it Attribute #1 (PK): CUSTOMER ID Description: CUS_ID is a (PK) and unique identifier that will be used as a reference in other tables. Data Type: Numeric Sample Values: 2320, 5500, 8888 Attribute #2:CUSTOMER FNAME Description: CUS_FNAME will show the first name of an employee Data Type: Text. Sample Values: 'Kobe, 'Joe', "Aaron", etc. Attribute #3: CUSTOMER LNAME Description: CUS_LNAME will show the first name of an employee. Data Type: Text Sample Values: 'Bryant', 'Wilson', 'Rodgers', etc Attribute #4: Customer Phone Number Description: CSPhone will show the phone number of the customer so were able to contact them Data Type: Numeric Sample Values: 703-771-8877, 703-771-9900, "571-222-1212", etc. Attribute #5: Customer Address Description: CUS_Address will show the address of a customer to incase any issues arise and send out deals to regulars Data Type: Text Sample Values: '555 Main Street-Fairfax, VA', "101 Greenbelt Circle-Baltimore, MD 321 University Drive- Fairfax, VA
