For developing our queries, we will be using the following relational schema:Student(SID, name, username, major)Course(cname, description, department, weight)Offering(OID, cname, year, term, duration)Enrolled(SID, OID, grade)A course relation is the generic description of a course which is offered by a department. Theoffering relation is the specific instance of a course being taught in a given term, and is theentity which will be associated with the student enrollment. Students are enrolled in theseofferings and achieve a mark.Express each of following queries in Relational Algebra:| Write a relational algebra query which will list the cname and description of allthe courses which are being offering in the Fall 2018 term.2 Write a relational algebra query which will list the name of all the students whohave earned 60% in both 'COSC2P12' and 'COSC2P13'.

Q1. Here we need to join relation Course and Offering and use selection operator to select only…

For developing our queries, we will be using the following relational schema: Student(SID, name, username, major) Course(cname, description, department, weight) Offering(OID, cname, year, term, duration) Enrolled(SID, OID, grade) A course relation is the generic description of a course which is offered by a department. offering relation is the specific instance of a course being taught in a given term, and is th entity which will be associated with the student enrollment. Students are enrolled in thes offerings and achieve a mark. Express each of following queries in Relational Algebra: |Write a relational algebra query which will list the cname and description o the courses which are being offering in the Fall 2018 term. 2 Write a relational algebra query which will list the name of all the students have earned 60% in both 'COSC2P12' and 'COSC2P13'.

For developing our queries, we will be using the following relational schema: Student(SID, name, username, major) Course(cname, description, department, weight) Offering(OID, cname, year, term, duration) Enrolled(SID, OID, grade) A course relation is the generic description of a course which is offered by a department. offering relation is the specific instance of a course being taught in a given term, and is th entity which will be associated with the student enrollment. Students are enrolled in thes offerings and achieve a mark. Express each of following queries in Relational Algebra: |Write a relational algebra query which will list the cname and description o the courses which are being offering in the Fall 2018 term. 2 Write a relational algebra query which will list the name of all the students have earned 60% in both 'COSC2P12' and 'COSC2P13'.

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Q: What are three indications that a surrogate key should be constructed for the primary key of a…

A: Surrogate key is unique key and also called as synthetic primary key. Surrogate key holds anonymous…

Q: ID name Courses M semester Teaches N ID name Professors Convert the above ER diagram to relations in…

A: SOLUTION -From the above Entity Relationship Diagram, we can identify three tables. They are1)…

Q: Vendor order (vendor no, order no, vendor name, qty provided, price/unit) is a second normal form…

A: Vendor order data is an essential component of many business processes, and it is important to have…

