Q2. ER Model Develop an ERD for the following case:A school of technology has hired you to create a database to assist in scheduling classes. Afterseveral interviews with the users, you have come up with the following data requirements andbusiness rules. Based on them, create an ER Model for the school's database.BUILDING has many rooms. Each room is located in a building. The attributes for BUILDINGare BuildingNo. BuildingName and Location. ROOM is always identified in association withBUILDING (BuildingNo). The attributes for ROOM include RoomNo and Capacity. There aretwo types of room. A room can be either LAB or CLASSROOM. If it is a lab, it has anadditional attribute called LabHours. If it is a classroom, it has an additional attribute calledZoomEnabled?.COURSE has identifier CourselD and has attributes CourseDescriptions and Credits. A coursemay (or may not) have more than one section. Each section is always identified in associationwith COURSE (CourseID). SECTION has attributes SectionNo and EnrollmentLimit,INSTRUCTOR has identifier EmpID and has attributes FirstName, LastName, Rank, and OfficePhone. Each instructor teaches more than one sections. Each section is taught by one instructor.TIMESLOT has identifier TSIS and has attributes Dayof Week, ŞtartTime and EndTime. Aninstructor is assigned to more than one time slot (i.e., many) Each time slot is assigned more thanone instructor (i.e., many). Scheduling data for each instructor are kept for each semester.After some further discussions, you have come up with additional business rules.A classroom is scheduled for one time slot at any given time. However, each time slotinvolves more than one classroom.A course may (or may not) have more than one (i.e., many) prerequisites.

Answered: Image /qna-images/answer/02c0b6e1-298a-4f69-9b66-f4f481e80e7b.jpg

several interviews with the users, you have come up with the following data requirements an business rules. Based on them, create an ER Model for the school's database. BUILDING has many rooms. Each room is located in a building. The attributes for BUILDI are BuildingNo. BuildingName and Location. ROOM is always identified in association wit BUILDING (BuildingNo). The attributes for ROOM include RoomNo and Capacity. There two types of room. A room can be either LAB or CLASSROOM. If it is a lab, it has an additional attribute called LabHours. If it is a classroom, it has an additional attribute called ZoomEnabled?. COURSE has identifier ÇourselD and has attributes CourseDescriptions and Credits. A cour may (or may not) have more than one section. Each section is always identified in associatio with COURSE (CourselD). SECTION has attributes ŞectionNo and EnrollmentLimit, INSTRUCTOR has identifier EmpID and has attributes FirstName, LastName, Rank, and O Phone. Each instructor teaches more than one sections. Each section is taught by one instruc

several interviews with the users, you have come up with the following data requirements an business rules. Based on them, create an ER Model for the school's database. BUILDING has many rooms. Each room is located in a building. The attributes for BUILDI are BuildingNo. BuildingName and Location. ROOM is always identified in association wit BUILDING (BuildingNo). The attributes for ROOM include RoomNo and Capacity. There two types of room. A room can be either LAB or CLASSROOM. If it is a lab, it has an additional attribute called LabHours. If it is a classroom, it has an additional attribute called ZoomEnabled?. COURSE has identifier ÇourselD and has attributes CourseDescriptions and Credits. A cour may (or may not) have more than one section. Each section is always identified in associatio with COURSE (CourselD). SECTION has attributes ŞectionNo and EnrollmentLimit, INSTRUCTOR has identifier EmpID and has attributes FirstName, LastName, Rank, and O Phone. Each instructor teaches more than one sections. Each section is taught by one instruc

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

