deadline 17 dec

Normalize the following schema, with given constraints, to BCNF.                       (2 Point)

books(accessionn, isbn, title, author, publisher)

users(userid, name, deptid, deptname)

F= { accessionno        isbn

isbn        title

isbn        publisher

isbn        author

userid         name

userid        deptid

deptid         deptname}

Assignment – 3Course Title: Introduction to DatabaseCourse Code : IT244Due Date: 17 December, 2016Q. 1Normalize the following schema, with given constraints, to BCNF.(2 Point)books(accessionn, isbn, title, author, publisher)users(userid, name, deptid, deptname)F= { accessionnoisbnisbntitleisbnpublisherisbnauthoruseridnameuseriddeptiddeptiddeptname}Q. 2Consider the relational database given below, where the primary keys are underlined.Give an expression inTuple Relational CalculusandDomain Relational Calculusfor each of the following queries:(0.5+0.5 = 1 Point)a. Find all employees who work directly for “STC”b. Find all cities of residence of all employees who work directly for “STC”Q. 3Consider the following database:(0.5+0.5+1= 2 Points)person(driver_id,name,address)car(license,model,year)accident(report_number,date,location)owns(driver_id,license)participated(report_number,license,driver_id,damage_amount)1.Write SQL DDL corresponding to the following schema. Make any reasonableassumptions about data types, and be sure to declare primary and foreign keys.2.Find the number of accidents in which the cars belonging to “John Smith” wereinvolved.3.Update the damage amount for the car with license number “AABB2000” in theaccident with report number “AR2197” to $3000.

• 1493970110-IT 244 - Assignment 3.docx

ComputerScienceExpert

(11)

Status NEW Posted 05 May 2017 07:05 AM My Price 11.00

-----------

Attachments

file 1493970112-Solutions file 2.docx preview (51 words )

H-----------ell-----------o S-----------ir/-----------Mad-----------am ----------- Th-----------ank----------- yo-----------u f-----------or -----------you-----------r i-----------nte-----------res-----------t a-----------nd -----------buy-----------ing----------- my----------- po-----------ste-----------d s-----------olu-----------tio-----------n. -----------Ple-----------ase----------- pi-----------ng -----------me -----------on -----------cha-----------t I----------- am----------- on-----------lin-----------e o-----------r i-----------nbo-----------x m-----------e a----------- me-----------ssa-----------ge -----------I w-----------ill----------- be----------- qu-----------ick-----------ly -----------onl-----------ine----------- an-----------d g-----------ive----------- yo-----------u e-----------xac-----------t f-----------ile----------- an-----------d t-----------he -----------sam-----------e f-----------ile----------- is----------- al-----------so -----------sen-----------t t-----------o y-----------our----------- em-----------ail----------- th-----------at -----------is -----------reg-----------ist-----------ere-----------d o-----------n -----------THI-----------S W-----------EBS-----------ITE-----------. ----------- Th-----------ank----------- yo-----------u -----------

Not Rated(0)

• Buy Answer