Question: (a) Give the SQL required to create a database that represents the E-R data model for the library given in Figure 1. In your database

(a) Give the SQL required to create a database that represents the E-R data model for the library given in Figure 1. In

(a) Give the SQL required to create a database that represents the E-R data model for the library given in Figure 1. In your database definition, you should use: the posted foreign key approach to implement the Borrows relationship; SQL domains to implement constraints c.1 and c.2; and a check constraint to implement constraint c.3. An IT company has a small library of books on computing that its employees are able to borrow. When a particular book is on loan then employees are able to reserve it. Figure 1 gives the E-R model for the library. Entity-relationship diagram Borrows 0..1 0..* Employee Book Reserves 0..* 0..* Entity types Employee (StaffNo, Name) Book (BookNo, Title, Author) Additional constraints c.1 Each employee is identified by a number that takes a value in the range 001 to 999. c.2 Each book is identified by a code that takes a value in the range B001 to B999. c.3 An employee may not reserve a book that he or she is currently borrowing. Limitations 1.1 Only current loans and reservations are recorded. Figure 1 The E-R model for the library

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

An IT company has a small library of books on computing that its employees are able to borrow. When a particular book is on loan then employees are able to reserve it. Figure 1 gives the E-R model...

Here are the steps you need to go through to do the project: Given the business rules above, create a logical-level Crows Foot ERD using Visio. Show all original entities and any associative entities...

In a school sports day, a fun activity is being planned for the parents. Any parent can participate in the activity but they must first register. They must provide their name, their child's name...

Complete an information and physical level design of a database for Holt Distributors. Holt Distributors starts on page 337 with the general description, and goes through page 343. Read the entire...

I also publish the same provided with the picture to make your work easier. i appreciate your work. Thank you very much SHORT SUMMARY: Provided the queries as per the requirement. Given the add...

We will use a simple database composed of the following tables: CUSTOMER, INVOICE, LINE, PRODUCT, and VENDOR. This database model is shown in Figure 6.1. The database model in Figure 6.1 reflects the...

This case study assignment is based on (but not the same as) the Queen Anne Curiosity Shop (QACS) Case Questions at the end of Chapters 5 and 6. Since there are important differences between the...

Figure A.1: ER diagram Client-Borrows-Book Database Borrows Book 1 library 5 BId Btype N FN Client Name Id LN Phone employee regular M helps date Use the ER diagram of Figure A.1 to answer the next...

Figure A.1: ER diagram Client-Borrows-Book Database Borrows Book library BI Bisne N FN Client Name Id LN Phone employee regular M 1 helps date Use the ER diagram of Figure 4.1 to answer the next few...

A square with side L flies past you at speed v, in a direction parallel to two of its sides. You stand in the plane of the square. When you see the square at its nearest point to you, show that it...

An over consists of six balls bowled by one bowler to one batsman and the outcome of each ball can be one of 0 runs, 1 run, 2 runs, 3 runs, 5 runs, illegal, or out. The batsmans state must be updated...

Question 4 El valor efectivo o rms del voltaje se define como el valor m ximo divido entre la raiz de 3 el valor m ximo divido entre 2 el valor m ximo divido entre 3 el valor m ximo divido entre la...

Compared with half a century ago, adoption has become _ _ _ _ _ _ _ _ _ common, but it is more open and acceptabl e , so we probably discuss it _ _ _ _ _ _ _ . fill in the blanks more or much less or...

List six applications of responsiveness in an organisation: for example, external phone calls answered within five rings. How many organisations can you think of that compete overtly on time, such as...

2 Explain the significance of P:D ratios. How can the production lead time be reduced?

2 Tiering of the supply network is referred to in section 4.4.1 above, and also in Chapter 1, section 1.1, and in the Global Lighting case study at the end of Chapter 2. Describe the advantages of...