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

Related questions

Q: Explain why an index is only effective when an attribute's values cover a suitable range of values.…

A: using a variable index with an extensive range of values An index in computing is a table or other…

Q: You may have both a primary key and a potential key for the same attribute.

A: Required: What do you respond if someone suggests that an attribute which is a component of a…

Q: Draw a complete Entity Relationship Diagram (ERD) for the following. Perfect Pizza is a pizza…

A: ERD stands for Entity Relationship Diagram. ERD is a graphical representation that is used to depic…

Q: Design a survey form of your own. Fill it out as it might have been completed during the database…

A: SURVEY FORM: • Whenever a database is designed, a survey form proves to be useful for obtaining…

Q: What is the difference between an attribute with numerous values and a recurring group?

A: An attribute is fields that may be originate in a database management system (DBMS). Constituent of…

Q: The IT manager at Sports Physical Therapy needs to know all the relationships in the database. Use…

A: Sports physical therapists deal with a complex network of patient information, therapy schedules,…

Q: A department of the university has a small car, which members of staff may use for work purposes.…

A: Hey, since there are multiple questions posted, we will answer first question. If you want any…

Q: Q1. ER Model . Create an ER Model for the following: A customer (eg. Tom) may (or may not) give…

Q: BFY maintains a website to get customer orders. Customer can visit BFY website either directly or…

A: the diagram is an shown below :

Q: Create an ER model related to the following entities and relationships: Department, Student,…

A: The Diagram of the ER model is attached here with the answer. Please refer to step 2.

Q: This problem gave me all the info needed to create an ERD for real estate. I put together the tables…

A: ERD with crow's feet notation in 3NF is as follows :

Q: Data Model Design: In this class practice, you will use the user story from class practice 01…

A: The given is a user story related to the library system. The requirement is to identify entities and…

Q: Question 3: ERD design Although you always wanted to be a dog trainer, you ended up being an expert…

A: Although you always wanted to be a dog trainer, you ended up being an expert on databases because…

Q: he administrators of Tiny College are so pleased with your design and implementation of their…

A: The administrators of Tiny College maintain the database for their motor vehicle pool. The following…

Q: Reports to BRANCH BranchID BranchName BranchAddress (Street1, Street2, City, State ZIP)

A: A logical data model is similar in concept to using a map and an itinerary when going on a trip. You…

Concept explainers

Fundamentals of Datawarehouse

A data warehouse is a data repository which is used to store large quantities of historical data that are mostly used for creating reports that help businesses to identify their weaknesses and strengths. For example, demographics data about people of a region can help businesses identify the needs and preferences of the region’s population. A data warehouse acts as a central storage for storing data that comes from one or more heterogenous sources. It also consists of data which can be old and of historical value. One of the most important applications of this type of system is that it is used for supporting business intelligence and data analytics applications.

Question

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. After
several interviews with the users, you have come up with the following data requirements and
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 BUILDING
are BuildingNo. BuildingName and Location. ROOM is always identified in association with
BUILDING (BuildingNo). The attributes for ROOM include RoomNo and Capacity. There are
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 CourselD and has attributes CourseDescriptions and Credits. A course
may (or may not) have more than one section. Each section is always identified in association
with COURSE (CourseID). SECTION has attributes SectionNo and EnrollmentLimit,
INSTRUCTOR has identifier EmpID and has attributes FirstName, LastName, Rank, and Office
Phone. 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. An
instructor is assigned to more than one time slot (i.e., many) Each time slot is assigned more than
one 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 slot
involves more than one classroom.
A course may (or may not) have more than one (i.e., many) prerequisites.

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

This is a popular solution!

SEE SOLUTION Check out a sample Q&A here

Step 1

VIEW

Step 2

VIEW

Trending now

This is a popular solution!

Step by step

Solved in 2 steps with 4 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions

A derived attribute is a Illustrate. What are the benefits and drawbacks of storing derived attributes?
Database Design Testing (ID_testing,date,observerId) Observer(observerId,observer_name) Type(TypeId,typename) Essentialoil (ID_essential,essentialname,typeId,batchcode) Constituent (ID_constituent,cname,min_percentage,Test_percentage,status) Before an Essential Oil product is marketed, testing is carried out based on the production batch from any essential oil. This is done to maintain the quality and content of the existing constituents in essential oils. Where the Test Percentage Content must reach the Minimum standard Percentage Content for each constituent. If there is one type of constituent that does not fulfill minimum standard, the batch will not be marketed because it does not meet the standard quality. Question 1. Make an ERD (Entitiy Relationship Diagram) based on the results of Normalization 2. Develop the ERD that you create to implementGeneralization / Specialization.
1. Create an entity relationship diagram for the conceptual design using UML notation. The diagram can be created by hand or via some modeling tool. 2. Create a data dictionary for the entities, relationships and attributes. Make your best guess for representing the attributes. Schema 3 You have been hired by the Snowbird ski mountain resort to build a database for their data. The resort has ski mountain peaks, chair lifts, trails, stores and restaurants. For each mountain peak, you track the name, the elevation and its latitude and longitude. Each peak name is unique. The names of the mountain peaks are: Mount Superior, Mount Baldy, Twin Peaks and Hidden Peak. For each chair lift, you track a unique name, the vertical rise, the travel time, the number of people per chair (ranging from 2 to 4) , and its closing time. For each trail, you track its unique name, its elevation, its length, and the typical time it takes to complete. Each ski trail is classified by its level of…
Q2: Draw an ERD from the following business rules: Use proper notations for the type of attributes A software system is to be developed for an educational institute.The software is intended to be used by faculty members, students and designated support staff. System administrator will also use system for system administration and management. Student’sdata including names, registration number, cell numbers and address will be added and edited by Clerk. The data will be added at the timeof student reporting at campus. Student can enroll into any course of their choice from the offered courses. They can also request for dropping a course. Approval of course dropping of a student will be granted or refused by academic coordinators
Create ERD and relational schema for given case study
courses dasses ↑coursel INT courseDateTime DATETIME O room INT coursel INT courseName VARCHAR(45) course Description VARCHAR(45) room are used by a class. For each entity: Entitios rooms Froom DVT L-building VARCHAR(X) capacity VARCHAR(45) Inders The ERD depicts the data needed to track which course and Indicate if the entity is strong, weak ID-dependent, or weak non-ID-dependent For each relationship: • List the cardinality and participation of each entity in the relationship List the business rules for each relationship Indicate if the relationship is identifying or not
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.…
using the design file in the image attached to the question : Normalize the database in the design file Be aware of the possibility of duplicate data. Name in Role and Employee and Emp_Contact_name all refer to the same data. Name and Email in Vendor refer to the Vendor. Assumptions made: An employee works with one or more vendors. An employee may have none or many dependents. An employee may have many roles over the employee's work history and a record should be retained for each role.
using the design file in the image attached to the question : Normalize the database in the design file Be aware of the possibility of duplicate data. Name in Role and Employee and Emp_Contact_name all refer to the same data. Name and Email in Vendor refer to the Vendor. Assumptions made: An employee works with one or more vendors. An employee may have none or many dependents. An employee may have many roles over the employee's work history and a record should be retained for each role. Make sure to have a primary key for each table . Make sure to include the relationships between the tables .
Explain why an index is only effective when an attribute's values cover a suitable range of values. This is the sole situation in which an index is helpful.