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

A Guide to SQL

9th Edition

ISBN:9781111527273

Author:Philip J. Pratt

Publisher:Philip J. Pratt

Chapter2: Database Design Fundamentals

Section: Chapter Questions

Problem 5RQ: What is a relation?

See similar textbooks

Similar questions

What is a well-structured relation?
_is a property of the entire relation, A_ rather than of the individual tuples in which each tuple is unique.
What is the link between the main key of a relation and the functional connections between all of its attributes?
//Last three parts not answered before You are working with a database that stores information about suppliers, parts and projects. The Supply relation records instances of a Supplier supplying a Part for a Project. The schema for the database used in this question is as follows: ( primary keys are shown underlined, foreign keys in bold). SUPPLIER (SNo, SupplierName, City) PART (PNo, PartName, Weight) PROJECT (JobNo, JobName, StartYear, Country) SUPPLY (SNo, PNo, JobNo, Quantity) Provide relational algebra (NOT SQL) queries to find the following information. NOTE: You can use the symbols s, P, etc or the words ‘PROJECT’, ‘RESTRICT’ etc . do not need to try to make efficient queries – just correct ones. Where you use a join, always show the join condition. List the quantity of parts supplied on JobNo 4745. List the weight of the Part named “Left-handed screwdriver”. List the Project name and Part name of any Parts where fewer than 500 of the part has been supplied to a particular…
Instructions: Write your answers by replacing the blue lines. Explain your answers if necessary. REGIONAL LABS CASE QUESTIONS Regional Labs is a company that conducts research and development work on a contract basis for other companies and organizations. Figure 3-32 shows data that Regional Labs collects about projects and the employees assigned to them. This data is stored in a relation (table) named PROJECT: PROJECT (ProjectID, EmployeeName, EmployeeSalary) Assuming that all functional dependencies are apparent in this data, which of the following are true? ProjectID à EmployeeName _______ ProjectID à EmployeeSalary _______ EmployeeName à EmployeeSalary _______ EmployeeSalary à ProjectID _______ EmployeeSalary à (ProjectID, EmployeeName) ______ What is the primary key of PROJECT? ________________________________ Are all the non-key attributes (if any) dependent on the primary key? ____________________________________________…
Instructions: Write your answers by replacing the blue lines. Explain your answers if necessary. REGIONAL LABS CASE QUESTIONS Regional Labs is a company that conducts research and development work on a contract basis for other companies and organizations. Figure 3-32 shows data that Regional Labs collects about projects and the employees assigned to them. This data is stored in a relation (table) named PROJECT: PROJECT (ProjectID, EmployeeName, EmployeeSalary) Assuming that all functional dependencies are apparent in this data, which of the following are true? ProjectID ->EmployeeName _______ ProjectID ->EmployeeSalary _______ EmployeeName -> EmployeeSalary _______ EmployeeSalary -> ProjectID _______ EmployeeSalary -> (ProjectID, EmployeeName) ______ What is the primary key of PROJECT? ________________________________ Are all the non-key attributes (if any) dependent on the primary key?…
Identify the normal form it is in. Please make sure to provide explanations to support your answer. Convert it to BCNF. 1.GRADES (S#, C#, sem, year, F#, FName, Sname, Cname, grade, crHrs) a) Write down the following functional dependencies: S# --> C# --> F# --> b) Which normal form is the above relation in? c) Convert it to BCNF: 2.TEACHES (C#, sem, year, F#, Fname, Foffice) a) Write down the functional dependency for F#: F# --> b) Which normal form is the above relation in? c) Convert it to BCNF 3. R (a,b,c,d,e,f,g) Given that: d --> a e --> f,g a) Which normal form is the above relation in? b) Convert it to BCNF:
Consider the relational schema for a library system as given below: Member (mem_no, name, dob) Books (isbn, title, authors, publisher) Borrowed (mem_no, isbn, date) Write the following queries in relational algebra. i. List the members who have not borrowed any books from the library. ii. Name all the books borrowed by a member named 'Ram'. ii. List the book that has been borrowed the most.
Identify if the following relation is in 1NF: STUDENT(StudentID, FirstName, LastName, (CourseID, CourseName, CourseLocation))
What is the connection between a relation's primary key and the functional relationships between all of its attributes?
Vendor order (vendor no, order no, vendor name, qty provided, price/unit) is a second normal form relation. a. vendor (order number, vendor name, quantity delivered, price/unit) O b. vendor (vendor no, vendor name) order (order no, qty provided, price/unit) order (vendor, order) O c vendor (vendor no, vendor name) order (order no, quantity given, price/unit) O d. vendor (vendor no, vendor name) qty (qty provided, price/unit) order (order no, quantity supplied)
18. The relation with the attribute which is the primary key is referenced in another relation. The relation which has the attribute as primary key is called a. Referential relation b. Referencing relation c. Referenced relation d. Referred relation