Question: Consider Figure 1.2. a. If the name of the CS (Computer Science) Department changes to CSSE (Computer Science and Software Engineering) Department and the corresponding

Consider Figure 1.2.

STUDENT Name Student_number Class Major Smith 17 CS Brown 8. 2 CS

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 updated.

b. Can you restructure the columns in the COURSE, SECTION, and PREREQUISITE tables so that only one column will need to be updated?

STUDENT Name Student_number Class Major Smith 17 CS Brown 8. 2 CS COURSE Course_name Course_number Credit_hours Department Intro to Computer Science CS1310 4 CS Data Structures CS3320 4 CS Discrete Mathematics MATH2410 3 MATH Database CS3380 3. CS SECTION Section_identifier Course_number Semester Year Instructor 85 MATH2410 Fall 07 King 92 CS1310 Fall 07 Anderson CS3320 Spring Knuth 102 08 112 MATH2410 Fall 08 Chang 119 CS1310 Fall 08 Anderson 135 CS3380 Fall 08 Stone GRADE_REPORT Student_number Section_identifier Grade 17 112 B 17 119 8 85 A 8 92 A 102 B 8 135 A PREREQUISITE Course_number Prerequisite_number CS3380 CS3320 CS3380 MATH2410 CS3320 CS1310

Step by Step Solution

★★★★★

3.43 Rating (162 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

a The columns that needs to be updated are StudentMajor CourseCours... View full answer

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 Fundamentals Of Database Systems Questions!

Identify three accounting software packages that you would consider for a small business. Explain what must be taken into consideration when selecting small business accounting software. And, state...

In this exercise, you will use database software to design a database for managing inventory for a small business. Sylvester's Bike Shop, located in San Francisco, California, sells road, mountain,...

In the physical implementation depicted in Figure the computer updated the accounts payable data upon receipt of a vendor invoice (a clerk handled any exceptions). Describe the procedures that you...

Consider Figure 1.2. 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...

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,...

Q1. [ 50 points) Given an example database that stores students and course information (Fig. 1.2 from the book). (a) [ 10 points) Write at least FIVE advantages of using database systems for any...

( 2 5 pts ) Consider the image below: ( 5 pts ) If the name of the ' CS ' ( Computer Science ) Department changes to 'CSSE' ( Computer Science and Software Engineering ) Department and the...

[4 points] 1.14 Consider Figure 1.2 in the textbook. 1. If the name of the'CS' (Computer Science) Department changes to 'CSSE' (Computer Science and Software Engineering) Department and the...

MATHEMATICS FOR MACHINE LEARNING Marc Peter Deisenroth A. Aldo Faisal Cheng Soon Ong Contents Foreword 1 Part I Mathematical Foundations 9 1 Introduction and Motivation 11 1.1 Finding Words for...

Task 1 - Creating Your Own Personal Webpage Your first task is to create a personal webpage. Your personal web page should contain the following items: 1. Your name at the top of the page as an...

A baby's spoon with an area of 6.25 cm2 is plated with silver from AgNO3 using a current of 2.00 A baby's spoon with an area of 6.25 cm2 is plated with silver from AgNO3 using a current of 2.00 A for...

La Hacienda Company has two departments: Furniture and Lighting. La Haciendas accountant prepares an adjusted trial balance (shown below) at the end of the fiscal year. The trial balance is prepared...

What are Bao's options with regarding the IRA he will inherit from his grandfather? Group of answer choices Transfer the money into an inherited IRA and take RMD ' s based on his grandfather's age....

What are the main methods a group can use to make decisions? What are the advantages and disadvantages of each?What are the responsibilities of participants at meetings?

Consider the EMPLOYEE table's constraint EMPSUPERFK as specified in Figure 4.2 is changed to read as follows: CONSTRAINT EMPSUPERFK FOREIGN KEY (SUPERSSN) REFERNCES EMPLOYEE(SSN) ON DELETE CASCADE ON...

Specify the following additional queries on the database of Figure 3.5 in SQL. Show the query results if applied to the database of Figure 3.6. (a) For each department whose average employee salary...

Specify the following queries in SQL on the database schema of Figure 1.2. (a) Retrieve the names and major departments of all straight-A students (students who have a grade of A in all their...

The Investments Fund sells Class A shares with a front-end load of 8% and Class B shares with 126-1 fees of 0.75% annually as well as back-end load fees that start at 5% and fall by 1% for each full...

Self and Consulting tom prestados $8200 de First Bank el 1 de junio de 2019 y emiti un pagar a cuatro meses con un inters del 6 %. Con base en la informacin, registre los asientos de diario de ajuste...

Travelers pay taxes for flying, car rentals, and hotels. The following data represent the total travel tax for a 3-day business trip in eight randomly selected cities. NOTE: Chicago has the highest...