Q1. Write the SQL code to create the table structures for the entities shown in the above ERD. The structures should contain the attributes specified in the ERD. Use data types that are appropriate for the data that will need to be stored in each attribute. Enforce primary key and foreign key constraints as indicated by the ERD. Q2. Add INSERT INTO statements to populate your database. Include at least 4 representative tuples in each table. Q3. Using the integrity enhancement features of SQL, write the statements that add the following constraints: 1. The Product Price on the PROUCT table must be between 20 and 200 2. No two vendors with the same names in VENDOR table

Q1. Write the SQL code to create the table structures for the entities shown in the above ERD. The structures should contain the attributes specified in the ERD. Use data types that are appropriate for the data that will need to be stored in each attribute. Enforce primary key and foreign key constraints as indicated by the ERD. Q2. Add INSERT INTO statements to populate your database. Include at least 4 representative tuples in each table. Q3. Using the integrity enhancement features of SQL, write the statements that add the following constraints: 1. The Product Price on the PROUCT table must be between 20 and 200 2. No two vendors with the same names in VENDOR table

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Similar questions

What is the need for transactions in SQL?
Using the database schema attached, write SQL query for these statements: (1) List stores with more than 200 customers. (2) Display the average amount paid by each customer, along with the customer's first and last name.
Can you help me with this SQL tutorial? I have attached the question below.
What exactly is an index? What are the advantages and disadvantages of indexing? How does one go about building a SQL index?
Convert the following ER diagram into relational schema. Write the relational schema in SQL.
How are keywords used in SQL queries to retrieve specific data from a database?
please use sql to answer the following question
INFO 2103 Database Programming Assignment #3 For this assignment, please use the SUPPLIER and COMPUTER table. The script is available in Google Classroom. Script name: computer.sql. Note: Use Subqueries 1. Display the supplier that supplied the most computers. 2. Display the building location that has the most computers.
Question 10 Distinguish between SQL views and SQL entities