Consider the database schema below. Fruit (ID: integer, Name: String (unique)) Vitamin (FruitID: Integer, VitaminName: String, VitaminPercentage (not null)) A Vitami can have unknown VitaminPercentage ? Yes. No, violates referential integrity constraint. No, violates domain constraints. No, violates entity Integrity constraint No, violates key constraint.

Consider the database schema below. Fruit (ID: integer, Name: String (unique)) Vitamin (FruitID: Integer, VitaminName: String, VitaminPercentage (not null)) A Vitami can have unknown VitaminPercentage ? Yes. No, violates referential integrity constraint. No, violates domain constraints. No, violates entity Integrity constraint No, violates key 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

Relations describe the intersection between two axes, x and y. For example, a table (tuple) found in a database contains columns (attributes) and rows (records or observations). Database and Geospatial Mapping Application developers rely on tables and cartesian coordinate systems to adhere to the rules of relational database theory so that integrity in the location is preserved. Tables should only contain records that relate to the columns found in that table and the data domain determines what records should be stored in a given table. Database administrators can check for integrity in relationships within and between tables using structured query language (SQL). What other computer-science or IT jobs rely on relations?
Create and upload a relational schema (using ERDPlus) for a database that covers the following rules: 1. Each student is advised by one faculty, and each faculty has many student advisees 2. Each faculty is affiliated with multiple departments, and a department have many faculty affiliates (note the change from class) 3. Each student is registered with many departments and each department has many registered students 4. Each department is chaired by one faculty, and any one faculty can chair only department 5. Each course is listed under one department 6. Each faculty can teach many course offerings, and each course offering can be taught by one faculty 7. Each student can take many course offerings, and each course offering will have many students
1):-In a dependant table, a__ key refrences the master table _ key a) foreign, primary b) primary, foreign c) artificial, primary d) primary, artificial 2):-When a table has no suitable _ key, the database designer speciiesa(n)__ a) primary, foreign b) foreign, primary c) primary, artificial d) artificial, primary 3):-Distinguish independant and dependent entities is a(n) __ process a) one time b) physical design c) iterative d) logical design 4):- In some ER modelling conventions, _ enities are called strong and __ entites are called weak. a) dependant, independent b) independent, dependent c) master, dependent d) dependent, master
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 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.
Consider the following relations for a simple airport databas Hangars (hangNo, capacity, location, status) AirplaneTypes (Model, capacity, weight) Airplanes (regNo, model, hangNO) Owners (owner, name, address, phone, ssn) Owns (regNo, ownID, startedDate) There are four foreign keys for this database: 1. The attribute hangNo of the relation Airplanes that references the relation Hangars, 2. The attribute model of the relation Airplanes that references the relation AirplaneTypes, 3. The attribute regNo of the relation Owns that references the relation Airplanes, and 4. The attribute ownID of the relation Owns that references the relation Owner. Q1: Write SQL statements to define the above relation Hangars. You should choose a suitable data type and/or daya size for each column and be sure to declare appropriate integrity constraint(s). Q2. Which of the following SQL statements is used to define the above relation Airplanes? Ensure the data type and size for each attribute are…
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.
Implement your table design by creating table statements. Your tables should have constraints such as primary keys and foreign keys. (You can use MySQL Workbench or any other database management system of your choosing). Types such as Char, Integer must be correctly placed. 2) Add one trigger to your database that utilizes a default function of your DBMS 3) Add dummy data to your database. (5 manual entries for each table should be sufficient.) 4) Consider the nominal forms and integrity of your database, it will affect your grade. Export your database from your DBMS, zip it and submit the zip file. Thank you!
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
Consider a database with the following three tables: RACES[RaceName, Year, Organizer, Country, Federation, Type, Distance] RaceName and Year form the primary key. Type is from { Run, Triathlon, Bike, MountainBike }. Distance is given in meters. RESULTS[RaceName, Year, Place, AthleteName] (RaceName, Year, Place) form the primary key. (RaceName, Year) form a foreign key referencing RACES. RECORDS[RaceName, Year, Record, Time] (RaceName, Year, Record) form the primary key. The foreign key is the same as for RESULTS. The values of Record could be, e.g., World Record, National Record, Fastest Time. Time is in seconds. Write queries in SQL that produce the answers to the following questions: (a) Find the names of all athletes who exclusively participate in runs that are longer than 40 kilometers. (b) Find organizers who organized a mountain-bike and a bike race, where the mountain-bike race was longer than the bike race. (c) Find the names of all athletes who achieved a world record in…
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