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

May I request that you elaborate on what SQL is?
In sql get to know the HR database, its tables, and their contents. Show the SQL query and the output. Display employees where the first name or last name startswith S. Display manager ID and number of employees managed bythe manager.
In this part, a real-world SQL database will be shown and discussed in detail.
When there is the potential for so many diverse approaches to be adopted by various companies, what are the benefits of sticking to a SQL standard?
1- What activities can be automated using PL/SQL, give 3 examples.
What is the history of SQL and what role does it play in database development?
Please answer the following question about SQL
Why do I need an index? What are the advantages and disadvantages of using indices in a study? What is the SQL syntax for creating an index?
It is important that the components and structure of the SQL Environment be specified and explained?
Please provide the correct sql query for the questions. Thanks
DVD Rental • DVD: Title, Director, Serial, Genre, Year Published • Customers: Customer ID, Name, Address, Email • Rentals: RentNum, Rent Date, Due Date, Customer ID, Serial • Employee: Employee ID, Name, Address, Email • Transactions: Transaction ID, Customer ID, Serial, Date 1. Write necessary SQL commands to create tables and input data to each table. 2. Write the queries using SQL statements. Show the output of your SQL queries using screen shot (a) Three queries for one table. (b) Three queries for two tables. (c) Three queries for three tables.