Consider the following database schema for a library. Book (BookID:int, BookTitle:string(unique), Author:string, publisher:string) Borrowing-Record (BookID: int, CustomerCPR: int, Date: date, Time: time, Price: double) Customer (CPR:int, name: String) Is it possible to have a CPR with more than 9 digits? No, violates referential integrity constraint. Yes. No, violates domain constraints. No, violates key constraint. O No, violates entity Integrity constraint

Consider the following database schema for a library. Book (BookID:int, BookTitle:string(unique), Author:string, publisher:string) Borrowing-Record (BookID: int, CustomerCPR: int, Date: date, Time: time, Price: double) Customer (CPR:int, name: String) Is it possible to have a CPR with more than 9 digits? No, violates referential integrity constraint. Yes. No, violates domain constraints. No, violates key constraint. O No, violates entity Integrity constraint

A Guide to SQL

9th Edition

ISBN:9781111527273

Author:Philip J. Pratt

Publisher:Philip J. Pratt

Chapter2: Database Design Fundamentals

Section: Chapter Questions

Problem 11RQ

See similar textbooks

Similar questions

branch(branchhame, branch+citysassets} customer (HD, Customer name, customer street, customer city) loan loan number branch_name, amounty borrower(ID; loan_number account (account_number, branch name, balance)e depositor (HDs account number)- Figure le Consider the bank database in Figure 1, where the primary keys are underlined. Each branch might have many loans or accounts, associated with borrowers or depositors, respectively. Construct the following SQL queries for this relational database. 1. Find the name of each branch that has at least one customer who has an account in the bank and who lives in the "Harrison" city. Make sure each branch name only appears once. 2. Find the ID of each customer who lives on the same street and in the same city as customer "12345". (1) Please use "tuple variables". e (2) Please use "derived relations" or “with". 3. Find the ID of each customer of the bank who has an account but not a loan. 4. Find the total sum of all loan amounts for each branch…
True or false: The database management system can protect you in a number of ways from getting invalidated into the database in the first place through a series of rules called "referential constraints". Sometimes they are implemented through a new related data table.
MySQL Workbench 1. Normalization Concepts: Normalization is a process used in relational database design tominimize data redundancy and improve data integrity. It involves organizing the columns andtables in a database to ensure that each table contains only related data and follows specificrules. The most common normal forms are:• First Normal Form (1NF): Each table cell should contain a single value, and there should be norepeating groups.• Second Normal Form (2NF): All non-key attributes should be fully dependent on the primarykey.• Third Normal Form (3NF): All non-key attributes should be non-transitively dependent on theprimary key.2. Stored Procedures Concepts: A stored procedure is a precompiled set of SQL statements storedin a database. They can be called by applications, other stored procedures, or triggers toperform specific tasks. Some benefits of stored procedures include:• Code reusability• Improved security• Better performance• Centralized control and easier maintenance3.…
MySQL Workbench 1. Normalization Concepts: Normalization is a process used in relational database design tominimize data redundancy and improve data integrity. It involves organizing the columns andtables in a database to ensure that each table contains only related data and follows specificrules. The most common normal forms are:• First Normal Form (1NF): Each table cell should contain a single value, and there should be norepeating groups.• Second Normal Form (2NF): All non-key attributes should be fully dependent on the primarykey.• Third Normal Form (3NF): All non-key attributes should be non-transitively dependent on theprimary key.2. Stored Procedures Concepts: A stored procedure is a precompiled set of SQL statements storedin a database. They can be called by applications, other stored procedures, or triggers toperform specific tasks. Some benefits of stored procedures include:• Code reusability• Improved security• Better performance• Centralized control and easier maintenance3.…
Database Schema The schema for the Ch07_FACT database is shown below and should be used to answer the next several problems. Click this image to view it in its own tab. FIGURE P7.56 THE CH07_FACT ERD CHECKOUT PATRON PK Check Num PK Pat ID FK1 Book_Num FK2 Pat_ID Check_Out_Date Check_Due_Date Check_In_Date >0-----H- Pat_FName Pat LName Pat_Type BOOK AUTHOR PK Book_Num PK Au ID Book_Title Book_Year Book_Cost Book_Subject FK1 Pat_ID Au_FName Au_LName Au_BirthYear WRITES PK,FK1 Book Num PK,FK2 Au ID The CIS Department at Tiny College maintains the Free Access to Current Technology (FACT) library of e-books. FACT is a collection of current technology e-books for use by faculty and students. Agreements with the publishers allow patrons to electronically check out a book,
FUNDAMENTAL DATABASE SUBJECT: Case: A car wash owner wants to monitor the inventory of products and sales of the business. Create a database design in preparation for a system development that would: Store and monitor the supply of products; The number of vehicle washed by a car wash boy. Vehicles can be classified according to its type (motorcycle, van, bus, etc.). The list of vehicles washed by a car wash boy can be monitored. Salary per employee and the vehicles washed can be retrieved. Car wash history per vehicle can be check also. We already Identified the possible tables, so your task will be: 1. Add data on the tables (assume that this is not normalized yet) 2. reflect on the table and follow the normalization steps base on the rules. 3. normalize its table 4. add all table in one document (lucidchart/google docs), should have relationships and cardinality. 5. make sure that it is in highest normal form, highest will be BCNF (if needed).
database ERD question
DATABASE SYSTEMS: QUESTION: A local businesswoman has decided to start her own Internet business, called Masterpieces Ltd, hiring paintings to private individuals and commercial companies. Because of your reputation as a database designer she has called upon your services to design and implement a database to support her new business. At the initial planning meeting, to discuss the design, the following user requirements were requested. The system must be able to manage the details of customers, paintings and those paintings currently on hire to customers. Customers are categorized as B (bronze), S (silver), G (gold) or P (platinum). These categories entitle a customer to a discount of 0%, 5%, 10% or 15% respectively. Customers often request paintings by a particular artist or theme (e.g. animal, landscape, seascape, naval, still‐life, etc). Over time a customer may hire the same painting more than once. Each painting is allocated a customer monthly rental price defined by the owner.…
Text answer only
Database Management A relation R is given which is R(A,B,C,D,E,F). It has the following functional dependencies: AB -> CDE, B -> F. Answer the following based on this information. Is it in 3NF? If not, decompose it until 3NF.
struct student { char name[20]; char studentID[10]; char phonenum [9]; char advisor [20]; float gpa; } Operations needed: addnewStudent { purpose: to create a new student in the database input: name, studentID.phonenum,advisor.gpa output: none } Name another operation besides add that we could use for our student data structure.
A) The following relations kind a part of a on-line database (the relations area unit self- explanatory): CUSTOMER/CLIENT/SHOPPERS/BUYERS(Cust#, CAddress, Ctown, Balance, Cname) ORDER(Order.# Date, Cust#.) ORDERLINE(Order#, Part#, Amount-Ordered) PART(Part#., Desc, Stock, Item-Class, Unit -Price) a. Design a physical ER for the above scenario. b. With respect to this relative schema, write SQL statements for the subsequent queries: 1. List the name of the client United Nations agency has placed Order 123 (i.e. Order: = 123). 2. List the names of shoppers United Nations agency in Cardiff and have ordered half 456 (i.e. Part. 456). 3. List the order numbers (Order) for orders that contain a minimum of three elements and also the quantity ordered are minimum of ten. 4. List the outline (Desc), of these elements that the typical quantity ordered is bigger than the number ordered for half .6 (Part. = 456) so as 123.(Order..123).