Question: 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

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

\ table [ [ Office Inventory Database ] , [ Tracks Items Located in the Main Office Complex, ] , [ Attribute , Attribute,Attribute ] , [ OfficeltemID , SupplierID,ReorderLevel ] , [...

Please use accounting information system knowledge to do this. ACCY Flowchart Assignment: Cold Wear Company produces and sells fleece-lined suede leather jackets. Having been in business for almost...

Please help me to do this, thanks! This is my accounting information system question about flowchart. Create a flowchart in good form and using standard symbols and flowcharting design techniques for...

Stan Jackets Company Data Flow Diagram and Flowchart Project Stan Jackets Company produces and sells fleece-lined suede leather jackets. Having been in business for almost 40 years in Portland, OR,...

Student Handout McCloud Company Data Flow Diagram Documentation Project McCloud Company produces and sells fleece-lined suede leather jackets. Having been in business for almost 40 years in Taos, NM,...

Stan Jackets Company Data Flow Diagram and Flowchart Project Stan Jackets Company produces and sells fleece - lined suede leather jackets. Having been in business for almost 4 0 years in Portland, OR...

Stan Jackets Company produces and sells fleece-lined suede leather jackets. Having been in business for almost 40 years in Portland, OR, Stan Jackets Companys products are well-known for their...

Stan Jackets Company Data Flow Diagram and Flowchart Project Stan Jackets Company produces and sells fleece - lined suede leather jackets. Having been in business for almost 4 0 years in Portland, OR...

McCloud Company produces and sells fleece-lined suede leather jackets. Having been in business for almost 40 years in Taos, NM, McCloud Company's products are well-known for their durability and...

Stan Jackets Company produces and sells fleece-lined suede leather jackets. Having been in business for almost 40 years in Portland, OR, Stan Jackets Companys products are well-known for their...

When fresh start accounting is utilized, how are a companys assets and its liabilities reported?

Bursa, Turkey, plant of Renault assembles two types of cars (Megane and Kangoo). Separate assembly lines are used for each type of car. (16 answers x 0.125 marks= 2 marks)-- Required: Classify each...

estimates of global zinc resources are around 3 3 0 TG . Assume the zinc must last 5 0 years and be shared equally among the global population, which will increase from 8 billion to 1 0 billion over...

The first scenario will be a Verbal Judo scenario in which your scenario follows the standard Verbal Judo interaction: You need to ask somebody to modify their behavior either to do something or to...

4. Write a short report in which you assess the impact of one piece of health and safety legislation in an organisation of your choice. (Sources of guidance for report writing are given on page 476.)

understand the context within which international business takes place

1. Interview people (friends, family or work colleagues from a range of organisations) about their own responsibilities in relation to health and safety and then about their perceptions of other...