DatabaseCourse Code : IT244Q
Gents,
Kindly, help me with attached questions.
Thanks
Assignment – 3Course Title: Introduction to DatabaseCourse Code : IT244Q. 1Normalize the following schema, with given constraints, to BCNF.(2 Point)books(accessionn, isbn, title, author, publisher)users(userid, name, deptid, deptname)accessionnoisbnisbntitleisbnpublisherisbnauthoruseridnameuseriddeptiddeptiddeptnameQ. 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.
Attachments:
Answers
Status NEW
Posted 05 May 2017 08:05 AM
My Price 8.00
-----------
Attachments
file 1493974312-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)