Question: 3. Write four SQL update statements to do the following updates on the database schema shown in Figure 1.2. Show the affected tables after update

3. Write four SQL update statements to do the following updates on the database schema shown in Figure 1.2. Show the affected tables

3. Write four SQL update statements to do the following updates on the database schema shown in Figure 1.2. Show the affected tables after update through script file in sqlplus and in a script file created as before and named username_assn3que3.txt (5 marks) Total for que 3 is 5 marks) (a) Insert a new musician in the database. (b) Change the address of musician "John Doe' to 500 Airport Rd. (c) Insert a new album (d) Delete all performance records for songs whose name is 'Hello World' Fig 1.2: Schema of the Windsor Music Records database of Figure 1.1 Musician SSN MName Maddress Phone Instrument Iname Musickey Album Aid atitle copyrightdate format Song stitle author Play SSN Iname

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!

Database Administration CHAPTER OBJECTIVES I Understand the need for and importance of database I ttno'illI the meaning of ACID transaction administralin - Learn the tour 1992 ANSI standard isolation...

CIS-336: Lab 3: Building the Physical Model LAB OVERVIEW Scenario and Summary The lab for this week addresses taking a logical database design (data model) and transforming it into a physical model...

DAD 2 2 0 Project One Complete the steps below to create three tables named Customers, Orders, and RMA, in the QuantigrationUpdates database. Specifically, you must address the following rubric...

CSIT435 DBMS Administration Project A company X has hired you to manage its database. Choose a subject and propose a database for the company X. Perform the following tasks under Microsoft SQL Server...

Write Ten SQL SELECT statements to query the STUDENT schema you created for practice lab2. Your Select Statements should run error-free and should be valid. Submit two separate files: one plain text...

Preliminary work for this Project 1 . Use the CREATE and SELECT SQL statements to Create a Temporary table as a full copy ( all rows & columns ) of the table ORDERS. Name the new table ORDERS _ COPY....

1. Given a database state of the Windsor Music Records database shown in Figure 1.1, with schema shown in Figure 1.2 Total for que 1 is 15 marks) Fig 1.1: An Example Database State of Windsor Music...

LINK TO SQL DATA HERE ( had to add a space in between so it does not get blocked) https://drive.go ogle.com/file/d/1qHCkrods5K2V1syyS5IG6-Eb_3QQmud7/view?usp=sharing TABLE SQL DATA BELOW -- MySQL...

In Fig P2.11, sensor A reads 1.5 kPa (gage). All fluids are at 20°C. Determine the elevations Z in meters of the liquid levels in the open piezometer tubes B and C. ABC 2 m Air 1.5 m Gasoline 1m...

How do unemployment and inflation interact in the economy? Discuss the concept of the Phillips curve and the trade-off between unemployment and inflation. Analyze the relationship between these two...

What additional factors must be considered when deriving basic EPS assuming that net income and the number of shares outstanding at the beginning of the reporting period are already known? ( S

Which of the following are problems with identifying users of ABC? Multiple select question. ABC means different things to different organizations. Organizations will announce the discontinuance of...

cultural empathy: sensitivity to other cultures and a non-judgmental understanding of other cultures is probably essential;

diplomatic skills: an ability to deal with others, negotiate and to represent the parent company on foreign assignment; this may even involve interaction with politicians and government officials in...

adaptability and flexibility: this includes the ability to integrate with other people and other cultures and different types of business operations; being adaptable to change; having the ability to...