Using MIS (10th Edition)
10th Edition
ISBN: 9780134606996
Author: David M. Kroenke, Randall J. Boyle
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Expert Solution & Answer
Chapter 12, Problem 12.7CE12
Explanation of Solution
Process diagram for alternative b (Shared
Explanation:
Here, the company build the complex system using shared database based processing. Using this system the company can send property descriptions to others via shared database that contains data on their properties and reservations. As tracking reservations is a common business task companies can license an existing application with this capability.
First role is listing offer and listing process. From the listing database, shared listings are prepared which are then transferred to shared listings database. From the shared listings database the listing descriptions are passed.
Next role is process listing in which listing descriptions are used to create customer emails...
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
Create an ER model related to the following entities and relationships: Department, Student, Professor, Course, Section, Grade, Major. (For attributes inside each table, you only need to insert several reasonable attributes. No need to have a comprehensive list. For many-to-many relationship, you also need to insert one extra table to handle the many-to-many relationship. The final database design will have more tables than the number of entities listed above.)
A given department can offer many courses.
A given course can be offered by only one related department.
A given course can have many related sections.
A given professor can teach many sections.
A given section can only be related to one course and taught by one professor.
A given professor can have appointment with different departments
A given department can have many professors.
A given department can offer several majors.
A given major can be offered by only one related department.
A given student can have several majors.
A…
You have been asked to design and implement a database for CTU, which includes 3 entities (tables), as follows: Students Faculty Courses Part 1 Create a Word document that includes the following: Identify at least 3 attributes for each entity, including the following: Student's entity should have an attribute for the program the student is enrolled in. Faculty should have an attribute identifying their rank. Properly identify all of the primary keys (use solid underlines). Create an entity relationship diagram (ERD) from the entities. You may use SmartDraw, Visio, Erwin, or even Word to draw the diagram. Take a screenshot (no need if you use Word), and insert it into the Word document. Part 2 Use Microsoft Access to implement the database that you designed in Part 1, and include the following: Create the Student, Faculty, and Course tables in Access. Add a few instances in each table. Create 2 queries for the following objectives: Find the student names for all students who are in the…
Design an entity–relationship diagram for this database.
Identify primary keys and relationship cardinalities using(min:max)notation.
If you make any assumptions, please state them clearly.
Chapter 12 Solutions
Using MIS (10th Edition)
Ch. 12.4 - Prob. 1EGDQCh. 12.4 - Prob. 2EGDQCh. 12.4 - Prob. 3EGDQCh. 12.4 - Prob. 4EGDQCh. 12.4 - Prob. 6EGDQCh. 12.4 - Prob. 7EGDQCh. 12.4 - Prob. 8EGDQCh. 12.4 - Prob. 9EGDQCh. 12.4 - Prob. 10EGDQCh. 12.6 - Sports are one area in which the collection and...
Ch. 12.6 - Prob. 2BOIQCh. 12.6 - Prob. 3BOIQCh. 12.6 - Prob. 4BOIQCh. 12.7 - Prob. 1SGDQCh. 12.7 - Prob. 2SGDQCh. 12.7 - Prob. 3SGDQCh. 12.7 - Prob. 4SGDQCh. 12.7 - Prob. 5SGDQCh. 12.7 - Prob. 6SGDQCh. 12.7 - Prob. 7SGDQCh. 12.7 - Prob. 1CGDQCh. 12.7 - Prob. 2CGDQCh. 12.7 - Prob. 3CGDQCh. 12.7 - Prob. 4CGDQCh. 12.7 - Prob. 5CGDQCh. 12.7 - Prob. 12.1ARQCh. 12.7 - Prob. 12.2ARQCh. 12.7 - Prob. 12.3ARQCh. 12.7 - What are the phases in the systems development...Ch. 12.7 - What are the keys for successful SDLC projects?...Ch. 12.7 - How can scrum overcome the problems of the SDLC?...Ch. 12.7 - Prob. 12.7ARQCh. 12 - Prob. 12.1UYKCh. 12 - Prob. 12.4UYKCh. 12 - Prob. 12.5UYKCh. 12 - Prob. 12.6CE12Ch. 12 - Prob. 12.7CE12Ch. 12 - Prob. 12.8CE12Ch. 12 - Prob. 12.9CE12Ch. 12 - Describe three reasons why cases like this will...Ch. 12 - Prob. 12.11CS12Ch. 12 - Prob. 12.12CS12Ch. 12 - The project was known to be in trouble, but it...Ch. 12 - Prob. 12.14CS12
Knowledge Booster
Similar questions
- Project: GYM Database System In a report should have the following sections: 1. Abstract 2. Problem Domain/ area 3. Solution Domain 4. Expected user-base 5. Top five features/ benefits 6. An Entity Relationship diagram 7. Entities & Attributes 8. Relationships & Labels 9. Validation 10.Description 11.Source code of the back-end Databasearrow_forwardCreate a relational diagram for the database using crow’s foot notation. The ERD should include all the entities, relationships, and connectivity where applicable. Additionally, please specify the business rules underlying your ERD 4 tables for the database: PATRON, BOOK_COPY, BOOK, and CHECKOUT. (Since a book may have multiple copies that may be purchased by the library at different time, it is better to have a BOOK_COPY table to avoid unnecessary data redundancy.) The data in the tables are as follows: PATRON table records a patron’s ID, name, address, phone number, and email address. BOOK table contains information such as author, title, publication date, subject, language, and a unique identifier (It can be the ISBN of the book) for each book. BOOK_COPY table records a unique identifier for each copy of a book, the date of purchase, and the identifier of the book from the BOOK table. CHECKOUT table…arrow_forwardPart 1 – Database Design (if covered Chapters 2 and 3) Step 1: Create a set of requirements that will be used to create the ER Diagram in Step 2. Step 2: Create an ER diagram (using ERDPlus) that contains at least five entities and at least four binary relationships. At least one of the relationships should be many to many. Show all attributes of all entities. Step 3: Map the ER diagram you created in Step 2 into a relational schema containing the relations (with their attributes) and the referential integrity constraints (i.e. arrows pointing from foreign keys into their sources). Use ERDPlus to draw the mapped relational schema. Part 2 - Database Implementation (if covered Chapter 5 and/or use MS Access) Step 1: Examine the Relational Schema that was created during the Part 1 of the project. Step 2: Based on that schema, create a set of tables for using a DBMS (such as MS Access, Oracle, PostgreSQL, My SQL or similar). Name the database and its tables…arrow_forward
- Please draw an Entity-Relationship diagram for the given below MOVIE database. The data requirements are summarized as follows: Each movie is identified by title and year of release. Each movie has a length in minutes. Each has a production company, and each is classified under one or more genres (such as horror, action, drama, and so forth). Each movie has one or more directors and one or more actors appear in it. Each movie also has a plot outline. Finally, each movie has zero or more quotable quotes, each of which is spoken by a particular actor appearing in the movie. Actors are identified by name and date of birth and appear in one or more movies. Each actor has a role in the movie. Directors are also identified by name and date of birth and direct one or more movies. It is possible for a director to act in a movie (including one that he or she may also direct). Production companies are identified by name and each has an address. A production company produces one or more movies.arrow_forwardRead the scenario and answer the questions that follow Scenario You have been tasked to design a database for a new bank. The specifications for the database include: customer details include their name, address, phone, and National Identification number. A national identification number is required for each customer for all account types. A customer’s contact address includes street, city and country as well as two phone numbers (cellphone, office line). One customer can own at least one account and every account is identified by its numbers, type and balance. . A customer may own a savings, cheque or loan account. Questions i. Using an appropriate tool, draw the conceptual diagram for the proposed database. ii. Develop the logical model. iii. Define the physical schema for the proposed database. iv. Write SQL statements to implement the database. v. Populate each of the identified tables with 2 records.arrow_forwardYou have been hired as an intern at the local community center. The center has a number of sports programs for youth. You have been asked to create a database to keep track of the programs and the youths who participate in these sports activities. The Community Center database must support the following requirements:i. For an activity, store its number and name, for example, 051, Track. Each activity has a cost associated with it.ii. For a participant, store his or her number, first name, and last name as well as the name, home telephone number, and cell telephone number of the parent or guardian primarily responsible for the participants.iii. One participant can enroll in many activities, and one activity can include many participants. One parent/guardian can have many participants.Based on these requirements:1. Identify and list the entities and attributes of those entities. 2. Identify and list the functional dependencies. 3. Without creating a set of dependency diagrams, write the…arrow_forward
- Subject: DatabaseIdentify ALL errors and correction on the entity relationship diagram (ERD) given in Figure 5.i. Circle the errors identified on the diagram.ii. For each error identified, correct them. Show your corrections either by redrawing the corrected diagram OR by describing how the errors should be corrected next to the circles that you have identified.arrow_forwardThe project team at University of Kentucky is moving forward with the new Student Grading System. The information system will have three external entities, with the following data flows: Entity Data flow from the Entity Data flow to the Entity Student Tasks Submission Graded Tasks Student Records System Online attendance Final Grade Instructor Grading Parameters Grade Report Moreover, the respective information system will have four subsystems: Establish Gradebook, Assign Final Grade, Grade Student Work Produce Grade Report, and a data store called Gradebook. The data flows are as follows: Data Flow From To Class Roster Student Records System Entity Establish Gradebook Process Final Grade Assign Final Grade Process Student Records System Entity Final Grade Assign Final Grade Process Gradebook Data Store Grading Details Gradebook Data Store Assign Final Grade Process Submitted Work Student…arrow_forwardComputer Science After completing a course in database management, you have been hired as a summer intern by Mountain View Community Hospital. Your first assignment is to work as part of a team of three people to develop a high-level E-R diagram for the hospital. You conduct interviews with a number of hospital administrators and staff to identify the key entity types for the hospital. As a result, your team has identified the following entity types: • CARE CENTER—a treatment center within the hospital. Examples of care centers are maternity, emergency care, or multiple sclerosis center. Each care center has a care center ID (identifier) and a care center name. • PATIENT—a person who is either admitted to the hospital or is registered as an outpatient. Each patient has an identifier, the medical record number (MRN), and a name. The hospital also records the date of first contact with the hospital (Contact Date) • PHYSICIAN—a member of the hospital medical staff who may admit patients…arrow_forward
- The project team at University of Kentucky is moving forward with the new Student Grading System. The information system will have three external entities, with the following data flows: Entity Data flow from the Entity Data flow to the Entity Student Tasks Submission Graded Tasks Student Records System Online attendance Final Grade Instructor Grading Parameters Grade Report Moreover, the respective information system will have four subsystems: Establish Gradebook, Assign Final Grade, Grade Student Work Produce Grade Report, and a data store called Gradebook. The data flows are as follows: Data Flow From To Class Roster Student Records System Entity Establish Gradebook Process Final Grade Assign Final Grade Process Student Records System Entity Final Grade Assign Final Grade Process Gradebook Data Store Grading Details Gradebook Data Store Assign Final Grade Process Submitted Work Student Entity…arrow_forwardExplain how the design would be checked from each role’s perspective, according to the information they require. Use these roles as an example: The administration team needs access to records and permission to update and enter new data. The development teams need to write the expected transactions relatively easily, which might depend on the degree of normalization. The application team needs access to all data to manage the interface.arrow_forwardA department of the university has a small car, which members of staff may use for work purposes. They need a database to keep track of who uses the car and any related expenses Design a database for recording the information on the staff member who books the departmental car and the date booked and returned, the car mileage and any claims for the fuel, parking and similar related expenses Create an Entity Relation Diagram showing the tables needed and the relationships between tables Create suitable fields for each table and select an appropriate primary key for each table select an appropriate foreign keys to connect the tables. If there is no adequate candidate key create necessary surrogate keys for the appropriate tables. For the tables in figure P3.24 you want to see data on charters flown by either Robert Williams (employee number 105) or Elizabeth Travis (employee number 109) as pilot or copilot, but not charters flown by both of them. Complete Items 3-5 to find this…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Principles of Information Systems (MindTap Course...Computer ScienceISBN:9781285867168Author:Ralph Stair, George ReynoldsPublisher:Cengage Learning
Database Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781305627482Author:Carlos Coronel, Steven MorrisPublisher:Cengage Learning
A Guide to SQLComputer ScienceISBN:9781111527273Author:Philip J. PrattPublisher:Course Technology Ptr
Principles of Information Systems (MindTap Course...
Computer Science
ISBN:9781285867168
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781305627482
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
A Guide to SQL
Computer Science
ISBN:9781111527273
Author:Philip J. Pratt
Publisher:Course Technology Ptr