P2
Assignment Brief: Some of the most difficult decisions that you face as a database developer are what tables to create and what columns to place in each table, as well as how to relate the tables that you create. Normalization is the process of applying a series of rules to ensure that your database achieves optimal structure. Normal forms are a progression of these rules. Each successive normal form achieves a better database design than the previous form did. Based on your understanding for the various normal form respond to the following problems and provide the optimal answer/solution. Problem#1: 1st Normal Form (1NF) Consider the Students table, with the primary key underlined, and the following data: Students: Alpha 100111 Email doe@usna.edu Name Courses GradePoints NN204, SI204, IT221 SM223, EE301 SI204 John Doe 2,3,3 Matt Smith 092244 113221 smith@usna.edu black@usna.edu 4,4 Melinda 3 Black NN204, SI204, IT221 090112 Tom Johnson Johnson@usna.ed 4,2,3 u a) Is the Students table…
Task 1: ER diagram for give scenario Consider building a database for a shopping mall with requirements as follows:  Each product of the shopping mall has a unique project No, and also has a name, a supplier name, a category, a purchase price and a selling price.  Products need to be supplied from suppliers. Each product has one supplier, but a supplier may supply many products for the shopping mall.  Each supplier has a supplier name and address.  A purchase order for product from a supplier has a unique order No, and a date. The order specifies one or more products and their quantities required for a product.  A sales order for product to customers has a unique order No, and a date. The order specifies one or more products and their quantities required for a product  The shopping mall has warehouses. Each warehouse has a warehouse number, an address and a contact phone number. Each warehouse has shelves to store products. Each shelf has a shelf-number and a capacity. The shelf…
Question Description of the project A city college would like to maintain their academic information in a MySql database system. The following are the interested information: Courses: Catalog # (M 170 for instance) Credit Hours; Name of the Course (Database Design Fundamentals for instance) Course Descriptions Prerequisite Components (Lecture, or Laboratory for instance) Classes: Class # Class Name (usually the course name, M 170 for instance) Start Date End Date Meeting time (9:30 am ~ 12:15 pm, for instance) Days in a week (Monday) Term (Spring 2018, for instance) Location (TIE Building for instance) Room (UB 301, for instance) Instructor Online status (online, or in-person) Faculty: Employee Id (001880301, for instance) First Name Last Name Title (professor, for instance) Email Phone Office Location (TIE building, for instance) Room (UB303, for instance) Student: Student ID First Name Last Name Plan Sub Plan Advisor Current GPA Grade of each course The Term you got the…
Database Foundations: Design a database to produce the following reports. Do not use any surrogate keys in your design. For each guide, list the guide number, guide last name, guide first name, address, city, state, postal code, telephone number, and date hired. For each trip, list the trip ID number, the trip name, the location from which the trip starts, the state in which the trip originates, the trip distance, the maximum group size, the type of trip (hiking, biking, or paddling), the season in which the trip occurs, and the guide number, first name, and last name of each guide. A guide may lead many trips and a trip may be led by many different guides. For each client, list the client number, client last name, client first name, address, city, state, postal code, and telephone number
Alert dont submit AI generated answer.
If you sell a house more than once, it is treated as different "property" for each sale. Draw an entity-relationship diagram and write a database design outline. Q2. Law Office: You are trying to automate the records for your uncle's law firm. Multiple attorneys work for the firm, and for each of them you want to store their first name, last name, date hired, hourly billing rate, and date promoted to partner (blank if the attorney is not a partner). Each attorney has multiple cases, which is identified by a unique "docket number". Each case has a name and description, is worked on by only one attorney, and involves a single client. For each client, you want to store a first name, last name, middle name, phone number, address, city, state, and zip code (assume you do not have a zip-code table). Finally, you want to keep track of the billable hours spent on each case. For a single case, this comprises information that looks like Hours Billed Date 2/24/2005 Description Prepare brief…
You are to design a Hospital database. So before creating the database, your task is to draw the ER diagram based on the following data collected and analyzed: A hospital will have a name, unique id, multiple helpline numbers (one for doctor's appointment, one for ambulance, one for bill information and one for other services' info) and locations. A hospital may have more than one location as it may have different branches and each of the locations will have a building no., street address, road no. and city name. A patient will have a name, unique ID, may have more than one phone number, age, height, weight and symptoms. A patient takes an appointment in a hospital and the appointment date is recorded. A patient may have an attendant. An attendant will have his/her name, contact numbers and relationship with the patient as a record in the database. Due to the covid situation, the hospital authorities will only allow 1 attendant with 1 patient.
SportTech Events. SportTech Events SportTech Events puts on athletic events for local high school athletes. The company needs a database designed to keep track of the sponsor for the event and where the event is located. Each event needs a description, date, and cost. Separate costs are negotiated for each event. The company would also like to have a list of potential sponsors that includes each sponsor’s contact information, such as the name, phone number, and address. Each event will have a single sponsor, but a particular sponsor may sponsor more than one event. Each location will need an ID, a contact person, and a phone number. A particular event will use only one location, but a location may be used for multiple events. SportTech asks you to create a Conceptual Entity Relationship Diagram from the information described above.
An E-learning website needs your help to design its database. They need to store information about teachers and online tutorials. Each teacher has a unique ID, name, and at least one field of specialty. Teachers form groups to prepare online tutorials. Each group has unique name and at least one teacher as a member. Each online tutorial has a title, date and organized by exactly one group. The title of the tutorial is unique for the group. Each tutorial consists of several sessions, described by their titles and durations. Naturally, each session is presented by one teacher and belongs to exactly one tutorial. In addition, sessions on the same tutorial have different titles. Design an ERD for this application. Note any unspecified requirements, and make appropriate assumptions to make the specification complete.
Task 1:Create a database Entity and Relationship Diagram (ERD) for the following application:Please include answer with detailed explanationKhair Application: The Application idea: It is a mobile application called (Khair) to help people. This assistance is moral, material. This assistance is also provided by good people in our community. Example to understand the Application idea more: For example, a person urgently needs a medical chair or bed and does not have the ability to purchase what he needs. The medical chair or bed is requested through the application, and whoever has what he requests initiates the request through the application’s messages and determines the meeting place. Application models (page): Login included: login registration login included: user name password New registration included: name E-mail Password phone number date National Identification Number Home page included: Request - applicant name - address - send message Messages list form included: list of…
Store Database - Create a database with all needed tables for a store that contain product information, sales information, and customer information. Build relations among the created tables as needed. - Create a view of the customer table showing only some information about the customers.