B2. Given the following relations (Teacher & Course), fill the table below by identifying theorigins of domain, entity and referential integrity violations.COURSEТЕАСНERTIDCreditsCCode(Number(4)) (Unique)2001TNameSalaryCNameTID(Number (4))1001(Number(1))1001 31005 31002 2Ali1000Database 1Programming 1Writing 1Programming 2 1004 31002ASIM900200210003SALIM80020031004FAHAD11002002ViolationConstraintDomain IntegrityUnique ConstraintEntity IntegrityReferential Integrity

The solution is provided below with clear explanation

B2. Given the following relations (Teacher & Course), fill the table below by identifying the origins of domain, entity and referential integrity violations. TEACHER COURSE TID (Number (4)) TName Salary CCode (Number(4)) (Unique) CName TID (Number(1)) 1001 3 Credits 1001 Ali 1000 2001 Database 1 Programming 1 Writing 1 Programming 2 1004 | 3 1002 ASIM 900 2002 1005 3 10003 SALIM 800 2003 1002 2 1004 FAHAD 1100 2002 Constraint Violation Domain Integrity Unique Constraint Entity Integrity Referential Integrity

B2. Given the following relations (Teacher & Course), fill the table below by identifying the origins of domain, entity and referential integrity violations. TEACHER COURSE TID (Number (4)) TName Salary CCode (Number(4)) (Unique) CName TID (Number(1)) 1001 3 Credits 1001 Ali 1000 2001 Database 1 Programming 1 Writing 1 Programming 2 1004 | 3 1002 ASIM 900 2002 1005 3 10003 SALIM 800 2003 1002 2 1004 FAHAD 1100 2002 Constraint Violation Domain Integrity Unique Constraint Entity Integrity Referential Integrity

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