Q: Consider the following relational schema: Staff (staffNo, name, dept, skillCode) Skill (skillCode,…

A: The question is asking for SQL queries to extract specific information from a relational database.…

Q: Why do the functional dependencies among a relation's attributes have to do with the primary key of…

A: Dear Student, The detailed answer to your question is given below -

Q: The use of composite attributes are avoided in relation schema when the relation schema conforms to…

A: The use of composite attributes, are avoided in a relation schema when it is said to be in First…

Q: A foreign key can refer to only the candidate key of another relation. (a) True (b)False

A: A foreign key is a field or a set of fields (columns) in a relational database table that is used to…

Q: The type of algorithm in which decomposition of relation schema is constructed from other specific…

A: Certain algorithms are used to create relational decomposition from a set of relationships in…

Q: What does it mean to be related? How do you define a relation's properties?

A: Relation is a property of set that we study in discrete math. Two set be said as related when it…

Q: NORMALIZATION The table above displays snippet of the monthly loan application report send by all…

A: Answer:

Q: Mapping: Create relational schemas for the ER diagram given below. Indicate clearly the primary and…

A: The relational schema has been given in step 2.

Q: Describe the differences in meaning between the terms relation and relation schema.

A: A relation schema is the combination of list of attributes and their related domain types. An…

Q: Vendor order (vendor no, order no, vendor name, qty provided, price/unit) is a second normal form…

A: Vendor order data is an essential component of many business processes, and it is important to have…

Q: An explanation of the three circumstances in which the secondary key of a relation should be used…

A: Indicators that point to the existence of a surrogate key There are three circumstances that point…

Q: Describe three situations in which a substitute key for the main key of a relation should be…

A: Given: Indicators that point to the existence of a surrogate keyThere are three circumstances that…

Q: Consider the following relations: Album (albumId: integer, title: string, artistId (FK): integer)…

A: Relational algebra to address each of these queries:1. Find all the titles of the albums.…

Q: Implement a new independent entity phone in the Sakila database. Attributes and relationships are…

A: There is only one error in the above code and that is the ALTER TABLE command on the address table.…

Question

100%

For developing our queries, we will be using the following relational schema:
Student(SID, name, username, major)
Course(cname, description, department, weight)
Offering(OID, cname, year, term, duration)
Enrolled(SID, OID, grade)
A course relation is the generic description of a course which is offered by a department. The
offering relation is the specific instance of a course being taught in a given term, and is the
entity which will be associated with the student enrollment. Students are enrolled in these
offerings and achieve a mark.
Express each of following queries in Relational Algebra:
| Write a relational algebra query which will list the cname and description of all
the courses which are being offering in the Fall 2018 term.
2 Write a relational algebra query which will list the name of all the students who
have earned 60% in both 'COSC2P12' and 'COSC2P13'.

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

SEE SOLUTION Check out a sample Q&A here

Step 1

VIEW

Step 2

VIEW

Step by step

Solved in 2 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions

What does it mean to be related? How do you define a relation's properties?
Implement a new independent entity phone in the Sakila database. Attributes and relationships are shown in the following diagram: The diagram uses Sakila naming conventions. Follow the Sakila conventions for your table and column names: All lower case Underscore separator between root and suffix Foreign keys have the same name as referenced primary key Write CREATE TABLE and ALTER TABLE statements that: Implement the entity as a new phone table. Implement the has relationships as foreign keys in the Sakila customer, staff, and store tables. Remove the existing phone column from the Sakila address table. Step 2 requires adding a foreign key constraint to an existing table. Ex: ALTER TABLE customer ADD FOREIGN KEY (phone_id) REFERENCES phone(phone_id) ON DELETE SET NULL ON UPDATE CASCADE; Specify data types as follows: phone_id, phone_number, and country_code have data type INT. phone_type has date type VARCHAR(12) and contains strings like 'Home', 'Mobile', and 'Other'. Apply…
Explain three cases when a surrogate key should be generated in place of the main key of a relation.
What are three cases when a surrogate key might be used in place of a relation's main key?
What are three signals that a surrogate key should be generated for the primary key of a relation instead of using the main key?
Develop an Entity Relationships Diagram (ERD) based on the relational schemas in the 3NF for the starting relational schema in un-normalized form presented below. UNF:Order(OrderID, OrderDate, CustID, CustName, CustPhone, CCNum, CCExpDate, CCBank, BnkContName, BnkContPhone, CustEmail, OrderIP, SiteRefFrom, ShipStreet, ShipCity, ShipSt, ShipZip, OrderLineNum, ItemID, ItemName, ItemDesc, ItemQtyOrdered,ItemListPrice, ItemSalePrice, ItemQtyShip, ShipCharge, Tax, TotalDue)
1)A tuple is a named column of a relation. True or alse2)Each attribute in a relation has a distinct name. T/F3)The degree of a relation is the number of attributes it contains. T/F4)A foreign key is the candidate key that is selected to identify tuples. T/F
Convert to relation schema
TF (c) If a relation is not in BCNF, then it has at least three attributes in the schema.
Look at the 4 entities below and assume that customer_id is the key common to all tables. • Customer: An entity that describes a customer. An instance occurs for unique customers only using name, date of birth, and login name as customer_id primary key. • Online: An entity that describes a customer purchasing activity online. An instance occurs when the customer completes the transaction. Customers can purchase more than once. • Visits: An entity that describes a customer purchase in a physical store. An instance occurs if a customer makes or purchase or checks-in using an app. Customers can visit more than once per day. • Satisfaction: An entity that represents data from a recent customer satisfaction survey. An instance occurs when a customer takes the survey. A customer is tracked by login name and can only take the survey one time. Use the information to match the following relationships. Answers can be reused more than once. The relationship between Customer and Online The…
explanation of three circumstances where a substitute key for a relation's primary key should be created?