Question: 1. Consider the database schema: STUDENT (Name, Student_number, Class, Major), COURSE (Course_name, Course_number, Credit_hours, Department), SECTION (Section_identifier, Course_number, Semester, Year, Instructor), PREREQUISITE (Course_number, Prerequisite_number), where

1. Consider the database schema: STUDENT (Name, Student_number, Class, Major), COURSE

1. Consider the database schema: STUDENT (Name, Student_number, Class, Major), COURSE (Course_name, Course_number, Credit_hours, Department), SECTION (Section_identifier, Course_number, Semester, Year, Instructor), PREREQUISITE (Course_number, Prerequisite_number), where example values of Department are: CS, MATH, MUSIC, and example values for Course_number are: CS3130, MATH1003, MUSIC2343 (i.e. each Course_number has the Department as prefix). a. If the name of the 'CS' (Computer Science) Department changes to CSSE (Computer Science and Software Engineering) Department and the corresponding prefix for the course number also changes, identify the columns in the database that would need to be changed. b. Can you restructure the columns in COURSE, SECTION, and PREREQUISITE tables so that only one column will need to be changed? Note that in the COURSE table, the column Course Dept will not be needed after the above change, since it is redundant with the Department column

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!

Suppose we have a database consisting of the following four relations: Student (name, studentnumber, class, major) Course (courename, coursenumber, credithours, department) Section...

Repeat Exercise 10.7, but write a function in SQL/PSM. Exercise 10.7 Consider the database shown in Figure 1.2, whose schema is shown in Figure 2.1. Write a program segment to read a students name...

Repeat Exercise 10.7, but use SQLJ with Java as the host language. Consider the database shown in Figure 1.2, whose schema is shown in Figure 2.1. Write a program segment to read a students name and...

What are the referential integrity constraints that should hold on the schema? Write the appropriate SQL DDL statements to define the two relations, COURSE, and SECTION, of the database - you don't...

Q2. Consider Figure 2 below. In addition to constraints relating the values of columns in one table to columns in another table, there are also constraints that impose restrictions on values in a...

In addition to constraints relating the values of columns in one table to columns in another table, there are also constraints that impose restrictions on values within a column or within a...

Identify the column or the group of columns in the following tables that must be PRIMARY KEY or UNIQUE or FOREIGNKEY attributes across all rows in the table? STUDENT Name Student_number Class Major...

1. Which course Chang is taking? 2. Which course Anderson taught in Spring 08? 3. Which student get A Grade in which course? 4. What is prerequisite of CS3380? 5. How many sections in fall 08? 6....

Consider the following relations for a database that keeps track of student enrollment in courses. STUDENT Name Student_number Class Major Smith 17 1 1 CS Brown 8 2 CS GRADE REPORT Student number...

Given the following database sample instance, write the following SQL queries: (CLO 3) Student Name Student_number Class Major Smith 17 1 CS Brown 8 2 CS Course Course_name Course_number Credit_hours...

In preparing its bank reconciliation for the month of May 2022, a business has the following information available. What should be deducted from the balance per bank statement at May 31, 2022?...

In preparing the bank reconciliation for the month of December, Case Company provided the following data: Balance per bank statement Deposit in transit Amount erroneously credited by bank to Case's...

When hikers and skiers go into terrain where there is a risk of avalanches, they take safety equipment including avalanche rescue beacons. These rescue beacons send out electromagnetic field signals...

CT Corp Comprehensive Question Canadian Tire Corporation, Limited ( Canadian Tire ) is a family of companies that includes a retail segment and a financial services division, among others. The retail...

Have you ever experienced (or been responsible for) a failed attempt at sarcasm or teasing via a text message or social network posting? What, in your opinion, caused this communication breakdown?...

B When you were in high school, what styles did you wear, and what did these clothing items communicate about you? If you now have or have had teen children, what do or did they seem to be...

1. Take a look at a piece of writing youve produced (an essay, your rsum, or an e-mail to a friend). Do you use high or low levels of abstraction? Is your choice of language appropriate for the...