Question: Write the SQL code to create a table related to products in a Dollar Store. The table is called Product. The table requirements are listed.

Write the SQL code to create a table related to products

Write the SQL code to create a table related to products in a "Dollar" Store. The table is called Product. The table requirements are listed. Assume the manufacturer tables is already created, its structure is listed below. (20 points) The Product table has the following attributes: Bar code - 9 digit number and is the primary key. Product name 30 character string and can not be blank. Price- 3 digit number (representing cents) and must be between 100 and 400. Manufacture ID -10 digit number and is a foreign key to the Manufacturer's tables. Location 4 character string and must not have a duplicate value in another row of the table. The manufacture's table structure is: MANUFACTURER: Manufacturer ID number Name varchar2 Address Varchar2

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!

Topics: Creating tables with primary keys Creating related tables with appropriate foreign keys (1:M, M:N relationships) Inserting data Updating data Selecting data (using logical operators, date...

Consider a database application about the ingredients and nutrition of different food items available in Canada. In terms of design, following are some major requirements: Application owner /...

QUESTION 1 (a) Describe the main characteristics of the database approach and contrast it with the file-based approach. (b) The following records are saved in spreadsheet (see Figure 1). [4 marks]...

ER Modeling Question 1: [10 Marks] Assume your company is developing a generic digital camera online purchasing system that can be sold to different camera stores. An initial analysis phase of the...

Introduction to databases Assignment 1 Description of the schema The following database is used by a building materials company to edit invoices for its customers and to manage its inventory The...

Assignment E: Tables, Views, and Functions must be created in your individual database on the Yorktown server! Download Assignment E-skeleton.sql from Canvas and rename the downloaded file to...

If could, I would like to send you the word and pdf files to make it easier for you to solve the problem. You are working with the following relational schema for a university's course management...

These tasks are done in "court" database, which you can download from Moodle.\ Write you SQL code right after each task.\ Each task gives you 1 point, 7 points total.\ BEFORE ANSWERING THE TASKS,...

These tasks are done in "court" database, which you can download from Moodle. Write you SQL code right after each task. Each task gives you 1 point, 7 points total. BEFORE ANSWERING THE TASKS, CREATE...

answer 5 and it's part 5) Create a new folder named assignmentl_yourID. Put in this folder all the scripts created in the above questions. Compress the folder then submit it via Blackboard on or...

1. Describe the two basic approaches to estimating uncollectible accounts under the allowance method and the rationale for each. 2. Find an example on Edgar for how a public company discloses its...

Prove that the maximum range can be achieved for a given velocity when angle of projection = 45.

By using magnetic bearings, a rotor is supported contactless. The technique of contactless support for rotors becomes more important in light and heavy industrial applications [14]. The matrix...

Joyce wishes to reduce flaws produced by her night shift. At each stage of production she has her production supervisor measure 2 0 samples to ensure they are each within 0 . 0 0 5 mm of the required...

Assume that the banking system has total reserves of $100 billion. Assume also that required reserves are 10 percent of checking deposits and that banks hold no excess reserves and households hold no...

As shown in Figure 3, the overall labor-force participation rate of men declined between 1970 and 2000. At the same time, the labor-force participation rate of women increased sharply. This overall...

The Bureau of Labor Statistics announced that in February 2008, of all adult Americans, 145,993,000 were employed, 7,381,000 were unemployed, and 79,436,000 were not in the labor force. Use this...