User Account

All Pages

Develop an eer model using the traditional eer notation

Assignment Help Database Management System
Reference no: EM13949441

Develop an EER model for the following situation using the traditional EER notation, the Visio notation or the supertypes notation.

An international school of technology has hired you to create a database management system to assist in scheduling classes.

After several interviews with the president, you have come up with the following list of entities, attributes, and initial business rules:

- Room is identified by Building_1D and Room_NO and also has a Capacity. A room can be either a lab or a classroom. If it is a classroom, it has an additional attribute called Board_Type.

- Media is identified by Mtypeid and has attributes of MediaType and TypeDescription. Note: Here we are tracking type of media (such as VCR, projector, etc.) not the individual piece of equipment. Tracking of equipment is outside the scope of this project.

- Computer is identified by Ctypeid and has attributes ComputerType, TypeDescription, DiskCapacity, and ProcessorSpeed.

Please note: As with Media Type, we are tracking only the type of computer, not an individual computer. You can think of this as a class of computers (e.g., PIII 900MHZ).

- Instructor has an identifier Emp_ID and has attributes Name, Rank, and Office Phone,

- Timeslot has identifier TSIS and has attributes DayofWeek, StartTime, and EndTime.

- Course has identifier CourseID and has attributes CourseDescription and Credits. Course can have one, none or many prerequisites. Courses also have one or more sections.

- Section has identifier SectionID and attribute EnrollmentLimit
After further discussions, you have come up with some additional business rules to help you create the initial design:

- An instructor teaches one, none or many sections of a course in a given semester.

- An instructor specifies preferred time slots

- Scheduling data are kept for each semester, uniquely identified by semester and year.

- A room can be scheduled for one section or no section during one time slot in a given semester of a given year. However, one room can participate in many schedules, one schedule, or no schedules; one time slot can participate in many schedules, one schedule, or no schedules; one section can participate in many schedules, one schedule or no schedule. Hint: Can you associate this to anything that you have seen before.

- A room can have one type of media, several types of media, or no media.

- Instructors are trained to use one, none, or many types of media

- A lab has one or more computer types. However, a classroom does not have any computers.

- A room cannot be both a classroom and a lab. There also are no other room types to be incorporated into the system.

Reference no: EM13949441

Questions Cloud

Determining the three-phase induction motor : 1. A four-pole, three-phase induction motor rotates at 1,700 r/min when the load is 100 N-m. The motor is 88 percent efficient. a. Determine the slip at this operating condition.
Respond to the given discussion : Creswell (2009) identified surveys and experiments as two methods by which to conduct quantitative research (p. 145). He defined a survey design as one providing a "numeric description of trends, attitudes, or opinions of a population by studying ..
Which type of communication : Provide an example of formal communication and an example of informal communication. Which type of communication do your prefer in a work environment? Why?
Determine torque at motor-turbine shaft : Determine the torque at the motor-turbine shaft and the total power delivered to the turbine. What is the total power consumed by the motor?
Develop an eer model using the traditional eer notation : An international school of technology has hired you to create a database management system to assist in scheduling classes
Raw materials inventory : Ending finished goods inventory should be 40 percent of next month's sales.Ending raw materials inventory should be 30 percent of next month's production.
Improve effectiveness and efficiency in delivery of services : The short term Strategic objectives of the strategic plan of the institution are: Improve the ability of Parliament to exercise effective financial oversight and Improve effectiveness and efficiency in the delivery of services
Did the estimated regression equation provide a good fit : Develop an estimated regression equation that can be used to predict the starting salary and bonus paid to graduates given the cost of out-of-state tuition and fees at the school.
Analysis of short-term financing : Rome Airlines is an Italian based firm that needs $350,000. It has no business in England but is considering one year financing with British pounds, because the annual interest rate would be 5 percent versus 10 percent in Italy. Assume that interest ..

Reviews

Write a Review

Database Management System Questions & Answers

  Describe a general company security policy for database

Describe a general company security policy for the database "layer" of security only (avoid getting into network security protocols or application level security for this exercise, and assume that there are security mechanisms in place that allow ..

  Database management systems

An automotive service center or dealer wants to improve its services by using database management systems (DBMS) and data mining. What tables are needed in such a database and how could it help improve their services?

  Why are labor operations and labor types often tracked in

Why are labor operations and labor types often tracked in the conversion process but usually not tracked in the revenue process?

  Implement a database accounts stored in memory management

Your job is to implement a database (accounts stored in memory) management (access mechanisms) system as specified. Your program should loop forever to iteratively take an integer input from the user

  Construct an entity-relationship model for the database

Construct an entity-relationship (ER) model for the database. Make sure you include in your model details of entities, relationships, attributes, keys and limits in participation.

  Draw the corresponding entity-relationship diagram

Design an entity-relationship schema that most correctly and most completely captures the constraints expressed in the above description of the VINO application. Draw the corresponding entity-relationship diagram.

  Implement a good information systems plan

Implementation of business analytics, an organization will also need to implement a good information systems plan in order to collect, manage, and organize all of the data.

  Jdbc enables applications to exchange data

JDBC enables ____ applications to exchange data with any database that uses SQL statements and is compliant with the

  Which is not a factor to consider in software evaluation

Peer reviewers are the key participants in which activity?

  Calculates the annual cost of running an appliance

Write a program that calculates the annual cost of running an appliance. The program will ask the user for the cost per kilowatt-hour and the number of kilowatt-hours the appliance uses in a year:

  Find name and membership number of members

Find the name and membership number of members who have borrowed more than five different books of that publisher.

  Write a script that calculates the common factors

Write a script that calculates the common factors between 10 and 20. To find a common factor, you can use the modulo operator (%) to check whether a number can be evenly divided into both numbers.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd