Develop the database in the attachment and resulting ERD using Oracle SQL Developer. Provided is a list of the key tables, columns, and constraints that you should focus on with the database. You may choose to add more tables and columns if you deem it necessary:
Customer
- CustomerID (PK).
- FirstName (NOT NULL).
- LastName (NOT NULL).
- Address.
- City.
- State.
- Zip.
- Country.
- Phone.
- Email (UNIQUE and NOT NULL).
- Username (UNIQUE and NOT NULL).
- Password (NOT NULL).
Order
- OrderID (PK).
- CustomerID (FK).
- OrderDate.
- ShipDate.
- OrderDetail.
- OrderDetailID (PK)
- OrderID (FK).
- ProductID (FK).
- Price.
- Quantity (CHECK > 0).
Product
- ProductID (PK).
- CategoryID (FK).
- ProductName.
- ProductDescription.
- UnitPrice.
Picture Category
- CategoryID (PK).
- CategoryName.
- Description.
To complete this assignment:
- Create these tables in your database while planning the data types for each of these fields.
- Generate the ERD for the tables using SQL Developer and take a screenshot of this to place into MS Word.
- Provide the SQL Script that shows you have created a physical database containing appropriate data.
Make sure to specify only the tables created for the project in your database export. Provide your code and SQL scripts that you executed to create the forms and reports and show screenshots or other evidence that your scripts generated your reports successfully.