Consider the following relations: Employee(E_id: integer, E_name: string, Age: integer, Salary: real) Works(E_id: integer, Dep_id: integer, Start_date: date) Department(Dep_id: integer, Dep_name: string, Budget: real, Manager_E_id: integer) What referential integrity constraints exist between these relations? What are the options for enforcing these constraints when a user attempts to delete a Dept tuple?
1. Consider the following relations:Student (snum: integer, sname: string, major: string, level: string, age: integer)Class (name: string, meets at: string, room: string, fid: integer)Enrolled (snum: integer, cname: string)Faculty (fid: integer, fname: string, deptid: integer)The meaning of these relations is straightforward; for example, Enrolled has onerecord per student-class pair such that the student is enrolled in the class. Level is atwo character code with 4 different values (example: Junior: A Level etc)Write the following queries in SQL. No duplicates should be printed in any of theanswers.i. Find the names of all Juniors (level = A Level) who are enrolled in a classtaught by Prof. Kwizeraii. ii. Find the names of all classes that either meet in room R128 or have five ormore Students enrolled.iii. Find the names of all students who are enrolled in two classes that meet atthe same time.
Given the following dependencies, convert the following schema to 3NF PatientNo, PrescriptionNo -> Name, DOB, Address, Drug, Date, Dosage, DoctorNo, Doctor_Specialist PatientNo -> Name, DOB, Address PrescriptionNo -> Drug, Date, Dosage, DoctorNo, Doctor_Specialist, PatientNo DoctorNo -> Doctor_Specialist
just answer true/false a]Disjointness means that every entity of a supertype must be an entity in one of the subtypes in the generalization hierarchy. b]Record is a set of more fields that describe a person, place or thing. c]Cardinality is the number of tuples in a relation. d]Referential integrity must have null values only.
Let us consider the following relational database. Students(stuID, lastName, firstName, major, gpa) Faculty(facID, name, deptName, rank) Classes(classNhmber, facID, schedule, room) Enrolls(stuID, classNumber, grade) The primary keys are underlined. The referential integrity constraints are as follows: The column facID of relation Classes that references table Faculty, The column of stuID of relation Enrolls that references table Students, and The column classNumber of relation Enrolls that references table Classes. The following SQL statement is intended to define the table Students. However, this statement does not work correctly. CREAT TABLE Students( lastName VARCHAR(20), firstName VARCHAR(20), major VARCHAR(40) gpa DECIMAL(3,2), PRIMARY KEY(stuID)); However, this statement does not work correctly. Briefly explain why and list the corrected SQL statement.
Consider a database schema with a relation Emp whose attributes are as shown below, with types specified for multivalued attributes. Emp = (ename, ChildrenSet multiset(Children), SkillSet multiset(Skills))Children = (name, birthday)Skills = (type, ExamSet setof(Exams))Exams = (year, city) Redesign the database above into first normal form and fourth normal form. List any functional and multivalued dependencies that you assume. Also list all referential-integrity constraints that should be present in the first and fourth normal form schemas.
Given the following relation(s) and the functional dependencies, what is the highest normal form the data model complies to? Note: Primary keys are indicated in bold. TaxiRide (jobID, jobDateTime, driverID, driverName, taxiID, clientID, clientName, jobPickUpAddress)jobID -> jobDateTime, driverID, driverName, taxiID, clientID, clientName, jobPickUpAddressjobDateTime, driverID -> jobID, driverName, taxiID, clientID, clientName, jobPickUpAddressjobDateTime, taxiID -> jobID, driverID, driverName, clientID, clientName, jobPickUpAddressjobDateTime, clientID -> jobID, driverID, driverName, taxiID, clientName, jobPickUpAddressdriverID -> driverName, taxiIDclientID -> clientName A)1NF B)2NF C)3NF
Consider the following relational schema for a library database: Book (Title, Author, Catalog_no, Publisher, Year, Price, bookCoverType, contractDate) Collection (Title, Author, Catalog_no) Assume {Author, Title} is the key for both relations Additional functional dependencies are Title,Author --> Catalog_no Catalog_no --> Publisher, Year, bookCoverType Publisher, bookCoverType --> Price Author --> contractDate a) Explain what normal form the relation is in. b) Apply normalization until the 3rd State reasons behind each normalization
Develop an EER model for the following situation using the traditional EER notation, the Visio notation, or the subtypes inside supertypes notation, as specified by your instructor: An international school of technology has hired you to create a database management system to assist in scheduling classes. After several interviews with the president, you have come up with the following list of entities, attributes, and initial business rules: • Room is identified by Building ID and Room No and also has a Capacity. A room can be either a lab or a classroom. If it is a classroom, it has an additional attribute called Board Type. • Media is identified by MType ID and has attributes of Media Type and Type Description. Note: Here we are tracking type of media (such as a VCR, projector, etc.), not the individual piece of equipment. Tracking of equipment is outside the scope of this project. • Computer is identified by CType ID and has attributes Computer Type, Type Description,…
Draw the relationships and entities model for each of the following: * in the traditional way* for example: see the pic??. In the database of the library, the author can author more than one book, and the book can be subscribed toWritten by more than one author
Let's break down the information into entities, attributes, and relationships: Entities: 1. Ship - ShipID (Primary Key) - ShipName - ShipType 2. Captain - CaptainID (Primary Key) - CaptainName - CaptainLicense 3. ShipmentTrip - TripID (Primary Key) - DeparturePort - ArrivalPort - RouteDetails 4. ShipmentManifest - ManifestID (Primary Key) - Date - GoodsList 5. Goods - GoodsID (Primary Key) - GoodsName - GoodsType (BM or LM) 6. Port - PortID (Primary Key) - Street - City - State - PostalCode - Country Relationships: - Ship to ShipmentTrip (Many-to-Many): - Ship can participate in multiple ShipmentTrips, and a ShipmentTrip can involve multiple Ships. Create a junction table `Ship_ShipmentTrip` with attributes `ShipID` and `TripID`. - Captain to ShipmentTrip (Many-to-Many): - A Captain can be assigned to multiple ShipmentTrips, and a ShipmentTrip can have multiple Captains. Create a junction table `Captain_ShipmentTrip` with attributes `CaptainID` and `TripID`. - Captain to Ship…
Given the following relational schema (Hint: the bold text represents a primary key), Professor(emp_num, emp_fname, emp_lname, emp_dob, dept_code, prof_ext)Class (class_code, course_code, class_section, class_time, class_room, emp_num)Course (course_code, course_name, crs_credits, dept_code) Write a relation algebra to find all "Database Design and Implementation" classes including section, time, room, and professor name (first name and last name). Hint: "Database Design and Implementation" is the course name