QUESTION 115 pointsWe have been asked to develop a database system for a tourism office. The system needs to keep information aboutcustomers, cities around the world and hotels in these cities. Each city has name, country and weather that is made up ofaverage temperature in summer and average temperature in winter. Different cities can have the same name in differentcountries, but for one country the city names are unique. For each city, the system needs to keep information about thenumber of hotels in the city. For each hotel, the system must store the hotel name (which is unique for a given city), rating,contact (Email, Telephone, fax) and hotel address. The hotel rating is an integer number between 1 to 5, where 1 indicates avery low rating and 5 indicates a very high rating. For each hotel we need to store the number of rooms for each type, forexample: a hotel may have 20 rooms of type single and 15 rooms of type double. The system also store the reservationsmade by the customers. For each reservation, we need to store the check-in and check-out dates. The customer detailsstored in the system are: Passport number, CPR, name, address, and at least one telephone number.Design an ER schema diagram for the above scenario, showing all the attributes, keys, cardinalities and participationconstraints clearly.Attach FileBrowse Local FilesBrowse Content Collection

Answered: Image /qna-images/answer/fd62ba9b-98be-4147-986b-fc139c0522f5.jpg

Answered: Design an ER schema diagram for the…

Design an ER schema diagram for the above scenario, showing all the attributes, keys, cardinalities and participation constraints clearly.

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

You set up a database company, MaxData, which builds a product for art galleries. The core of this product is a database with a schema that captures all the information that galleries need to maintain. Galleries keep information about artists, their names (which are unique), birthplaces, age, and style of art (abstract, photorealism, expressionism, impressionism). For each piece of artwork, the artist, the year it was made, its unique title, its type of art (e.g., painting, lithograph, sculpture, photograph), and its price must be stored. Pieces of artwork are also classified into groups of various kinds, for example, portraits, still life’s, works by Picasso, or works of the 19th century; a given piece may belong to more than one group. Each group is identified by a name (like those just given) that describes the group. Finally, galleries keep information about customers. For each customer, galleries keep that person’s unique name, address, total amount of dollars spent in the…
Your task is to develop a database, in order to keep information on all sales at a motorcycle dealership. The database will include information on motorcycles, salespeople, sales, and customers. We assume for simplicity that the dealership sells only new motorcycles and that all motorcycles are produced by the same manufacturer. Each kind of motorcycle is called a model, and it has a unique model number. For each model, you want to store also its name, engine size in cubic centimeters (cc) which is an integer number, and the date when this particular model was introduced. For each salesperson, you want to store their employee ID number, first name, middle initial, last name, and the date when the employee was hired. For each customer, you want to store a customer ID number, first name, middle initial, last name, address information (city, state, and zipcode), phone number (given in standard US format), and e‐mail address. Assume that you do not have a zip code table available. Each…
The Vegan Garden is a little cafe in the tranquil village of Dawnsville. Five years have passed since the eatery first opened its doors. Nowadays, sales are recorded manually via the use of cash registers, and monthly sales reports, in addition to other corporate paperwork such as employee and supplier information, are kept in dusty filing cabinets. The manager of Vegan Garden has decided to build a database. He enlisted the help of a computer company to create a database tailored to the Vegan Garden's current methods of doing business.You're in charge of leading the team that builds the Vegan Garden database.In your role as project manager, it is your responsibility to warn Vegan Garden's owner about the risks associated with the insecurity of their computer systems. List FIVE (5) of the MOST COMMON SECURITY THREATS FACING INFORMATION SYSTEMS.
You have been tasked with creating a database solution for a local library. This database will be used to keep information about the books owned by the library and which books are checked out by customers. You are given the following information: The database will need to store information about books, authors, and customers. Books can have multiple authors. Authors can write multiple books. Customers can check out any number of books they wish. Book information includes title, author, year of release, number of pages, genre, location (in library, checked out). Author information includes name. Customer information includes name, age, phone number, join date, and books checked out. Instructions: with the selected scenario in mind, create an ERD Diagram showing the tables and fields needed. Be sure to identify any keys or constraints. Write a brief prompt discussing the design considerations of your database solution.
Suppose you are given the following requirements for a simple database for the football League (FL): the FL has many teams, each team has a name, a city, a coach, a captain, and a set of players; 24 players, each player belongs to only one team, each player has a name, a position (such as left wing or goalie), a skill level, and a set of injury records, · a team captain is also a player, a game is played between two teams (host team and guest team) and has a date (such as May 11th, 2020) and a score (such as 4 to 2). Construct a Database Conceptual Model using UML ER diagram for the FL database. Use mapping rules to convert the design to Logical database model using UML ER model. Check the entities to be in the 3NF normal form. Write the needed SQL Statements to create the database.
You need to create a database for animation activities at a resort: There are customers participating in the activities.Customers' ID, name, surname, age, room number and telephone information are kept. There are animators running the activities.Animators' ID, name, surname, telephone number and area of expertise are kept. Each animator can have more than one specialization. There are two different types of activity. Individual activity and Group activity.Individual activities have ID, activity name, internet connection, participation requirement. Group activities store ID, activity name, internet connection and capacity information. Group activities such as aerobics, surf school, pool games are open to the participation of more than one client and more than one animator. There is only one animator who is also a supervisor for individual activities. An animator supervises only one activity. Many customers can participate in individual activities, but they need a separate scheduled…
Question: A project is proposed to design a database to store details of laptops in a school. The shop has several laptops, where each laptop can be used by many users. Information to be stored about each laptop includes ID, users, type, and a list of software. Each chapter has exactly one main user and zero or more secondary users. A software has a unique name and validity. Each user has a name and a unique ID and it should be possible to search the database by users names, laptop IDs, and software keywords. Whenever any user uses a software on laptop, the date and time of usage should be recorded; this is used name and role (student, teacher, or administrator). r reporting when a software was last used, as well as recording the number of times a software was used. Each user is identified by a unique ID, has a
Suppose you are given the following requirements for a simple database for the National Football League (NFL): the NFL has many teams, each team has a name, a city, a coach, a captain, and a set of players, each player belongs to only one team, each player has a name, a position (such as left wing or goalie), a skill level, and a set of injury records, · a team captain is also a player, a game is played between two teams (referred to as Home Team and Guest team) and has a date (such as May 11th, 1999) and a score (such as 4 to 2) Instructions: Use the Case Study above to complete the following tasks 1. Identify the objects (entities) and attributes based on the information provided in the case study
You need to create a database for animation activities at a resort: There are customers participating in the activities. Customers' ID, name, surname, age, room number and telephone information are kept. There are animators running the activities. ID, name, surname, telephone number and area of expertise of the animators are kept. Each animator can have more than one specialization. There are two different types of activity. Individual activity and Group activity. Individual activities have ID, activity name, internet connection, participation requirement. Group activities store ID, activity name, internet connection and capacity information. Group activities such as aerobics, surf school and pool games are open to the participation of more than one client and more than one animator. There is only one animator who is also a supervisor for individual activities. An animator supervises only one activity. Many customers can participate in individual activities, but they need a separate…
Suppose you are given the following requirements for a simple database for the National Hockey League (NHL): the NHL has many teams, each team has a name, a city, a coach, a captain, and a set of players, each player belongs to only one team, each player has a name, a position (such as left wing or goalie), a skill level, and a set of injury records, a team captain is also a player, a game is played between two teams (referred to as host team and guest team) and has a date (such as May 11th, 2019) and a score (such as 4 to 2). Construct a concise ER diagram for the NHL database.
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.
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.