Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Office Inventory Database Tracks Items Located in the Main Office Complex Attribute Attribute Attribute OfficeItemID SupplierID ReorderLevel OfficeItemDescription SupplierName TargetStockLevel OfficeItemCategory SupplierPhone isDiscontinued OfficeItemLocation ManufacturerName
Office Inventory Database Tracks Items Located in the Main Office Complex Attribute Attribute Attribute OfficeItemID SupplierID ReorderLevel OfficeItemDescription SupplierName TargetStockLevel OfficeItemCategory SupplierPhone isDiscontinued OfficeItemLocation ManufacturerName PurchasePrice Notes ModelNumber LastPurchaseDate Refer to the list of attributes needed by our Office Inventory Database. If we wanted the database to assign new ID's to new office suppliers for our company, what data type should we assign to SupplierID? Group of answer choices SERIAL CHAR INTEGER TEXT
Office Inventory Database
Tracks Items Located in the Main Office Complex
Attribute Attribute Attribute
OfficeItemID SupplierID ReorderLevel
OfficeItemDescription SupplierName TargetStockLevel
OfficeItemCategory SupplierPhone isDiscontinued
OfficeItemLocation ManufacturerName PurchasePrice
Notes ModelNumber LastPurchaseDate
Refer to the list of attributes needed by our Office Inventory Database. If we wanted the database to assign new ID's to new office suppliers for our company, what data type should we assign to SupplierID?
Group of answer choices
SERIAL
CHAR
INTEGER
TEXT
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started