$1.$ Create a database called auto$\_$parts$\_$unlimited

$2.$ Create the following tables based on the client$$s requirements:

a$.$ customers: This table will store customer information and should include the following attributes:

i$.$ cust$\_$id: A numeric ID that is assigned automatically when a customer record is created

ii$.$ first$\_$name: customer$$s first name

iii. last$\_$name: customer$$s last name

iv$.$ phone$\_$number: customer$$s phone number using format: $($xxx$)$ xxx$-$xxxx

v$.$ email: customer$$s email address

vi$.$ street$\_$address: customer$$s address, includes street name and number

vii. city: city in which the customer lives

viii. zip: customer$$s $5-$digit zip code

ix$.$ state: two letter state abbreviation

b$.$ employees: This table will store information about the employees and should include the following attributes:

i$.$ employee$\_$id: A numeric ID that is assigned automatically when an employee is hired

ii$.$ first$\_$name: employee$$s first name

iii. last$\_$name: employee$$s last name

iv$.$ phone$\_$number: employee$$s phone number using format: $($xxx$)$ xxx$-$xxxx

v$.$ email: employee$$s email address

vi$.$ street$\_$address: employee$$s address, includes street name and number

vii. city: city in which the employee lives

viii. zip: employee$$s $5-$digit zip code

ix$.$ state: two letter state abbreviation

x$.$ hire$\_$date: date the employee was hired

xi$.$ salary: employee$$s annual salary as a fractional value

xii. probation: employee$$s probationary status. Can only be one of two values. Either an employee is still probationary or not.

c$.$ parts$\_$inventory: represents all items in the store$$s inventory

i$.$ part$\_$number: An alphanumeric part number

ii$.$ manufacturer: The manufacturer$$s name of each part

iii. quantity: the number of parts in stock

iv$.$ price: the price of each part as a fractional value