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

DATABASE SYSTEM A relation R is given which is R(A,B,C,D,E). It has the following functional dependencies: BC -> D, AC -> BE, B->E . Answer the following based on this information. What is the candidate key of this relation? Is it in 2NF? Explain why or why not.
Q3) consider you have the Library database with the following relations, where the primary keys are underlined: Book (bookID, name, auther, No.-of-pages, section-name, category) Section(section-name, section-admin, no-of-books, library-code) Library(library-name, address, no-of-sections, manager-name, library-code, country)
16 We would like to design a database to maintain information about COURSES in a Faculty. Each COURSE has a code, name number of credit hours and the department that offers it. A COURSE may have zero, one, or many prerequisite COURSES. A COURSE may be a prerequisite for zero, one, or many COURSES 2"What is the degree of the relationship type'prerequisite of a. A unary (recursive) relationship O b. A binary relationship cA ternary relationship O d. This relationship is NOT exist O
Practical Tasks for Database Systems Question:1 Show all data from employee table where name should be in ascending and salary in descending order. Question:2 Show the total length of (eno, deptno). joined it and rename by function from the employee table? Question:3 Show the ename first 3 alphabets of manager? Question:4 Write a query that show the manager data like this. ename job ***MANAGER *** MANAGER JONES BLAKE Question:5 Calculate the percentage of any student and round to 0 digit? Question:6 Show the last date of December 2014? Question:7 Show the date of next data base class and rename by cs-400? Question:8 Convert today date to character?
What are Inconsistent key structures?
Why are certain functional dependencies said to be trivial?
Here is the database design for the personnel data: employee(id, name, address) employeeMap(id, confidentialId) empSalary(confidentialId, salary) The role 'Clerk' would be granted SELECT, UPDATE, DELETE to employee table and granted SELECT to empSalary table. While the clerk can see salary information for any statistical analysis (e.g. average salary computation), he has no idea which employee the salary is for. The role 'Administrator' is granted rights on all three tables; using the confidentialId in the employeeMap table, she has access to salary data for individual employees too. A SQL query that the administrator can use to access all employee fields is: select e.id, e.name, e.address, es.salary from employee e inner join employeeMap m on e.id = m.id inner join empSalary s on m.confidentialId = s.confidentialId; Can you draw a database schema?
Produce the 3NF for the following: Scenario 1 This is a simple list table of a company trying to keep track of parts that they sell and orders that came in purchasing those parts (in other words, not a database but a flat one table file) You will design a database for this company so that they won't be relying on a simple 1 table list system to keep track of their data. Looking at the table below, produce the IN of the data OrderDate 10/20/2010 10/20/2010 10/20/2010 10/21/2010 10/21/2010 10/23/2010 10/21/2010 10/23/2010 10/23/2010 OrderNum 21608 PartNum AT94 DR93 NumOrdered 11 1 Description QuotedPrice $21.95 $495.00 $399.99 $329.95 S595 00 $794.95 $150.00 $495.00 00 0621S Iron 21610 Gas Range 21610 21613 DW11 Washer KL62 Dryer Dishwasher Home Gym Microwave Oven Gas Range Treadmill 21614 21617 ктоз 21617 CDS2 4. 21619 DR93 1. 21523 KV29
subject : database system Member (MemberID, Name, ContactNo, Status, Sex)Borrow (BorrowNo, MemberID, CatalogNo, CheckOut, Return, Fine)Book (CatalogNo, Title, Author, Publisher, Year, Category) Write the appropriate relational algebra to produce the following queries. List member ID for members that borrowed all the ‘database’ books (category).
Relation algebra (Database)
"The sole purpose for having relations is to record instances of functional dependencies," the author says in the passage. What does this imply, in your own words?
Read the scenario carefully You have to propose and optimal database design in RDBMS for a super store. In which clients came and can purchase products according to their likes and dislikes. Super store have same products of different companies. In the end client received a receipt of their purchase from counter he/she go for bill. Database also save records of stock according to FIFO system.Your required to define1) Entities and their attributes2) Attributes Types 3) Each Attribute Required space.4) Define keys of each entity 5) Defile relationship between the entities.