IT244assignment3.docx - Course Title Introduction to Database Q 1 Course Code IT244 Normalize the following schema with given constraints to BCNF(2

IT244assignment3.docx - Course Title Introduction to...

This preview shows page 1 - 3 out of 3 pages.

Course Title : Introduction to Database Course Code : IT244 Q. 1Normalize the following schema, with given constraints, to BCNF.(2 Point)books(accessionn, isbn, title, author, publisher)users(userid, name, deptid,deptname)accessionno isbnisbntitleisbnpublisherisbnauthoruserid nameuserid deptiddeptid deptnameBooks( Acession, Isbn)Isbn (Title, Author)Author (Publisher)Users( User ID, Name)Name( Dept ID, Deptname)Q. 2Consider the relational database given below, where the primary keys are underlined. Give an expression in Tuple Relational Calculusand Domain Relational CalculusFor each of the following queries:(0.5+0.5 = 1 Point) a.Find all employees who work directly for “STC”t | works (t) ^ t. Company name = ‘STC’ b.Find all cities of residence of all employees who work directly for “STC”e.name | employee (e) ^ e.street ^ e.city w | works (w) ^w.name = e.name ^ w.company name = ‘STC’Q. 3Consider the following database:(0.5+0.5+1= 2 Points)person (driver_id, name, addresscar(license, model
)
Image of page 1
Image of page 2
Image of page 3

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture