Question 4 T4.1) Given the following information, for each one of the BOLD words (note there are 3 in each one),specify whether the word will be mapped into an entity, attribute, relationship, or value in thecorresponding database.Ia) The make of my Red vehicle is Chevy. Chevy is an Entity, make is the relationship, vehicle is theattributeb) Instructor Smithy teaches three courses.Teaches is the value, instructor is attribute, smithy is the entitiyWM.

Question 4 4.1) Given the following information, for each one of the BOLD words (note there are 3 in each one), specify whether the word will be mapped into an entity, attribute, relationship, or value in the corresponding database. a) The make of my Red vehicle is Chevy. Chevy is an Entity, make is the relationship, vehicle is the attribute b) Instructor Smithy teaches three courses. Teaches is the value, instructor is attribute, smithy is the entitiy

Question 4 4.1) Given the following information, for each one of the BOLD words (note there are 3 in each one), specify whether the word will be mapped into an entity, attribute, relationship, or value in the corresponding database. a) The make of my Red vehicle is Chevy. Chevy is an Entity, make is the relationship, vehicle is the attribute b) Instructor Smithy teaches three courses. Teaches is the value, instructor is attribute, smithy is the entitiy

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

entities: Residential students which fields like student id, Student name, exam papersTransfer students with fields like student id, transferred school, exam papers etc.Exam papers with fields like subjects, total marks, invigilator, checkers.Exam center with fields like Center Id, location, seating capacity etc. -Create an ER Diagram using the enumerated entities.
Consider the following database schema designed to store information about Books, and Chapters. Book (BookID, BookTitle, Price) BookChapter (ChapterID, BookID, ChapterTitle, NoPages) Write the following queries in SQL. 1. Display BookID of all books with price less than the average price of all books. 2. Display ChapterID, BookID, ChapterTitle of all chapters that include the word ‘Database’ in the ChapterTitle.
Design the memory mapping between the Cache memory of 64MB to the main memory of 4 GB using 8 way set associative method where the block or page or frame size is of 16KB. Consider each memory location is byte addressable. Write the number of bits required for memory address, tag address, block address and block location. In above memory mapping show the final Cache memory for block number 128 in the main memory which contains tag, block address and block location fields.
StayWell also rents out properties on a weekly basis to students attending summer school in the Seattle area. Design a database to meet the following requirements, using the shorthand representation and a diagram of your choice. For each student renter, list his or her number, first name, middle initial, last name, address, city, state, postal code, telephone number, and e-mail address. For each property, list the office number, property address, city, state, postal code, square footage, number of bedrooms, number of floors, maximum number of persons that can sleep in the unit, and the base weekly rate. For each rental agreement, list the renter number, first name, middle initial, last name, address, city, state, postal code, telephone number, start date of the rental, end date of the rental, and the weekly rental amount. The rental period is one or more weeks.
The database used for this question is a very simple one with the following schema: (Primary keys are bold, foreign keys are underlined) CUSTOMER (CustID, FirstName, LastName, City, Phone, Email) INVOICE (InvoiceNumber, CustID, Date) INVOICE_ITEM(InvoiceNumber, ItemNumber, Quantity) ITEM (ItemNumber, ItemName, UnitPrice) When a customer makes a purchase, an invoice is created. The invoice may be for many items. For example, in a single purchase, a customer might buy 10 Back Scratchers, 4 Hair Removers and a Dog Lead. Provide relational algebra (NOT SQL) queries to find the following information. NOTE: You can use the symbols s, P, etc., or the words’ PROJECT’, ‘RESTRICT’ etc. as you prefer. You do not need to try to make efficient queries – just correct ones. Where you use a join, always show the join condition. List the dates on which Homer Griffin made purchases. List the first and last names of customers who have bought “Back Scratcher” or “Hair Remover” List the first…
SQL Queries: Given the following schema. Primary keys are underlined and highlighted in yellow and foreign keys are bold. The meaning of the relations is straightforward. Medical_Staff(MS_Id, MS_First, MS_Last, MS_PhoneNumber, MS_Occupation, Salary) Blood_Bank(Bank_Id, Bank_Name, Bank_Street, Bank_City, Bank_St, Bank_PhoneNumber) Donor(Donor_Id, Donor_First, Donor_Last, Donor_BloodType, Donor_City, Donor_St, DOB, TotalNumberOfDonations) Donation_Record(Donor_Id, Donation_Date, Donation_Amount) Employee(MS_Id, Bank_Id) Storage(Donor_Id, Donation_Date, Bank_Id) Write SQL queries to answer the following questions: a.Find the average donation amount for Sue Thompson (Donor Id = 3329) for the year 2018. b.Sum all donations by Bank for each State (i.e. the State the blood bank is located in, not the Donor). c.Find the name of the youngest donor and all the donations made in by that donor in 2020.
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…
Q: 2. Create the database name Company which consists of one Entity name Employee which consists of 10 attributes (ID/First Name/Last Name/CNIC/Gender/Department/Sal ary/Address/Age) ID should be primary key Insert at least 10 records in the Entity Employee with respect to their type. a) Implementation the example of stored procedure now creates the stored procedure which: a. Have an ability to insert the record in the table. b. Have an ability to delete the record in table. c. Have an ability to update the record in the table. d. Have an ability to display the record in the table. |
Don't copy again and again that is wrong. Please help me with this question.
Given the following WORKER schema in which id is the primary key. WORKER (id, name, rank, salary, bonus) Create a stored procedure named PRO_DELETE_WKR to delete a row of employee given the employee id. The employee id is a number.
You have an application domain that consists of Cities, Towns, and Neighborhoods. A City has a name, zip code, state, and a country. A Town has a name, zip code, state, and country. A Neighborhood has a name, coordinate, and population. Using a relational model, what are Students, Courses, and Sections called? Select one: a. Attributes b. Constraints c. Entities d. Relations
Final Exam 15 - Consider the following Entitiy Relationship diagram. Which of the following relation will not hold if the above ER diagram is mapped into a relational model? I) Product (Productld, Desciption) II) Requests (Productld, Orderld) II) Order (Orderld, Productid, Date) IV) Order (Orderld, Date) ProductID Description Orderld Date M N Product Requests Order a) O IV II II Leave blank Close