Question: Write the following SQL queries based on the following relational schema: Student(stdID: char(5), stdName:varchar (50), age:number, address: varchar(250), Course(crscode: char(5), crsName: varchar(50), crsCredit: number(1)) Enrol

Write the following SQL queries based on the following relational schema: Student(stdID: char(5), stdName:varchar (50), age:number, address: varchar(250), Course(crscode: char(5), crsName: varchar(50), crsCredit: number(1)) Enrol (stdID: char(5), crscode: char(5), trimester:number(1), enrYear:date, mark Program(prgCode: char(5), prgName: varchar(25) ) List the student ID and programme name of all students who lives in Melbourne CBD (i.e. VIC 3000 ). [5 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!

Assignment 3 Instructions Create a database in SQLServer for the relational model provided in the HW3- Relational Schema file. Populate your database with some data to test your database. Write the...

Populating database with sample data AND 5. and 6. Questions. I want answer for 3 questions that i wrote bold and also I mentioned above. Thank you SHIP Shiple ShipName Weight YearBuilt...

World Traveler Cruise Line SHIP Ship Nurriter Ship Name Weight Year Built Passenger Capacity CRUISE Cruise Serial Number Sailing Date Return Date VISITS Visit Order BOOKING Price Satisfaction Rate...

Create a database in SQLServer for the relational model provided in the HW3- Relational Schema file. Populate your database with some data to test your database. Write the requested queries in SQL....

Can you answer the questions I squared on the red below? Thank you very much, I really appreciate your work. Create a database in SQLServer for the relational model provided in the HW3- Relational...

Note : I've created the database and made the script to create the table and insert the records into the tables but I am unable to add it here. The only favor I want from you to write the SQL query...

Query writing and relational algebra Expression Write the following sql queries using the Cape Codd DB on bottom 1. Write a SQL statement to show sku and Description for all products having a SKU...

Query writing and relational algebra Expression Write the following sql queries using the Cape Codd DB. 1. Write a SQL statement to show sku and Description for all products having a SKU description...

The graphs show the percentage of American adults in two living arrangements from 1960 through 2008. Percentage of U.S. Adults 60% 50% 40% 30% 20% 10% Living Arrangements of U.S. Adults (1960, 47)...

SS (a) Briefly describe and contrast the behaviour of brittle and ductile materials when subjected to gradually your answer. Also give at least one example of a common material for each type....

Which of the following is a correct ranking of securities based on their volatility / risk during the period from 1 9 2 6 to 2 0 2 2 ? Rank from highest to lowest variability / risk . c . Long - term...

Persian Rugs needs $300 million to support growth next year. If it issues new common stock to raise the funds, the flotation (issuance) costs will be 4 percent. If Persian can issut stock at $125 per...

2. What are the management, organization, and technology components of Schiphols baggage conveyors network? Conceptually, baggage handling is quite simple. Baggage input is connected to merely two...

4. Think of the data that the network uses. What kinds of management reports can be generatedfrom that data? Conceptually, baggage handling is quite simple. Baggage input is connected to merely two...

1-17 What are the strategic objectives that firms try to achieve by investing in information systems and technologies? For each strategic objective, give an example of how a firm could use...