Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

You are required to create the following tables in a database named COFFEELIST: (20) COFFEE COFFEE_CODE COFFEE_NAME COFEE BRAND STRENGTH PRICE STORES STORE_CODE STORE

You are required to create the following tables in a database named COFFEELIST: (20) COFFEE COFFEE_CODE

You are required to create the following tables in a database named COFFEELIST: (20) COFFEE COFFEE_CODE COFFEE_NAME COFEE BRAND STRENGTH PRICE STORES STORE_CODE STORE NAME ADDRESS CITY AVAILABILITY COFFEE_CODE STORE CODE VARCHAR(5) NOT NULL VARCHAR(40) NOT NULL VARCHAR(40) NOT NULL VARCHAR(40) NOT NULL SMALLMONEY NOT NULL VARCHAR(5) NOT NULL VARCHAR(20) NOT NULL VARCHAR(50) NOT NULL VARCHAR(20) NOT NULL VARCHAR(5) NOT NULL VARCHAR(S) NOT NULL AVAILABLE STOCK SMALLINT NOT NULL PRIMARY KEY PRIMARY KEY PRIMARY KEY FOREIGN KEY REFERENCES COFFEE(COFFEE_CODE] PRIMARY KEY FOREIGN KEY REFERENCES STORES(STORE_CODE)

Step by Step Solution

3.34 Rating (157 Votes )

There are 3 Steps involved in it

Step: 1

Create Database COFFEELIST CREATE DATABASE COFFEELIST Create tables in d... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database Systems A Practical Approach to Design Implementation and Management

Authors: Thomas Connolly, Carolyn Begg

6th Edition Global

132943263, 978-0132943260

More Books

Students also viewed these Programming questions

Question

Describe the rules for deriving relations that represent:

Answered: 1 week ago