Draw an E-R Diagram that models an information system that keeps track of booking information for several hotels within a chain. Use the notation that is used in the text and in class. State any other assumptions you make. a. b. Each hotel has a unique hotel identifier along with a name, location, and phone number. Each hotel has different numbers, and types of rooms. For a given hotel, each room is assigned a room number, type (single, double, suite, etc.) and standard price. c. Each hotel customer has a unique customer number, a name, a phone number, and a credit card number. d. A customer books a specific room for a given date and number of days. e. The actual price of a given room may differ between customers due to the customer being a preferred or corporate customer. State any assumptions you make. Be clear.

Draw an E-R Diagram that models an information system that keeps track of booking information for several hotels within a chain. Use the notation that is used in the text and in class. State any other assumptions you make. a. b. Each hotel has a unique hotel identifier along with a name, location, and phone number. Each hotel has different numbers, and types of rooms. For a given hotel, each room is assigned a room number, type (single, double, suite, etc.) and standard price. c. Each hotel customer has a unique customer number, a name, a phone number, and a credit card number. d. A customer books a specific room for a given date and number of days. e. The actual price of a given room may differ between customers due to the customer being a preferred or corporate customer. State any assumptions you make. Be clear.

C++ for Engineers and Scientists

4th Edition

ISBN:9781133187844

Author:Bronson, Gary J.

Publisher:Bronson, Gary J.

Chapter11: Introduction To Classes

Section11.5: A Closer Look: Uml Class And Object Diagrams

Problem 1E

See similar textbooks

Similar questions

