Modern Database Management
13th Edition
ISBN: 9780134773650
Author: Hoffer
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Question
Chapter 12, Problem 12.25PAE
Program Plan Intro
To categorize:
The activities belonging to people, process and technology.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
A competitive advantage is an advantage over competitors gained by offering consumers greater value, either by means of lower prices or by providing greater benefits and service that justifies higher prices. How has the information system helped in gaining competitive advantage for a specific industry? (Give an example of a specific industry and explain how it has gained the competitive advantage with the use of information system.)
Luxury-Oriented Scenic Tours (LOST) provides guided tours to groups of visitors to the Washington, D.C. area. In recent years, LOST has grown quickly and is having difficulty keeping up with all of the various information needs of the company. The company's operations are as follows:
LOST offers many different tours. For each tour, the tour name, approximate length (in hours), and fee charged is needed. Guides are identified by an employee ID, but the system should also record a guide's name, home address, and date of hire. Guides take a test to be qualified to lead specific tours. It is important to know which guides are qualified to lead which tours and the date
that they completed the qualification test for each tour. A guide may be qualified to lead many different tours. A tour can have many different qualified guides. New guides may or may not be qualified to lead any tours, just as a new tour may or may not have any qualified guides.
Every tour must be designed to visit at least…
Draw an Entity relationship diagram (ER) for a university according to the following rules:
‐ For each student the university needs to keep track of: first name, last name, student id, address, phone no and their major.
‐ The student id is identical for each
‐ Each course has a number, name and credit. The course number is unique for each course.
‐ Each department has a name, code and The code is unique for each department.
‐ Each course may has one or more sections where each section is belong to only one
‐ A department offers one or many 7-‐ Some courses have perquisite courses.
8-‐ Each student could register in one or more courses.
In your diagram you need to show the following: 1-‐ The primary key for each entity.
2-‐ The cardinality and participation between entities.
Chapter 12 Solutions
Modern Database Management
Ch. 12 - Prob. 12.1RQCh. 12 - Prob. 12.2RQCh. 12 - Contrast the following terms: chief data officer;...Ch. 12 - Indicate whether data administration or database...Ch. 12 - Prob. 12.5RQCh. 12 - Prob. 12.6RQCh. 12 - Prob. 12.7RQCh. 12 - Prob. 12.8RQCh. 12 - Prob. 12.9RQCh. 12 - Prob. 12.10RQ
Ch. 12 - What are the key activities that are often the...Ch. 12 - What are the key components of a data governance...Ch. 12 - Prob. 12.13RQCh. 12 - Prob. 12.14RQCh. 12 - Prob. 12.15RQCh. 12 - Prob. 12.16RQCh. 12 - Prob. 12.17RQCh. 12 - Prob. 12.18RQCh. 12 - Prob. 12.19RQCh. 12 - Prob. 12.20RQCh. 12 - Prob. 12.21RQCh. 12 - Prob. 12.22RQCh. 12 - Prob. 12.23RQCh. 12 - Prob. 12.24PAECh. 12 - Prob. 12.25PAECh. 12 - Prob. 12.27PAECh. 12 - Prob. 12.28PAECh. 12 - Prob. 12.29PAECh. 12 - Prob. 12.30PAECh. 12 - Prob. 12.31PAECh. 12 - Prob. 12.32PAECh. 12 - Prob. 12.33PAECh. 12 - Prob. 12.34PAECh. 12 - Prob. 12.35PAECh. 12 - Prob. 12.36PAECh. 12 - Prob. 12.37PAECh. 12 - Prob. 12.38PAECh. 12 - Visit the Web sites of one or more popular cloud...Ch. 12 - Prob. 12.40PAE
Knowledge Booster
Similar questions
- Draw an EER diagram for the following situation using the traditional EER notation. A technology company provides offerings to its customers. Offerings are of two separate types: products and services. Offerings are identified by an offering ID and an attribute of description. In addition, products are described by product name, standard price, and date of first release; services are described by name of the company’s unit responsible for the service and conditions of service. There are repair, maintenance, and other types of services. A repair service has a cost and is the repair of some product; a maintenance service has an hourly rate. Fortunately, some products never require repair. However, there are many potential repair services for a product. A customer may purchase an offering, and the company needs to keep track of when the offering was purchased and the contact person for that offering with the customer. Unfortunately, not all offerings are purchased. Customers are…arrow_forwardCreate an ER/EER diagram for the following 1. Professors have an SSN, a name, an age, a rank, and a research specialty. Projects have a project number, a sponsor name (e.g., NSF), a starting date, an ending date, and a budget. Graduate students have an SSN, a name, an age, and a degree program (e.g., M.S. or Ph.D.). Each project is managed by one professor (known as the project's principal investigator). Each project is worked on by one or more professors (known as the project's co- investigators). Professors can manage and/or work on multiple projects. Each project is worked on by one or more graduate students (known as the project's research assistants). When graduate students work on a project, a professor must supervise their work on the project.arrow_forwardConsider the DFD in Figures 6-20. List three errors (rule violations) on this DFD.arrow_forward
- QUESTION 11 Draw Context Diagram for the following scenario: The restaurant management system will collect the order from the customer and serve products based on the order. The customer has to pay for the order. After collecting the order, the employees in the restaurant produce products. The system should pay for the employees according to the time they have worked. The system should also place the order to purchase the raw materials from the vendor. After purchasing the raw material from the vendor, system should make payment for the same. Attach File Browse My Computerarrow_forwardCreate an ER/EER diagram for the following 1. Professors have an SSN, a name, an age, a rank, and a research specialty. Projects have a project number, a sponsor name (e.g., NSF), a starting date, anending date, and a budget. Graduate students have an SSN, a name, an age, and a degree program (e.g., M.S.or Ph.D.). Each project is managed by one professor (known as the project’s principalinvestigator). Each project is worked on by one or more professors (known as the project’s co-investigators). Professors can manage and/or work on multiple projects. Each project is worked on by one or more graduate students (known as the project’sresearch assistants). When graduate students work on a project, a professor must supervise their work on the project. Graduate students can work on multiple projects, in which case they will have a (potentially different) supervisor for each one. Departments have a department number, a department name, and a main office. Departments have a professor (known…arrow_forwardConstruct an ER_Diagram for NSU Employees who are identified by a unique id number. NSU has 3 major types of employee (faculty, secretary and OSS) with their specific role. Each faculty has many research areas and they work on monthly salary basis. Secretary also works on monthly salary basis but they have an option for overtime. Security guard salary is calculated by the number of hours they worked in a month. At the end of each month, employees are paid form the NSU account. We are also interested to store the starting date of each employee.arrow_forward
- 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)arrow_forwardCreate an ER diagram for a reservation system of hotel rooms considering the following facts. You should indicate some attributes and the primary key for each entity. ■ Hotel contains several rooms Customer can reserve one or more rooms One room contains one, two, or three beds ⚫ Bed can be normal (for one person), double, or spare (less expensive)arrow_forward´Draw the Use Case diagram for the following scenario. ´Muscat international airport wants the use case diagram for their process during passenger check-in. Passengers include tour guides, minor and disable persons. Business use cases are individual check-in, group check-in (for tour guides) and security screening etc. represents business functions or process is taking place in the airport. Individual check in can be done at web or kiosk. Some of the passengers might have no luggage, so baggage check-in or baggage handling processes are optional.arrow_forward
- Identify the entities, relationships, key attributes and other attributes and then design the ER diagram: There are many hotels in a country. Each hotel is identified by its id, name and star rate. Each hotel provides many rooms. Rooms are identified by Room no. and type. Each room is rented for a cost. Cost is identified by its id and amount. A hotel has many facilities available with it. Facilities are identified by its id and name. A hotel is located at a particular location. Location is identified by street, town and pincode.arrow_forwardDraw entity relationship diagramarrow_forwardDraw ERD for each of the following situations. Clearly state any additional assumption(s) for each of the situation:AIT Inc with Prof. Dzidonu as the President has a number of employees. The attributes of the EMPLOYEE include Employee_ID (identifier), Name, Address and Birthdate. The company has also several projects. Attributes of PROJECT include Project_ID, (Identifier), Project_Name and Start_Date. Each Employee may be assigned to one or more projects or may not be assigned to a project.A project must have at least one employee assigned and may have any number of employees assigned. An employee’s billing rate may vary by project, and the company wishes to record the applicable billing rate (Billing_Rate) for each employee when assigned to a particular project. Do the attribute names in this description follow the guidelines for naming attributes? If not, suggest better namesarrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Management Of Information SecurityComputer ScienceISBN:9781337405713Author:WHITMAN, Michael.Publisher:Cengage Learning,
Management Of Information Security
Computer Science
ISBN:9781337405713
Author:WHITMAN, Michael.
Publisher:Cengage Learning,