2) Given the following conceptual schemas, address the questions. Students(sid: string, name: string, login: string, age: integer, GPA: real) Faculty(fid: string, fname: string, sal: real) Courses( cid: string, cname: string, credits: integer) Rooms(rno: integer, address: string, capacity: integer) Enrolled (sid: string, cid: string, grade: string) Teaches(fid: string, cid: string) Meets_In( cid: string, rno: integer, time: string)

2) Given the following conceptual schemas, address the questions. Students(sid: string, name: string, login: string, age: integer, GPA: real) Faculty(fid: string, fname: string, sal: real) Courses( cid: string, cname: string, credits: integer) Rooms(rno: integer, address: string, capacity: integer) Enrolled (sid: string, cid: string, grade: string) Teaches(fid: string, cid: string) Meets_In( cid: string, rno: integer, time: string)

Principles of Information Systems (MindTap Course List)

12th Edition

ISBN:9781285867168

Author:Ralph Stair, George Reynolds

Publisher:Ralph Stair, George Reynolds

Chapter5: Database Systems And Applications

Section: Chapter Questions

Problem 4PSE: Using a graphics program, develop an entity-relationship diagram for a database application for an...

See similar textbooks

Similar questions

1. Define Computer Science in: Informal Definition:Formal Definition:Extended Definition: 2. Define Software in: Informal Definition:Formal Definition:Extended Definition: 3. Define Database in: Informal Definition:Formal Definition:Extended Definition: ps. 1-3 sentences is great as long as you define it categorically correct
Introduction to database systems Question: Create an ER diagram relational schema and queries of a charity donation application that has classes as follows: Donor(name, address, mobile number, email) with subclasses: DonateMoney(name, amount, card number,security code) and DonateOther(item, name, address, mobile number, email), Volunteer(name, address, mobile number, email) and Organization(name, address, mobile number, email). The description of the application is as follows: the user can either donate money or donate other such as food, clothes,books, etc where he/she will have to first select the organization he/she is willing to donate to and then fill in the required information. The user could also volunteer by selecting what organization he/she wants to volunteer to and filling in the required information.
Therefore, why isn't an object's presence in a data model required?
The following are the objectives for the design of the logical schema:
Consider the UML Diagram shown in the Image. Follow the instruction of the instructor to answer the question. University College 1. -name:string -dean:string -name:string -address:string -website:string -tel:int -tel:int -email:string -programs:string0 -email:string +addColleges(College coll): void +addProgram(string program): void 1..n Building -id:int -name:string -location:string
B. Art Museum Database Draw an EER diagram to keep track of information for an art museum. Assume that the following requirements were collected: (10 marks) The museum has a collection of art objects. Each art object has a unique ID, a year (when it was created, if known), a title, and a description. Art objects must be categorized based on their type. There are three main types: painting, sculpture, plus another type called other to accommodate objects that do not fall into one of the two main types. A painting has a paint type (oil, watercolor, etc.), material on which it is drawn on (paper, canvas, wood, etc.), and style (modern, abstract, etc.). A sculpture has a material from which it was created (wood, stone, etc.), height, weight, and style. An art object in the other category has a type (print, photo, etc.) And style. The museum keeps track of artist information, if known: name, date born (if known), date died (if not living), country of origin, epoch, main style, and…
Which data model has the highest level of abstraction? O a. Relational O b. Object-oriented O c. Entity relationship O d. Hierarchical
What distinguishes a variable reference model from a variable value model? Why is it important to distinguish between them?
1. All of the following are described by data models tools, except: b. Data queries d. Data semantics a. Data constraints c. Data relationships
Describe differences between is-a relationship and has-a relationship with examples.
Consider the following ER diagram of a Bank: BANK Code Name Addr Phone BRANCHES ACCTS Acct_no Ssn N ACCOUNT M A_C N Balance N Name CUSTOMER Type BANK_BRANCH Addr Addr LOANS Loan_no N LOAN N M L_C Branch_no ------- Amount Type each ACCOUNT's TRANSACTIONS (deposits, withdrawals, checks, ...) and each LOAN'S PAYMENTS; both of these include the amount, date, and time. Modify the BANK schema, using ER and EER concepts of specialization and generalization. State any assumptions you make about the additional requirements. b) Map the BANK EER schema into a relational schema. Specify all primary keys and foreign keys.
Design an EER diagram for a library as described below. Show relevant constraints. a. Each employee has an SSN, fname, lname, and address. b. An employee is classified into one of three categories: managerial, research, and floor. Floor employees are paid by the hour and have an hourly wage rate. The other two categories have a salary. Research workers have a specialty, while managerial workers have a job title. c. Customers are identified by their card number, and also have a fname, lname, and address. d. Each book is identified by its LCN (Library of Congress Number). It has a title, and one or more authors. e. An author has as a key an author code, since fname, lname does not suffice. We also keep track of their birth date and date of death. f. Customers may check out books. We keep track of the date it was checked out, as well as the date of return if it has been returned. g. Each time a book is checked out, we want to track which employee was involved in that transaction.…