1. Create the initial ER diagram for a car dealership. The dealership sells bothnew and used cars, and it operates a service facility. Base your design on thefollowing business rules:a. A salesperson can sell many cars, but each car is sold by onlyonesalesperson.b. A customer can buy many cars, but each car is sold to only onecustomer.c. A salesperson writes a single invoice for each carsold.d. A customer gets an invoice for each car(s) hebuyse. A customer might come in only to have a carserviced; that is, one need not buya car to be classified as a customer.f. When a customer takes in one or more cars for repair or service,one serviceticket is written for each car.g. The car dealership maintains a service history for each car serviced. The servicerecords are referenced by the car’s serialnumber.h. A car brought in for service can be worked on by many mechanics,and eachmechanic can work on many cars.i. A car that is serviced may or may not need parts. (For example, parts are…
Draw a use case diagram based on the case study given below.Your diagram should contain at least 3actors, 8 use cases, and 2 include and 2 extend relationships. Write an algorithm on how to withdraw money from an ATM. Shopping Made Easy System A customer uses Shopping Made Easy System for online shopping. System requires the customer to sign up and sign in to be able to interact with the system. Customer registration is verified by the administration. A customer may use the portal as a guest without signing up but is only able to view catalogues in case of a guest. A customer can manage his/her account which involves signup/sign in and profile management. A customer can browse through catalogues to view different products; customer can also search for a specific catalogue by name or code number. Customer can view the products and can log out without buying. Another main feature of the system is Shopping cart management. Customer can add or remove items in cart. Customer can…
You are asked to design a sequence diagram to describe the interactions of a part of a library system. This part can be described as a use case. In this use case, a librarian uses the system to check out an item for a legitimate borrower. First, the system needs to check the borrower's record. Second, check if the item is available or not, then update the library data, the borrower's record, etc. Use the following class diagram and details to get information about the system. Record CheckOut LibraryData recordlsGood checkRecord() addToRecord() checkData() changeData() available 1 1 requestCheckOut() 1 *
Design the UML class diagram to support the system below and upload a picture of your diagram. Used Class Material Website: You are designing a website where students can resale their used material for a course. A course may have multiple sections. The course material is specific to each section of a class. Not all course may require class materials, but they may require many of them. A student can have many used materials for sale. The class material can be either: · Textbook: which has a price(mandatory), title(mandatory), authors(optional), edition(optional) · Software: which has a price(mandatory), title(mandatory), publisher(optional), and also its operating system (mandatory) · Equipment: which has a price(mandatory), title(mandatory), description(mandatory) All class material can be either available or sold. Do a class diagram with: 1. all the classes , 2. their associations 3. their multiplicity . 4. For each classes, where are the…
Draw a complete ER-diagram for the following case. A lecturer (having an ID, name and room number) is responsible for organizing a number of course modules. Each module has a unique code and also a name and each module can involve a number of lectures who deliver part of it. A module is composed of a series of lectures and sometimes lectures a on a given topic can be part of more than one module. A lecture has a time room and date and is delivered by a lecturer and a lecturer may deliver more than one lecture. Students, identified by number and name, can attend lectures and a student must be registered for a number of modules. We also store the date on which the student first registered for that module. Finally, a lecturer acts as a tutor for a number of students and each student has only one tutor. Also show relational database schema including Primary and Foreign key constraints. (Please draw this on a paper)
Create an Activity Diagram for the “Order Item(s)” or “Purchase Item(s)” use case (or chain of use cases). The name that you have given this Use Case or group of Use Cases may differ, but it should be quite a comprehensive Use Case(s) that should encapsulate the following: Customers buying non-prescription items. Customers buying prescription items. Customers buying any number of items at once (i.e. 1 or more). Order fulfillment by warehouse staff. Order fulfillment by pharmacists. This Use Case does NOT need to encapsulate: Customers browsing or searching for items. Customers logging into or creating accounts. Customer payment.Attached will be more information on the Pharm@Home System
1. Draw a class diagram representing the relationship between travellers and the hotels in which they stay.
Draw an EER diagram to keep track of information for an art museum based on the following requirements a. The museum has a collection of ART_OBJECTS. Each ART_OBJECT has a unique Id_no, an Artist (if known), a Year (when it was created, if known), a Title, and a Description. The art objects are categorized in several ways, as discussed below. b. ART_OBJECTS are categorized based on their type. There are three main types: PAINTING, SCULPTURE, and STATUE, plus another type called OTHER to accommodate objects that do not fall into one of the three main types. c. A PAINTING has a Paint_type (oil, watercolor, etc.), the material on which it is Drawn_on (paper, canvas, wood, etc.), and Style (modern, abstract, etc.). d. A SCULPTURE or a statue has a Material from which it was created (wood, stone, etc.), Height, Weight, and Style. e. An art object in the OTHER category has a Type (print, photo, etc.) and Style. ART_OBJECTs are categorized as either PERMANENT_COLLECTION (objects that are…
Draw an ER diagram that captures the following information: A book identified by (unique Id number, a title and one or more authors), A library identified by (unique name and adders), A borrower has a name and a unique ID code. The library service may own several copies of a given book. A borrower can have many books on loan, but each copy of a book can only be on loan to one borrower. A borrower could borrow the same book on several occasions, but it is assumed that each such loan will take place on a different date. *
A company makes items. Each item has a name, ID and component quantity. Every item contains many components. Each component can be supplied by one or more suppliers. Suppliers have names and IDS. Each component has ID, name, description, suppliers who supply them, and items in which they are used. Not all suppliers provide components, and a component is not always associated with a supplier. Also, a component always have to be associated with one or more items. Finally, the company contact customers using their IDs, Names and Phones to sell them items. A customer can buy one or more items.
An Entity Relationship (ER) Diagram is a type of flowchart that illustrates how “entities” such as people, objects or concepts relate to each other within a system. Consider the following description of a system: A university registrar’s office maintains data about following entities: Courses, including number, title, credits, syllabus, and prerequisites. Course offerings, including course number, year, semester, section number, instructor, timings and classroom. Students, including student-id, name, and program. Instructors, including identification number, name, department, and title. Furthermore, the enrollment of students in courses and grades awarded to students in each course they are enrolled for must be appropriately modeled. Construct an ER Diagram for the registrar’s office. Document all assumptions that you make about the mapping constraints.
The following uependency diagram indicates that a patient can receive many prescriptions for one or more medicines over time. Based on this diagram, draw an ERD whose tables are in at least second normal form (2NF). MedName PatientID Date RefillsAllowed PatientName Dosage Shelf Life To keep track of equipment in a certain university, the following table of information is kept: item_id item_label room_numberbldg_code bldg_name bldg_manager 22123 HP Printer 22133 HP Monitor 22134 HP Monitor 10120 CCIT 10120 CCIT 10245 CCIT 12230 CMB 12230 CMB College of Computing and IT Ali Mohammed College of Computing and IT Ali Mohammed College of Computing and IT Ali Mohammed College of Business Management Seif Willis College of Business Management Seif Willis 33212 HP Printer 23312 HP Printer 1. Draw a dependency diagram of the information found in the table. You can use draw.io and copy/paste the image into your submitted document. 2. Normalize the table into 2NF and write the relational schema. 3.…