New

Learn smart - Learn online. Upto 88% off on courses for a limited time. View Courses

Securing Higher Grades Costing Your Pocket? Book Your Assignment at The Lowest Price Now!
loader
Add File

Error goes here

Files Missing!

Please upload all relevant files for quick & complete assistance.

Guaranteed Higher Grade!

IT403 Fundamental Of Database

tag 0 Download 2 Pages / 473 Words tag 28-07-2020
  • Course Code: IT403
  • University: Saudi Electronic University
    icon

    MyAssignmentHelp.com is not sponsored or endorsed by this college or university

  • Country: Saudi Arabia

Questions:

1:

1.Give an example of 3 relations illustrating primary keys and foreign keys.

2:

Consider the following relations:

Student(sID, surName, firstName, campus, email)
Course(dept, cNum, name)
?Offering(oID, dept, cNum, term, instructor)?
Took(sID, oID, grade)
Such as:
Offering[dept, cNum] ⊆ Course[dept, cNum]
Took[sID] ⊆ Student[sID]?
Took[oID] ⊆ Offering[oID]

Answer the following query using relational algebra:

1.Give the Student number of all students who have taken the course number “343” by the department “CS”.
2.Find sID of all students who have earned some grade over 80 and some grade below 50. 
3.Find the Terms when the course number “369” by the department “CS” was not offered. 
4.Find the Department and course number of courses that have never been offered.

 
Download Sample Now

Earn back the money you have spent on the downloaded sample by uploading a unique assignment/study material/research material you have. After we assess the authenticity of the uploaded content, you will get 100% money back in your wallet within 7 days.

Upload
Unique Document

Document
Under Evaluation

Get Money
into Your Wallet

Total 2 pages

Cite This Work

To export a reference to this article please select a referencing stye below:

My Assignment Help. (2020). Fundamental Of Database. Retrieved from https://myassignmenthelp.com/free-samples/it403-fundamental-of-database.

"Fundamental Of Database." My Assignment Help, 2020, https://myassignmenthelp.com/free-samples/it403-fundamental-of-database.

My Assignment Help (2020) Fundamental Of Database [Online]. Available from: https://myassignmenthelp.com/free-samples/it403-fundamental-of-database
[Accessed 11 August 2022].

My Assignment Help. 'Fundamental Of Database' (My Assignment Help, 2020) <https://myassignmenthelp.com/free-samples/it403-fundamental-of-database> accessed 11 August 2022.

My Assignment Help. Fundamental Of Database [Internet]. My Assignment Help. 2020 [cited 11 August 2022]. Available from: https://myassignmenthelp.com/free-samples/it403-fundamental-of-database.


We Can Help!

Get top notch assistance from our best tutors !
Excel in your academics & career in one easy click!

icon

Other Samples

Content Removal Request

If you are the original writer of this content and no longer wish to have your work published on Myassignmenthelp.com then please raise the content removal request.

icon

5% Cashback

On APP - grab it while it lasts!

Download app now (or) Scan the QR code

*Offer eligible for first 3 orders ordered through app!

screener
ribbon
callback request mobile
Have any Query?