Map the relational schema of Figure 6.14 into an ER schema. This is part of a process knownas reverse engineering, where a conceptual schema is created for an existing implementeddatabase. State any assumptions you make.ВOOKBook id TitlePublisher_nameBOOK AUTHORSBook id Author_namePUBLISHERNameAddressPhoneвоOK COPIESBook id Branch_id No of_copiesBOOK LOANSBook_id Branch_idCard noDate_out Due_dateLIBRARY_BRANCHBranch_id Branch_name AddressBORROWERCard no NameFigure 6.14A relational databaseAddressPhoneschema for a LIBRARYdatabase.

Map the relational schema of Figure 6.14 into an ER schema. This is part of a process known as reverse engineering, where a conceptual schema is created for an existing implemented database. State any assumptions you make.

Map the relational schema of Figure 6.14 into an ER schema. This is part of a process known as reverse engineering, where a conceptual schema is created for an existing implemented database. State any assumptions you make.

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Similar questions

Do any data structure components need to be identified at the database layer level?
Consider a database containing personnel information, including names, addresses, and salaries of employees. Individually, the name, address, and salary information are available to a subordinate role, such as Clerk, but the association of names and salaries is restricted to a superior role, such as Administrator.1. With this information, how could you construct your database and tables? Design your database and draw a database schema first.2. Suppose that administrators want to add a new attribute, employee start date, which is not sensitive. Where would it be? Consider not compromising the relationship between employee and salary. Draw your new schema. Can you make submissions using with word processors (MS Word, LibreOffice etc....).
Create a relational database schema from the ERD in 3.1 showing all tables in 3NF. Each table should include at least three fields. Appropriate primary keys should be used. Primary keys must be underlined and, each foreign key should have the letters FK in brackets after it, for instance, xyz (FK).
Another action may be triggered by the execution of a trigger. There is often a limit on how deep nesting may go in database systems. Why could they impose such a restriction?
Consider the following business rule:An employee can manage multiple customers. A customer can be managed by multiple employees. How does this business rule(s) affect the database design? a.) The business rules define that there isn't a need for a relationship between the EMPLOYEE and CUSTOMER entities, as the relationship isn't a strong one. b.) The business rules define that there is a relationship between EMPLOYEE and CUSTOMER, and a 1:M relationship between those two entities. c.) The business rules define that there is a relationship between EMPLOYEE and CUSTOMER, and an M:N relationship between those two entities requiring a bridge table. d.) The business rules define that there is a relationship between EMPLOYEE and CUSTOMER, and a 1:1 relationship between those two entities.
Give each of the following methods for storing a relational database two advantages, two disadvantages, and a summary of how they affect the database as a whole. A separate file should be kept for each relationship.
Consider the following database scheme Employee (SSN, fname, lname, salary, deptno) Department (deptno, dname, total_salary) Where total salary is a derived attribute that represents the total salary of employees working in a specific department. Write a trigger to compute the total_salary in the event of inserting one or more new employee record(s) in the employee table.
What happens if a database has two sets of identical data? What do you suppose the reason is?
write queries in relational algebra
Consider the term "snapshot isolation" as an example for a database used by an airline. Is the selection of a strategy that does not lend itself to serialization suitable in the event that airlines are able to improve their overall performance?
Suppose a database system is without concurrency control. Describe an example that the concurrency of multiple transactions results in inconsistency in the database. You can take the banking system, ticket booking system or any other database system for example. Please explain the outer-schema, schema, inner-schema structure of database system.
With the following Object Oriented Relational Database schema, select the attributes that a tuple in Teachers would have. create type Person (ID varchar(20) primary key, name varchar(20), address varchar(20)) ref from(ID); create table people of Person; create table students ( degree varchar (20)) inherits people ;create table teachers ( salary integer ) inherits people ; a. id b. salary c. degree d. name