Question: Write the code that would create a table in the kimtay database that will store information about suppliers, include supplier_id, company name, company address, city,

Write the code that would create a table in the kimtay database that will store information about suppliers, include supplier_id, company name, company address, city, state, country, contact person, email phone number. Decide what date types are best, what can and can not be null and if there are other fields that you might need. Describe the table, does it meet your requirements. Show me the output. Insert at least five rows into the table, show the statements. Test by doing a select * statement and showing me the output.

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!