Q1) B) Consider you have library database, with the following relations: Book(bookID, name, auther, No.-of-pages, section-name, category) Section(section-name, section-admin, no-of-books, library-code, section-code) Library(library-name, address, phone-no., no-of-sections, manager-name, library-code) Answer the following: 1- specify the primary key(or keys) and the foreign key (or keys) in each relation. If a table does not have a foreign key, write None. 2- draw the schema diagram of the library database.

Q1) B) Consider you have library database, with the following relations: Book(bookID, name, auther, No.-of-pages, section-name, category) Section(section-name, section-admin, no-of-books, library-code, section-code) Library(library-name, address, phone-no., no-of-sections, manager-name, library-code) Answer the following: 1- specify the primary key(or keys) and the foreign key (or keys) in each relation. If a table does not have a foreign key, write None. 2- draw the schema diagram of the library database.

Database Systems: Design, Implementation, & Management

11th Edition

ISBN:9781285196145

Author:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel

Publisher:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel

Chapter10: Transaction Management And Concurrency Control

Section: Chapter Questions

Problem 1P

See similar textbooks

Similar questions

1. Consider the following relational schema. Item(Item-id, Item-name, price, Inventory level) Order-items (order-id, item-id, quantity, unit-price) •Suppose a warehouse wishes to maintain a minimum inventory of each item; write a stored procedure that will take an item-id and order-id as input parameter and checks the inventory level of that particular item. If the inventory level of that item is minimum(less than 10) in the item table then an order should be placed with quantity 100 for that item in order-item relation.
Assume the relation CITIZEN(ID, Tax-Code, Salary, Age) storing information about UK citizens’ tax codes and annual salaries. There are r = 60,000,000 records. Each attribute has the same size: 128 bytes. The relation is stored in a file sorted by the salary attribute. The block size B = 1024 bytes and any pointer in the system has size = 128 bytes. The salary attribute is assumed to be uniformly distributed across tuples. There are 6,000 distinct salary values and there are 10,000 different tax-code values. The tax-code and age are assumed to be statistically independent of salary. A data scientist, who has built a Secondary Index over the Tax Code (non- ordering, non-key attribute), is interested in the specific Tax Code: ‘1234L’. The data scientist did analyse the distribution of the Tax Code attribute and noted the following: • Let X be the number of citizens with Tax Code 1234L per data block. That is, given a random block, there are X citizens with Tax Code 1234L. Objective:…
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.
Investigate the concept of Functional Dependencies and how they relate to the normalization process.
62 Consider a bank database with snapshot isolation. Describe a situation in which a non-serializable execution causes an issue for the bank.
Create a relational database design for the following data model
1. What technique is used to model the situation that Student may have multiple addresses? A) Associative Entity (gerund)B) Weak entitiesC) Super/sub typesD) Recursive relationships 2.There is m:m relationship between students and classes. Which technique is used forrepresenting the student grade? A) Associative Entity (gerund)B) Weak entitiesC) Super/sub typesD) Recursive relationships 3. An associative Entity (gerund) may be used whenever there are data that depends on twoentities even when their relationship is 1:m. True or FalseA) TrueB) False 4. (check all that apply) When do you use recursive relationships?A) the relationship between employees and their supervisorsB) the relationship between employees and their dependentsC) the relationship between employees and their departmentsD) the relationship between employees and their team membersE) the relationship between employees and their job assignments 5. How is a gerund converted into a relational model?A) ignore the gerund in the…
Complete a database design for both the CD Database problem and the Warehouse Problem. Display your normalized tables as demonstrated in the following format: TABLENAME(Field 1 (pk), Field 2, Field 3........)
8.When constructing a database, the designer mustknow what types of relationships exist betweenrecords in different data sets, such as one-to-many or many-to-many. Give three examplesfor each of these relationships.
1b)By using a scenario, explain program-data dependence issue found in previous database technologies such as file-oriented database before relational database model was introduced.
5.6 LAB - Implement independent entity (Sakila) Implement a new independent entity phone in the Sakila database. Attributes and relationships are shown in the following diagram: The diagram uses Sakila naming conventions. Follow the Sakila conventions for your table and column names: All lower case Underscore separator between root and suffix Foreign keys have the same name as referenced primary key Write CREATE TABLE and ALTER TABLE statements that: Implement the entity as a new phone table. Implement the has relationships as foreign keys in the Sakila customer, staff, and store tables. Remove the existing phone column from the Sakila address table. Step 2 requires adding a foreign key constraint to an existing table. Ex: ALTER TABLE customer ADD FOREIGN KEY (phone_id) REFERENCES phone(phone_id) ON DELETE SET NULL ON UPDATE CASCADE; Specify data types as follows: phone_id, phone_number, and country_code have data type INT. phone_type has date type VARCHAR(12) and…
use c++ to answer the folloing two question 1. implement a city database using a BST to store the database records. Each database record contains the name of the city (a string of arbitrary length) and thecoordinates of the city expressed as integer x- and y-coordinates. The BST should be organized by city name. Your database should allow records to be inserted, deletedby name or coordinate, and searched by name or coordinate. Another operation that should be supported is to print all records within a given distance of a specifiedpoint. Use following two classes:struct city{/* add the city attributes and pointers to left and right child nodes*/}class CityDB{/* create a BST for a City Database here in this class */}Note: The distance formulais > \«: «-w »* , where x1y1 are coordinates of city 1 and x2, y2 are coordinates of city 2. 2.Create the same City Database that you created in the first question using Hash table. Add another attribute in the City record, that is, city_id. Use…

SEE MORE QUESTIONS

Recommended textbooks for you

Database Systems: Design, Implementation, & Manag…

Computer Science

ISBN:

9781285196145

Author:

Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel

Publisher:

Cengage Learning