Principles of Information Systems (MindTap Course List)
13th Edition
ISBN: 9781337516945
Author: STAIR
Publisher: Cengage
expand_more
expand_more
format_list_bulleted
Videos
Textbook Question
Chapter 12, Problem 3PSE
A new sales ordering system needs a relational
Expert Solution & Answer
Trending nowThis is a popular solution!
Students have asked these similar questions
Draw ER (or EER) diagram: A conceptual database design for a chain of furniture stores is needed. The following is a summary of the database requirements:
a) The chain has many different stores in various cities and states. Each STORE has unique StoreNumber, plus an Address(made up of Street, City, State, ZipCode), and a StoreManager (who is an employee). Each store is organized into a number of departments.
b) Each DEPARTMENT contains certain types of furniture (such as ‘dining’, ‘living room’, ‘bedroom’, ‘office’, etc.), and has a DeptName that is unique within each store; it also has a DeptManager (who is an employee), and a number of SalesPersons (who are employees).
c) The company employs many employees. Each EMPLOYEE has a unique SSN, plus a Name (made up of FirstName, Minit, LastName), a job (e.g. ‘store manager’, ‘dept manager’, ‘sales associate’, ‘sales person’, etc.), plus DateOfBirth, Sex, Salary, and CommissionRate. Each employee works for a particular store.
Design an ER…
Design and draw an ER diagram that captures the information about the university. Consider thefollowing information about a university database: 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 startingdate, an ending date, and a budget. Graduate students have an SSN, a name, an age, and a degreeprogram (e.g., M.S. or Ph.D.). Each project is managed by one professor (known as the project’sprincipal investigator). Each project is worked on by one or more professors (known as theproject’s co-investigators). Professors can manage and/or work on multiple projects. Each projectis worked on by one or more graduate students (known as the project’s research assistants). Whengraduate 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 (potentiallydifferent) supervisor for each one. Departments have a…
Design E-R diagram for a database of an Airline-System. The database must keep
track of Customers and their Reservations, Flights and their status, Seat assignments
on individual flights, and the Schedule and Routing of future flights. Your design
should include primary-key and foreign-key.
Chapter 12 Solutions
Principles of Information Systems (MindTap Course List)
Ch. 12.2 - Outline the tasks that must be accomplished to...Ch. 12.2 - Following your discussion, one of the team members...Ch. 12.2 - There is likely to be some confusion over the role...Ch. 12.2 - Prob. 2CTQCh. 12.3 - Prob. 1RQCh. 12.3 - Prob. 2RQCh. 12.3 - Prob. 1CTQCh. 12.3 - What other potential problems can you anticipate...Ch. 12.4 - Prob. 1RQCh. 12.4 - Prob. 2RQ
Ch. 12.4 - Prob. 1CTQCh. 12.4 - A safety-critical system is one whose failure or...Ch. 12 - Prob. 1SATCh. 12 - _______________ software can provide a better...Ch. 12 - Prob. 3SATCh. 12 - Prob. 4SATCh. 12 - The purpose of the system investigation phase is...Ch. 12 - ______________ is a diagram used to document the...Ch. 12 - The overall emphasis of the __________ phase is on...Ch. 12 - The primary tool for assessing the software...Ch. 12 - Prob. 9SATCh. 12 - Prob. 10SATCh. 12 - Prob. 11SATCh. 12 - Prob. 12SATCh. 12 - A preliminary evaluation of software packages and...Ch. 12 - Prob. 1RQCh. 12 - Prob. 2RQCh. 12 - Prob. 3RQCh. 12 - Prob. 4RQCh. 12 - Prob. 5RQCh. 12 - What are the key elements of a system...Ch. 12 - Prob. 7RQCh. 12 - Prob. 8RQCh. 12 - Prob. 9RQCh. 12 - Prob. 10RQCh. 12 - Prob. 11RQCh. 12 - Prob. 12RQCh. 12 - Prob. 13RQCh. 12 - Prob. 14RQCh. 12 - An organization has selected and is now...Ch. 12 - Prob. 1DQCh. 12 - Thoroughly discuss the pros and cons of buying...Ch. 12 - Prob. 3DQCh. 12 - Prob. 4DQCh. 12 - Prob. 5DQCh. 12 - Prob. 6DQCh. 12 - Prob. 7DQCh. 12 - Define the Pareto principle, and discuss how it...Ch. 12 - Prob. 9DQCh. 12 - Prob. 10DQCh. 12 - Prob. 11DQCh. 12 - Prob. 12DQCh. 12 - Identify and briefly discuss four key tasks...Ch. 12 - A new sales ordering system needs a relational...Ch. 12 - Prob. 2TACh. 12 - You and your team have been hired to perform a...Ch. 12 - Prob. 1WECh. 12 - Prob. 2WECh. 12 - Do research to determine the current level of...Ch. 12 - Prob. 1CECh. 12 - Prob. 2CECh. 12 - Identify an information system frequently employed...Ch. 12 - It is perhaps not surprising that Etsy was an...Ch. 12 - Prob. 2CTQ1Ch. 12 - What would be some of the criteria you would use...Ch. 12 - Prob. 1CTQ2Ch. 12 - Prob. 2CTQ2Ch. 12 - Prob. 3CTQ2
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.Similar questions
- Using a graphics program, develop an entity-relationship diagram for a database application for an Internet bookstore where students buy textbooks from a salesperson and receive invoices for their purchases. Use Figure 5.5 as a guide.arrow_forwardDesign a database for a worldwide package delivery company (e.g., DHL or FedEx). The database must be able to keep track of customers who ship items and customers who receive items; some customers may do both. Each package must be identifiable and trackable, so the database must be able to store the location of the package and its history of locations. Locations include trucks, planes, airports, and warehouses. Your design should include an E-R diagram, a set of relational schemas, and a list of constraints, including primary-key and foreign-key constraints.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_forward
- Draw the ER diagram based on the following specification. A tutorial school is using a database to manage information about teachers, courses, and students. Each teacher is identified by staff_id, has a name, an email address, and a phone number. Each student is identified by student_id, has a name, an email address, and a registration date. Each course is identified by course_id, year, and semester. In addition, each course has a name. Each course is associated with multiple lessons. A lesson has a lesson number, a location, a date, a start-time, and an end-time. Lesson numbers are sequentially numbers, starting from 1, generated separately for each course. Each teacher teaches at least one course. Each student takes at least one course. Each course is taught by one teacher. Each course can be taken by many students.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_forwardCreation of the database diagram (graphical presentation of tables and their relationships)arrow_forward
- In the ER diagram for a Point of Sale system, there are entities such as Cashier, Product,Checkout, Transaction, CheckoutStand, Return, Inventory, etc. Here inventory records each storagelocation and its capacity. Sometimes, a customer may need to come back to pickup their items afterchecking out while most of the time they leave the store with their purchases. Which of the following is thebetter design for manage transactions?A) Add an attriute to transaction to indicate whether goods have been pickuped or notB) Create two subtyeps of TransactionC) Create a weak entity Pickup to link with TransactionD) Add a relationship between Transaction and Productarrow_forwardb) An ER/EER diagram modeling your database (use appropriate symbols, and don’t forgetassociative entities where appropriate). This will be based on the business rules you created, somake sure you’ve written clear rules! (30 points)• Feel free to use an appropriate design tool you would like for your ER diagram (e.g.http://draw.io), or do it by hand and scan it in; just make sure it is legible and that itfollows the notation/style taught in class. Do NOT use other styles, such as “Visio”notation that includes PK/FK.c) A list of normalized relations (using the notation from class) that is based on your ER diagram.Be sure to include foreign keys, etc. (30 points)arrow_forwardChange the following Use Case to Sequence diagram ID: UC001 Actors: Professors Preconditions: Professors must be in registration page Flow of events: 1. Professor uploads the CV in the CV field 2. Professor add other personal information Postconditions: The system create new customer account, and stored all the user's information in the database Use case: add CV and personal informationarrow_forward
- Design a database for an airline. The database must keep track of customers and theirreservations, flights and their status, seat assignments on individual flights, and the scheduleand routing of future flights. Your design should include an E-R diagram, a set of relationalschemas, and a list of constraints, including primary-key and foreign-key constraints.arrow_forwardDesign an E-R diagram for a database for an airlines system. The database must keep track of customers and their reservations, flights and their status, seat assignments on individual flights and the schedule and routing of future flights. Apply all the database design constraints as much as possible.arrow_forwardCreate an ER diagram for the following requirements:You are asked to design a database to store music album information. A simplified set of requirementsare provided below.- A music album has a title, year of release, total running time, one or more artists, and list ofsongs.- Each song has a lead artist and may have a list of additional artists. Each song has a list of otherassociated people such as mixer, mix engineer, keyboards, guitar, etc. Each song has a genre,running time, and lyrics. Each song can be associated with many albums, but needs to beassociated with at least one.- Each person has a first name, last name, and nickname.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Fundamentals of Information SystemsComputer ScienceISBN:9781337097536Author:Ralph Stair, George ReynoldsPublisher:Cengage Learning
Principles of Information Systems (MindTap Course...Computer ScienceISBN:9781305971776Author:Ralph Stair, George ReynoldsPublisher:Cengage Learning
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
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
Fundamentals of Information Systems
Computer Science
ISBN:9781337097536
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning
Principles of Information Systems (MindTap Course...
Computer Science
ISBN:9781305971776
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning
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
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
9.1.2 Software Development Approaches; Author: EIToppo;https://www.youtube.com/watch?v=Z9znuSQ7Sz8;License: Standard YouTube License, CC-BY