A university needs to design a database. Below are the list of entities, attributes, and business rules. - Room is identified by Room No and also has Capacity. A room can be either a lab or a classroom, nothing else. - Computer identified by Computer No and has attributes ComputerType, Description and ProcessorSpeed. - A Media is identified by Media No and has attributes of Type and Description. - A room cannot be both classroom and a lab. There also no other room types to be incorporated into the system. - A lab has one or more computer. However, a classroom does not have any computers and it contains different type of board need to be saved. - A room can be provided with one type of media, several types of media, or no media. A media does not belong to a room, they are borrowed and returned.

A university needs to design a database. Below are the list of entities, attributes, and business rules. - Room is identified by Room No and also has Capacity. A room can be either a lab or a classroom, nothing else. - Computer identified by Computer No and has attributes ComputerType, Description and ProcessorSpeed. - A Media is identified by Media No and has attributes of Type and Description. - A room cannot be both classroom and a lab. There also no other room types to be incorporated into the system. - A lab has one or more computer. However, a classroom does not have any computers and it contains different type of board need to be saved. - A room can be provided with one type of media, several types of media, or no media. A media does not belong to a room, they are borrowed and returned.

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

Create an ERD Diagram with all the relationships based of this: The city of California has just established its criminal justice/police department. You and your team have been assigned the task of creating a database system for the department. The database should be able to store and manage information about the department's workers, their roles, medical records, and incidents that occurred under the department's jurisdiction. This includes information about the investigator(s), the offender(s), the evidence, and the judicial proceedings, such as the trial details, the presiding judge, and the lawyers. The database should also be able to support the recording of punishments, such as sentencing time, fines, and warnings.
It is requested to draw an entity relationship diagram (ERD) for a hospital management system. Information about the subject are given below. • The patients contain ID, name, and surname. Doctors have name, surname, and department. Rooms have number and capacity. • Each doctor may supervise zero or more patients. • Each patient should be supervised by one doctor. • Each room may host zero or more patients. Each patient should be hosted in one room.
Question=1)DRAW : Matrix diagram of this entities project will be about a student attendance. Entities: student, course, instructor, attendance, enrollment, department, class. Relationships: Student is enrolled in course, Course has instructor, Department has many courses, Entities: 1. Student - Attributes: Student_ID (Primary Key), Name, Age, Email, Phone _Number 2. Course - Attributes: Course_ID (Primary Key), Course_Name, Department_ID (Foreign Key) 3. Instructor - Attributes: Instructor_ID (Primary Key), Name, Department_ID (Foreign Key) 4. Attendance - Attributes: Attendance _ID (Primary Key), Student_ID (Foreign Key), Course_ID (Foreign Key), Date, Status 5. Enrollment - Attributes: Enrollment_ID (Primary Key), Student_ID (Foreign Key), Course_ID (Foreign Key), Enrollment Date 6. Department - Attributes: Department_ID (Primary Key), Department_Name 7. Class - Attributes: Class_ID (Primary Key), Class_Name, Department_ID (Foreign Key) Draw Matrix diagram of this scaniorio
1. Create an EER diagram to keep track of information for an art museum given that the following criteria is met: The museum has a collection of art objects. Each art object has a unique identification, an artist (if known), a year (when it was created, if known), a title, an epoch (Renaissance, Modern, Ancient, etc.), and a description. The arts objects are classified in the museum in several ways as discussed below: Arts objects are categorized based on their type. The main types are: painting and sculpture, plus another type they 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 draw on (paper, canvas, wood, etc.), and style (modern, abstract, impressionism, etc.). A sculpture has a material from which it was created (wood, stone, iron, etc.), height, weight, and style. An art object in the other category has a type (print, photo, etc.) and a style. Art objects…
Match the term with its description by placing the letter of the definition in the space preceding the term. ✓ Attribute ✓ Entity ✓ Entity set ✓ One-to-many relationship ✓ Overlap constraint A. A property or description of an entity B. An association among two or more entities C. A collection of unique tuples D. An object in the real world that is distinguishable from other obje E. One entity can be associated with many of another entity F. Two or more subclasses can contain the same entity. G. A set of possible values for an attribute H.A collection of similar entities
Consider two sets of entities A and B, each of which has the property X (among other qualities whose names are irrelevant to this discussion) among other attributes. Can the design be improved if the two Xs are not connected?
Change the Class Diagram to have (Generalization, Aggregation, Composition, Association and multiplicity) relations.
Computer science Describe the following class stereotypes, and explain why it is necessary to distinguish among them. Boundary classes, control classes and entity classes?
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.…
Construct an E-R diagram for the following hospital: In this hospital, we have many patients (characterized by social security number, name, insurance, the admission date, and the date of check out) received by medical doctor. Each medical doctor in the hospital is characterized by: ID number, name, and specialization. For every patient, the medical doctor will perform one or more tests and examinations to diagnose his illness. Each test or examination is characterized by an ID, name, date, time, and result. In your ER-Diagram, you must specify the key for each entity and all relationship cardinalities.
Consider two sets of entities A and B, each of which include the property X (among other names that are not important to this discussion) among other attributes. Is it possible to enhance the design if the two Xs are not connected?