Question: From book Data Modeling and Database Design (2nd Edition) The answer for problem 11 is not there. This exercise is based on the data sets
From book "Data Modeling and Database Design (2nd Edition)"
The answer for problem 11 is not there.

This exercise is based on the data sets associated with Figure 2.25 in Chapter 2. Use the SQL Data Definition Language to create a relational schema the following three relations COMPANY (Co_name, Co_size, Co_headquarters) STUDENT (St name, St major, St status) INTERNSHIP (in_co_name, In_st name, In year, In.qtr, In location, In_stipend) When you create a table for each relation, in addition to defining its pr all the appropriate referential integrity constraints. Assume that Co_name is character data type of size 5, Co_ size is an integer data type of size 4, Co_headquaters is a character data type of size 10, St name is a Varchar data type of size 10, St_name is a Varchar data type of size 10, St_major's is a character data type of size 20, St_status is a character data type of size 2, In co_name is a character data type of size 5, In_st name is a Varchar data type size 10. In_year is an integer data type of size 4, In_qtr is a character data type 10 In_location is a character data type of size 15, and In stipend is an integer date size 4. In_stipend represents the monthly stipend associated with the intership. Use the SQL Insert statement to populate the three tables with the following data
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
