QUESTION 2 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 customer with unknown CPR? O No, violates entity Integrity constraint. Yes. No, violates key constraint. No, violates domain constraints. No, violates referential integrity constraint.

QUESTION 2 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 customer with unknown CPR? O No, violates entity Integrity constraint. Yes. No, violates key constraint. No, violates domain constraints. No, violates referential integrity constraint.

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

DATABSE
QUESTION 6 Consider the database schema below. Fruit (ID: integer, Name: String (unique)) Vitamin (FruitID: Integer, VitaminName: String, VitaminPercentage) A Fruit have unknown ID? O Yes. No, violates referential integrity constraint. No, violates entity Integrity constraint No, violates domain constraints. No, violates key constraint.
QUESTION 5 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 two different books (with different ID) to have the same title? No, violates referential integrity constraint. Yes. No, violates domain constraints. No, violates entity Integrity constraint. No, violates key constraint. O O
QUESTION 2 Consider the database schema below. Fruit (ID: integer, Name: String (unique)) Vitamin (FruitID: Integer, VitaminName: String, VitaminPercentage) Different values VitaminPercentage can be used in two records for the same (FruitID, VitaminName ). Yes. No, violates key constraint. No, violates referential integrity constraint. No, violates entity Integrity constraint No, violates domain constraints.
Hints: 4:14 1 ● Option 2 1. Specify all the relationships among the records of the database shown below. Assignment Details COP5725 RVC 1231 • A relationship, in the context of databases, is defined as a situation that exists between two tables. COURSE Cary mat ● Example 1: STUDENTS take SECTIONS Example 2: SECTIONS are of specific COURSES STUDENT Name Student_number Class Smith 17 1 Brown 2 SECTION 8 Course_name Intro to Computer Science Data Structures Discrete Mathematics Database GRADE_REPORT Student_number 17 17 N Section_identifier Course_number 85 MATH2410 92 CS1310 102 CS3320 112 MATH2410 119 CS1310 135 CS3380 Major CS CS Course_number Credit_hours Department CS1310 4 CS CS3320 4 CS MATH2410 MATH CS3380 CS Section_identifier 112 119 Semester Year Fall 07 Fall 07 08 08 08 08 Spring Fall Fall Fall . . .... ..... Grade B C 3 3 Submit Assignment Module 1 | Introduction to DBMS | 1 week Instructor King Anderson Knuth Chang Anderson Stone >
QUESTION 15 Consider the database schema below for cities in countries. A country have many cities, and the same city name can be found in different countries. Country (ID: integer, Name: String (unique) City (serialNo: integer (unique, not null), CountrylD: Integer, CityName: String, Population: integer) A city can have unknown serialNo? O Yes. No, violates domain constraints. O No, violates key constraint. O No, violates referential integrity constraint.
Swing Jazz Club ERD Problem Follow the Simple Procedure for ERD diagramming to design an ERD using the following user provided information. Remember the ERD will eventually turn into the design for a database from a top down view. Make sure you resolve any many to many conflicts. Label an identifier or primary key and all pertinent attributes given. If an attribute is not readily apparent from the user information, then make one up that makes sense for the particular entity. Therefore, all entities should end up with at least an identifier and another attribute that makes sense. You may use any of the approaches shown by the book, though the ER-Model and Crow’s foot are the most common. Make sure you show entities, relationships, cardinality, and optionality. Swing Jazz Club The Swing Jazz Club teaches swing and jazz dancing and offers both private and group lessons. Swing Jazz charges $60 dollars per hour for a private lesson and $10 dollars per hour for a group lesson.…
QUESTION 6 Consider the database schema below: Company (CompnayID: integer, CompnayName: String (unique), address) Department (DepartmentID: Integer, DepartmentName: String, CompanyID: Integer) Employee (ID:integer; name:String, DepartmentID:intger (not null)) Is it valid in the employee relation to have the same value of DepartmentID for three different Employees? No, violates Entity Integrity constraint No, violates referential integrity constraint. No, violates Key constraint. Yes. No, violated Domain Constraints
Giving the following schema for a supermarket database, specify the domain constrains for each attribute. CUSTOMERS (CustomerID , First_Name, Last_Name) EMPLOYEES (EmployeeID, Name, Email, PhoneNo) INVOICES( InvoiceID, Amount_Paid, Invoice_Date)
In the realm of database management, three distinct categories of relationships can be identified: identifying relationships, non-identifying relationships, and generic relationships?
QUESTION 4 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) In Borrowing-Record, there are three primary keys? O True False