Q1: Consider the below schema for a library database and write relational algebra expressions for the following queries                                                                                                             [1.5 Marks]

• Author ( authorname, citizenship, birthyear)
• Book(isbn, title, authorname)
• Topic(isbn, subject)
• Branch(libname, city)
• Instock(isbn, libname, quantity)

 

Give all authors’ names born after 1940.                                [0.25 Point]Give the names of libraries in Sydney.                                   [0.25 Point]Give the cities where each book is held.                                 [0.25 Point]

1. Give the title of each book on the topic of either alcohol or drugs.                           [0.25 Point]
2. Give the title and author of each book of which at least two copies are held in a branch located in Melbourne.                                                                        [0.50 Point]

 

Q2.  What are the responsibilities of a DBA? If we assume that the DBA is never interested in running his or her own queries, does the DBA still need to understand query optimization? Why?      [1.5 Marks]

Q3: What are the drawbacks of using file system over database management system?        [1 Marks]

Q4: Consider the advisor relation shown in Figure 2, with s_idas the primary key of advisor. Suppose a student can have more than one advisor. Then, would s_idstill be a primary key of the advisor relation? If not, what should the primary key of advisor be?                                                                 [1 Marks]

 

Schema Diagram for University Database.

 

 

1INTRODUCTION TO DATABASE (IT244)ASSIGNMENT 1(LAST DATE TO SUBMIT: 20/02/2016)Q1: Consider the below schema for a library database and write relational algebra expressions for thefollowing queries[1.5 Marks]1.Giveall authors’ namesbornafter1940.[0.25 Point]2.Give the names of libraries in Sydney.[0.25 Point]3.Give the cities where each book is held.[0.25 Point]4.Give the title of each book on the topic of either alcohol or drugs.[0.25 Point]5.Give the title and author of each book of which at least two copies are held in a branch located inMelbourne.[0.50 Point]Q2.What are the responsibilities of a DBA? If we assume that the DBA is never interested in runninghis or her own queries, does the DBA still need to understand query optimization? Why? [1.5 Marks]Q3: What are the drawbacks of using file system over database management system?[1 Marks]Q4: Consider theadvisorrelation shown in Figure 2, withs_idas the primary key ofadvisor. Suppose astudent can have more than one advisor. Then, woulds_idstill be a primary key of theadvisorrelation?If not, what should the primary key ofadvisorbe?[1 Marks]1.Author ( authorname,citizenship, birthyear)2.Book (isbn, title, authorname)3.Topic (isbn, subject)4.Branch (libname, city)5.Instock (isbn, libname,quantity)

• 1495854358-IT 244 - Assignment 1.docx

ComputerScienceExpert

(11)

Status NEW Posted 27 May 2017 03:05 AM My Price 9.00

-----------

Attachments

file 1495854361-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