Question: databases Suppose tha we have the following relational database schema named the seventh art. The bold underlined attributes are the keys. The arrows show the

databases

Suppose tha we have the following relational database schema named the seventh art. The bold underlined attributes are the keys. The arrows show the foreign keys. * Artist( Artistid, name, BDate, Nationality, Gender) Contact(Artistid Phone Number) Movie(Movield Directorld, Title, Year) MovieRoles(Movield, Actorld RoleName, Description) , FK Festival (Festivalid, FName, City, Country) FK- Nominees(Festivalid, Movield, Year Awards) Award Winner(Artistld, Festivalld, Year AwardName) 1- Write in SQL the following queries (4 marks): a. Retrieve the phone number of the artist "Ali. b. Retrieve the actors of the movie titled "the longest day". c. Retrieve the number of awards won per actor's name. lutahore (h marks)

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!

My name is Salam Abdulhussein and I need this to be done as soon as possible. Please follow the steps one by one and make sure everything is correct Global Bike, Inc. ERP for Sales / Collection USING...

Create database table for each relation below. While doing so, you need to: Identify the sequence/order in which the tables shall be created Identify the primary key for each table, and include that...

For this question, consider the five relation schemas with the primary key underlined: artist ( id , name, status ) work ( id , name, work _ type, price ) gallery ( id , name, location ) exhibition (...

Please help with 5-19 and 5-20 Activity Manual Processing of Invoice and cash receipt 1.0 hour Electronic Processing of invoice and electronic funds transfer .1 hour Maintain Customer file .5 hour...

Now suppose the term structure is the following: Calculate the IRR and NPVs of the two projects. 9. Assume the following projects are mutually exclusive and that the opportunity cost of capital is...

Using the graph included below please answer the following questions. Please submit your solution as a file it can be any format, as long as it is clear Value of Stake of Bondholders of company XYZ...

Please help me to calculate the excercise 16 until 20 of this photo below 14 calculating Interest Rates ILO3l In a gall Moge dollar minted in 1Hgs sok fr 125.000 For his have been true. What ate of...

Indianapolis Auto Parts (IAP) has a Seat Manufacturing Department that uses ABC. IAP's activity cost allocation rates include the following: (Click on the icon to view ABC system data.) Suppose Ford...

The table provides the aggregate plan of It is known that the firm uses a chase plan. The firm's labor cost is $14/un hiring cost is $350 per unit of increase, and unit firing cost is $500 per unit...

1. Describe the elements of a comprehensive health assessment of a geriatric patient. What special considerations should the nurse keep in mind while performing this assessment? 2. End-of-life care...

Which of the following items is reported on the statement of cash flows under financing activities? Multiple Choice 8 0 1 : 0 0 : 5 4 Purchase of an investment. Sale of merchandise. Purchase of...

Seved Help 14 Wisconsin Snowmobile Corp. is considering a switch to level production Cost efficiencies would occur under level production, and aftertax costs would decline by $31,500, but inventory...

LO6 Identify how organizations can measure and analyze the effectiveness of HR management practices.

4. Assume you are an HR Director with a staff of seven people. A departmental objective is for all staff members to become professionally certified within a year. Using the Internet resources of HR...

LO3 Outline how HRs strategies are merged with organizational strategies and give two examples.