kindly need full answer it 403 fundamental database
1.Give an example of 3 relations illustrating primary keys and foreign keys.
Learning Outcome(s): LO7
Use Structured Query Language to perform queries and to perform relational operations.
Consider the following relations:
Student(sID, surName, firstName, campus, email)
Course(dept, cNum, name)
Offering(oID, dept, cNum, term, instructor)
Took(sID, oID, grade)
Offering[dept, cNum] ⊆Course[dept, cNum]
Answer the following query using relational algebra:
- Give the Student number of all students who have taken the course number “343” by the department “CS”.
- Find sID of all students who have earned some grade over 80 and some grade below 50.
- Find the Terms when the course number “369” by the department “CS” was not offered.
- Find the Department and course number of courses that have never been offered.
Looking for solution of this Assignment?
WHY CHOOSE US?
We deliver quality original papers
|Our experts write quality original papers using academic databases.|
|We offer our clients multiple free revisions just to ensure you get what you want.|
|All our prices are discounted which makes it affordable to you. Use code FIRST15 to get your discount|
|We deliver papers that are written from scratch to deliver 100% originality. Our papers are free from plagiarism and NO similarity|
|We will deliver your paper on time even on short notice or short deadline, overnight essay or even an urgent essay|