simulate the creation of a variety of tables with various attributes. The key to a successful grade on this assignment is the appropriate structure and data types for each attribute. Make sure you pay attention to the information given and choose the data type that BEST meets the client requirements and provides for data validation. Please include the attributes as they appear below (do not add or remove attributes). Follow the instructions and specifications provided. Note: Constraints are not required in this assignment.
Submission
You will submit a total of 2 sql files to CodeGrade. Files should be named appropriately and be in .sql format. Each file must use the postgres standards taught in the course. Ensure your CREATE TABLE statements run together in pgAdmin prior to submission. Use of other SQL languages such as T-SQL will result in an automatic 0 for the assignment. You will have one submission attempt for this assignment.
File 1: You must submit a SQL document called <LastName>_Assignment1_APU. This document must include ALL commands required to create the database and tables for the client Auto Parts Unlimited.
File 2: You must submit a SQL document called <LastName>_Assignment1_HG. This document must include ALL commands required to create the database and tables for the client Holy Grounds
You will submit both files to the Assignment 1 link to CodeGrade. Failure to include both files will result in loss of credit for any missing information as specified in the rubric.
Instructions
As in the practice assignment, you will be working for a company that creates and maintains databases for small business customers. The company has taken on two new clients that you will need to set up with their own databases. Note that since these are two separate databases, you ARE allowed to repeat the names of tables and attributes (for example, both companies have an inventory table. Both tables can be called inventory since they are in different databases). It is encouraged that if you have questions or difficulties with any portion of this assignment that you utilize the discussion board or GAs to gain clarity.
PART 1 (File 1)
The first client is a local auto parts company called “Auto Parts Unlimited”. Complete the following steps for this client:
Create a database called “auto_parts_unlimited”
Connect to the database
Create the following 3 tables based on the client’s requirements:
Customers: Each customer has the following:
A unique numeric ID assigned automatically when their record is created (for this assignment you do not need to add a constraint to enforce uniqueness)
