ALL I NEED IS AN EXPERTS OPINION ON WHAT DATATYPE FOR EACH OR THESE COLUMNS I DO
ID: 3914533 • Letter: A
Question
ALL I NEED IS AN EXPERTS OPINION ON WHAT DATATYPE FOR EACH OR THESE COLUMNS I DONT NEED CODE OR SCRIPTS I JUST NEED TO KNOW WHAT DATATYPE YOU WOULD USE FOR EACH COLUMN. USING ORACLE SQL DEVELOPER.
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.
For your database determine the data types for each of these fields.
Explanation / Answer
Customer - varchar2
CustomerID (PK). - varchar2 (if it contains any alphabates ) else Number
FirstName (NOT NULL). varchar2
LastName (NOT NULL).varchar2
Address. varchar2
City. varchar2
State. varchar2
Zip. Number
Country. varchar2
Phone. Number
Email (UNIQUE and NOT NULL). varchar2
Username (UNIQUE and NOT NULL). varchar2
Password (NOT NULL). varchar2
Order varchar2
OrderID (PK). varchar2
CustomerID (FK). varchar2 (if it contains any alphabates ) else Number
OrderDate. Date
ShipDate. Date
OrderDetail varchar2
OrderDetailID (PK).varchar2 (if it contains any alphabates ) else Number
OrderID (FK). varchar2 (if it contains any alphabates ) else Number
ProductID (FK). varchar2 (if it contains any alphabates ) else Number
Price. Decimal
Quantity (CHECK > 0). Decimal
Product varchar2
ProductID (PK). varchar2 (if it contains any alphabates ) else Number
CategoryID (FK). varchar2 (if it contains any alphabates ) else Number
ProductName. varchar2
ProductDescription. varchar2
UnitPrice. Decimal
Picture. BLOB
Category varchar2
CategoryID (PK). varchar2
CategoryName. varchar2
Description. varchar2
Note: Please comment below for any doubts
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.