Question: Identify appropriate datatypes and sizes for each attribute. Customer c_id: c_lname: c_fname: c_address: Product p_id: p_description: p_price: o_id: Order o_id: c_id: o_date: Order_Items o_id: p_id:

Identify appropriate datatypes and sizes for each attribute.

Customer

c_id:

c_lname:

c_fname:

c_address:

Product

p_id:

p_description:

p_price:

o_id:

Order

o_id:

c_id:

o_date:

Order_Items

o_id:

p_id:

o_qty:

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!

Q:

In mysql Assignment Scenario The Chinook company has realized they could make better, more efficient use of their dutabase if they convert more of its commenlyeused functionality over to using stored...

Q:

Appendix NZ Cover Staff Agency (NZCSA) Case Study: Agency Hiring Temporary Employees for Company Placements Auckland Cover Staff Agency called ACSA is an Auckland based hiring agency that places...

Q:

Help on creating a procedure in sql, this file will be used to compile. Then afterwards I have to make another sql file to run and output the results. But for this part I'm stuck on the procedure...

Q:

a. Lab 4 Creating Constraints Save screen captures of all SQL statements used to accomplish the following tasks. Save your screen captures in a word document or PDF which must be named in the format...

Q:

Assignment Objective The purpose of this assignment is to practice flexible design, read a csv file from disc, store the data in a collection of objects and print the results in natural and sorted...

Q:

can you please help me with this assignment Crete a narrated multimedia presentation using either Power Point, Screencast-o-matic, or Prezi. Remember,narration with audio (not just ppt notes) is...

Q:

NOTE: PLEASE DO THAT ON C# CODING AND COMPLETELY DONE. ONE OF THE EXPERTS SEND ME THE FIRST TWO PARTS AND DIDNT FINISHED THE REST!!!!!!!! Assignment Objective The purpose of this assignment is to...

Q:

Ashford 5: - Week 4 - Assignment Principles of Effective Intervention There are four general principles of effective intervention that have become organizing concepts of community corrections. They...

Q:

ge 1: 2 3 Question 31 (Mandatory) (2 points) Write a query that will create a new table called CARS. Include the fields: VIN, Autoname, autotype, Be sure to include appropriate datatypes, and field...

Q:

Just need help with answers for 3-3 using 3-2 data. Create two tables, Tl (ename, jobno) and T2(jobno, jobdesc). Let jobno be data-type, NUMBER(3), and use appropriate data-types for the other...

Q:

Inventory decision, opportunity costs. Lawnox, a manufacturer of lawn mowers, predicts that it will purchase 240,000 spark plugs next year. Lawnox estimates that 20,000 spark plugs will be required...

Q:

AstraZeneca is the maker of the stomach medicine Prilosec, which is the second-best-selling drug in the world. Recently, the company has come under close scrutiny concerning the cost of its...

Q:

Summary informabon from the financial statements of two companies competing in the same induntry flollows. \ table [ [ , , farse onerety , ryas Crecury , , Sarce catyaty,eyat Limpary ] , [ Bela frue...

Q:

Seved Help 14 Wisconsin Snowmobile Corp. is considering a switch to level production Cost efficiencies would occur under level production, and aftertax costs would decline by $31,500, but inventory...

Q:

___ 2. I am most fulfilled in my work when I have been able to integrate and manage the efforts of others.

Q:

___ 6. I will feel successful in my career only if I have a feeling of having made a real contribution to the welfare of society.

Q:

3. How does this fit with your preferences, career anchors, and values?