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
(a) Explain carefully four ways in which the diagram fails to model the intended world. In each case make sure you contrast the actual meaning with the intended meaning.
(b) Give an entity-relationship diagram, still using two entity types, which correctly models the intended world.
(c) Give a database schema (including primary keys) for the ER diagram which you have given in the previous part.
(d) Is there any part of the ER diagram which is not captured in the schema? How might this aspect be captured in the final database?
You have been asked to design part of a database for a hospital. Thehospital managers provided you with an informal description of theirdata which you can find on the next page in Figure 1.(a) Provide an Enhanced Entity-Relationship Model for the hospital’s data model (Figure 1) in form of a diagram in Chen notation. Identify special attributes (including keys) in the diagramand include participation and cardinality constraint annotationsfor your relationships.List and explain any additional assumptions you think you haveto make because the specification was unclear or incomplete.Note that there should not be many such extra assumptions.Marking CriteriaThe following criteria will be used to mark your model:• extent to which your model is correct, minimal (no featuremodelled twice), complete and expressive• correct use of Chen notation (including special attributes)• correct cardinality and participation constraints (includingnotation)• readability and presentation of your answer. You…
Make an Entity relationship diagram and use the Erdplus and apply these requirments
Using the Erdplus(use it to make this diagram, the answer should be as a Diagram)
Q) Create an entity-relationship diagram (ERD) using min-max notation based on the following datarequirements of the University database:1. The university is organized into colleges, and each college has a unique number, unique name, and a particularfaculty member who is the dean of the college. Each college administers a number of academic departments.2. Each department has a unique name, a unique code number, and a particular faculty member who chairs thedepartment. We need to keep track of the start date when that faculty member began chairing the department.In addition, each department may have several faculties and must be administered by one college.3. A department offers several courses, each of which has a unique course name, a unique code number, a courselevel (Level: this can be coded as 1 for freshman level, 2…
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
- Draw a entity relationship diagram (ERD) for the following situation: The State of Georgia is interested in designing a database that will track its researchers. Information of interest includes, researcher name, title, position, university name, location, enrollment, and research interests. Each researcher is associated with only one institution and each researcher has several research interests.arrow_forwardKindly go through this. The database development starts with the requirements analysis. There are many sources for gathering requirements. One of the important sources for requirements is “user interview”. During these interviews, users are asked about what kind of a system they need. Then requirements gathered from the interviews are transformed into a data model. Assume that a database designer made an interview and created an E-R diagram as above. Write a scenario that the user described requirements as in the Library Management System case study in Chapter 3.3 of Sharma et al. (2010, p. 77) during the interview - 3.3 A case study involving a Library Management System - This case study describes a simple Library Management System. Assume the requirements for the system were written by your client exactly in these terms:"The system will manage author's and loaner's information, and keep track of books loaned. The borrower's information includes name, address, e-mail, and phone. The…arrow_forwardAlso, develop a model of the proposed database systems using the Entity Relationship (E-R) model for the organization showing all relationships. Ensure to label all relationshipsadequately, describing each relationship provided in ER diagram. In addition, write in standard notation one table from your ER diagram utilizing two record. Please to answer those 2 sub-part according to the first set of questions. Can you also give a more detailed info, I need a lot of information. 3 pages if possible, to pick, choose and refuse from.arrow_forward
- Translate the E-R diagram on page 1 (diagram) to database schema using MySQL Workbench (export as png or pdf). You can ignore the cardinalities on the ternary (Grant) relationship. Interpret the database schema on slide 4. Draw the E-R diagram underlying this schema. No need to draw the attributes.arrow_forwardPlease give me the answer with proper explanation and step by step solution. Qns: draw ERD ( ER diagram ) ------ Design database schema and create database user “ pointOfSal” that contain database schema tables with itsrelated relationships and database constraints 2) Grant the pointOfSal user all privileges that needed by database designer and developer to create database schema 3) The system must contain tables such as category(catNo,catogeryName) ,Items(itemNo,ItemName,Price,total_quantity, catNo),Items_stor_entry(entry_no number primary key,itemNo,entry_date ,quantity), Employee (employeeNo,employeeName,job) ,branch(No,Name), Customer(customerNo,costomerName,gender) , ,Invoice (employeeNo,customerNo,total price ,invoiceNo,InvoiceDate,branchNo ) InvoiceDeatail contain List Of Purchase Items contain detail information related to the invoice (invoiceNo,ItemNo, paidPrice, quantity) . create getItemTotalPrice function which to return quantity*paidPrice .arrow_forward2. Draw an ER diagram for FOOTBALL TOURNAMENT DATABASE that captures given below requirements. Specify key attribute(s) of each entity set. Assume any relationship among entities, and specify cardinality ratio.[ 3 Marks] a. For TEAM entity, the system maintains TID, Team_Name, and City. Every Team has a unique team id. b. PLAYER details are recorded as PID, {Player_Name(Fname, Midname, Lname)}, Position, and TID. Both PID and TID store unique value for each player. c. The SCHEDULE entity contains the details as MID, DateTime, Day, Stadium, and TID. Both Match ID and TID have a unique value assigned to it.arrow_forward
- An objective of this task is to denormalize a conceptual schema to speed up processing of a given class of applications. The following conceptual schema represents a database domain where the contract and permanent employees are assigned to the projects. (see image below) Requirements Steps Involved: - Elimination of generalization using Association, Subset or Superset method - Simplifications: •Elimination of association classes •Elimination of link attributes •Elimination of many-to-many associations Perform simplification of the conceptual schema above and re-draw the simplified conceptual schema.arrow_forwardCreate an ER diagram that correctly describes the database for exams at Campus in Bäcksvängen in accordance with the following description: (Own assumptions must be clearly described.) Staff for various functions are involved in the exams. All staff have a full name and a unique staff code. Some people are examiners on one or more courses. A course has one name and one unique ladok code. For a course, you can add up its points based on the associated elements. One part is part of a course (for example an exam, a laboratory or project). A course can have several different parts. An element has a name, a description, a torque code, one point and two or more grades (eg: U, G, VG). An element can only belong to one course. Since the database is to process the exams, it is obvious that a part like described as an examination has an examination opportunity that is identified, among other things, by the date, start time, end time and that it is possible to calculate total writing time. A…arrow_forwardPlease read this carefully and Draw an EER diagram for a database of a hospital following these requirements: create Four to five regular strong entities. A union One 1:1, one 1:N, and one N:M relationship – of which at least one relationship should be partial and one full. One overlap relationship and one disjoint relationship. Other notes: Do not emphasize on too many attributes for the entities. Two to three attributes for each entity will be enough. Make sure to include a primary key for each entity.arrow_forward
- Subject - Fundamentals to Database Question 4 An entity-relationship diagram (ERD) is a specialized graphic that illustrates the relationships between entities in a database. ERD often use symbols to represent three different types of information. Draw the ERD for the following scenario: (a) Each lecturer is identified by a uniqie number, name and phone. A lecturer teaches several courses and for each course there us a unique code and title. There might be several be several lecturers in a course. (b) A university where a student may take many courses employs lecturer. Each lecturer teach one or more course but no course is taught by more than one lecturer. Each student has to complete two or three assignments for each course. (c) A car rent company wishes to create a database about its activities. The company has a number of vehicles. Each vehicle is of certain model. A customer can rent only one vehicle at a time. Every vehicle must be checked by an employee to make sure it is in…arrow_forwardAssume that you have to design a databaseto manage books issued by your universitylibrary. Attributes for a book include bookidentification number, book title, author,ISBN, publisher, edition, and stock. Identifythe primary key for this entity. What attributes would be associated with other entitiesand used as foreign keys?arrow_forwardA public sector hospital wants to automate its manual paper based operations to speed up the operations and facilitate its patients and staff members. For this purpose, they want to develop a database for their hospital management system to remove paper based records. Now, you are required to analyze the following scenario very carefully and draw entity relationship diagram (ERD) for the given system by identifying entities, attributes and relationship among these entities. A hospital consists of various specialized wards where each ward has its unique ID, name and capacity (total number of beds for patients in each ward). Multiple patients can be admitted in each ward on the recommendations of the doctor. Each doctor has a unique id, name, specialization and etc. Furthermore, a specialized team of doctors in each ward will take care of admitted patients and suggest treatment for the patients (such as medication, recommended tests, date of admission, and date of discharge). Each ward…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
Fundamentals of Information SystemsComputer ScienceISBN:9781305082168Author:Ralph Stair, George ReynoldsPublisher: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
Fundamentals of Information Systems
Computer Science
ISBN:9781305082168
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning
A Guide to SQL
Computer Science
ISBN:9781111527273
Author:Philip J. Pratt
Publisher:Course Technology Ptr