Notes
Notes - notes.io |
*STUDENTS(StId, StName, Major, Age)
*AUTHORS(AName, Address)
*borrows(DocId, StId, Date)
*has-written(DocId, AName)
*describes(DocId, Keyword)
-List the year and title of each book.
Project_year,title(BOOKS)
-List all information about students whose major is CS
Select_Major = "CS"(BOOKS)
-List all students with the books they can borrow
STUDENTSxborrows
-List all books published by McGraw-Hill before 1990
Select_Year<1990(Select_Publisher="McGraw-Hill"(BOOKS))
-List the name of those authors who are living in Davis
Project_AName(Select_Address="Davis"(AUTHORS))
-List the name of students who are older than 30 and who are not studying CS
Project_StName(Select_Major!="CS"(Select_Age>30(STUDENTS))
OR
Select_Age>30(STUDENTS)-Select_Major="CS"(STUDENTS)
-Rename AName in the relation Authors to Name
Assignment_Name->AName(AUTHORS)
-List the names of all students who have borrowed a book and who are CS majors
Project_StName(Select_STUDENTS.StId=borrows.StId(Select_Major="CS"(STUDENTSxborrows)))
-List the title of books written by the author "Silberschatz"
Project_Title(Select_AName="Silberschatz"(Select_BOOKS.DocId=has-written.DocId(BOOKSxhas-written)))
-As 2., but not books that have the keyword "database"
Project_Title(Select_AName="Silberschatz"(Select_BOOKS.DocId=has-written.DocId(BOOKSxhas-written))) - Project_Title(Select_describes.DocId=BOOKS.DocId(Select_keyword="database"(BOOKSxdescribes)))
-Find the name of youngest student
Project_StName(STUDENTS) - Project_S1.StName(Select_S1.Age>S2.Age(Assignment_S1->STUDENTS x Assignment_S2->STUDENTS))
-Find the title of the oldest book
Project_Title(BOOKS) - Project_B1.Title(Select_B1.Year<B2.Year(Assignment_B1->BOOKS x Assignment_B2->BOOKS))
|
|
Notes.io is a web-based application for taking notes. You can take your notes and share with others people. If you like taking long notes, notes.io is designed for you. To date, over 8,000,000,000 notes created and continuing...
With notes.io;
- * You can take a note from anywhere and any device with internet connection.
- * You can share the notes in social platforms (YouTube, Facebook, Twitter, instagram etc.).
- * You can quickly share your contents without website, blog and e-mail.
- * You don't need to create any Account to share a note. As you wish you can use quick, easy and best shortened notes with sms, websites, e-mail, or messaging services (WhatsApp, iMessage, Telegram, Signal).
- * Notes.io has fabulous infrastructure design for a short link and allows you to share the note as an easy and understandable link.
Fast: Notes.io is built for speed and performance. You can take a notes quickly and browse your archive.
Easy: Notes.io doesn’t require installation. Just write and share note!
Short: Notes.io’s url just 8 character. You’ll get shorten link of your note when you want to share. (Ex: notes.io/q )
Free: Notes.io works for 12 years and has been free since the day it was started.
You immediately create your first note and start sharing with the ones you wish. If you want to contact us, you can use the following communication channels;
Email: [email protected]
Twitter: http://twitter.com/notesio
Instagram: http://instagram.com/notes.io
Facebook: http://facebook.com/notesio
Regards;
Notes.io Team
