Fundamentals of Information Systems
9th Edition
ISBN: 9781337097536
Author: Ralph Stair, George Reynolds
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Textbook Question
thumb_up100%
Chapter 8, Problem 3PSE
A new sales ordering system needs a relational
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents 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 an ER diagram for keeping track of information about votes taken in the U.S. House of Representatives during the current two-year congressional session.
The database needs to keep track of each U.S. STATE’s Name (e.g., Texas, New York, California) and includes the Region of the state (whose domain is {Northeast, Midwest, Southeast, Southwest, West}).
Each CONGRESSPERSON in the House of Representatives is described by their Name, and includes the District represented, the StartDate when they were first elected, and the political Party they belong to (whose domain is {Republican Democrat, Independent, Other}).
The database keeps track of each BILL (i.e., proposed law), and includes the BillName, the DateOfVote on the bill, whether the bill PassedOrFailed (whose domain is {YES,NO}), and the Sponsor (the congressperson(s) who sponsored--i.e., proposed--the bill).
The database keeps track how each congressperson voted on each bill (domain of vote attribute is {Yes, No, Abstain,…
Design 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.
Chapter 8 Solutions
Fundamentals of Information Systems
Ch. 8 - Identify the pros and cons associated with both...Ch. 8 - Prob. 2LOCh. 8 - Identify and state the goal of each of the six...Ch. 8 - Prob. 4LOCh. 8 - Prob. 5LOCh. 8 - Prob. 6LOCh. 8 - Prob. 7LOCh. 8 - Prob. 8LOCh. 8 - Prob. 9LOCh. 8 - Prob. 10LO
Ch. 8 - Prob. 11LOCh. 8 - Prob. 12LOCh. 8 - Identify the key factors to be considered in...Ch. 8 - Prob. 1.1RQCh. 8 - Prob. 1.2RQCh. 8 - How would you go about selecting and recruiting...Ch. 8 - What do you think might be the biggest harriers to...Ch. 8 - Prob. 2.1RQCh. 8 - Following your discussion, one of the team members...Ch. 8 - There is likely to be some confusion over the role...Ch. 8 - What other potential problems can you anticipate...Ch. 8 - Prob. 3.1RQCh. 8 - Prob. 3.2RQCh. 8 - Prob. 3.1CTQCh. 8 - A safety-critical system is one whose failure or...Ch. 8 - Prob. 1SATCh. 8 - Prob. 2SATCh. 8 - Prob. 3SATCh. 8 - Prob. 4SATCh. 8 - The purpose of the system investigation phase is...Ch. 8 - Prob. 6SATCh. 8 - The overall emphasis of the ___________ phase is...Ch. 8 - The primary tool for assessing the software...Ch. 8 - Prob. 9SATCh. 8 - Prob. 10SATCh. 8 - Prob. 11SATCh. 8 - Prob. 12SATCh. 8 - A preliminary evaluation of software packages and...Ch. 8 - Prob. 1RQCh. 8 - Prob. 2RQCh. 8 - Prob. 3RQCh. 8 - Prob. 4RQCh. 8 - Prob. 5RQCh. 8 - What are the key elements of a system...Ch. 8 - Prob. 7RQCh. 8 - Prob. 8RQCh. 8 - Prob. 9RQCh. 8 - Prob. 10RQCh. 8 - Prob. 11RQCh. 8 - Prob. 12RQCh. 8 - Prob. 13RQCh. 8 - Prob. 14RQCh. 8 - An organization has selected and is now...Ch. 8 - Prob. 1DQCh. 8 - Thoroughly discuss the pros and cons of buying...Ch. 8 - Prob. 3DQCh. 8 - Prob. 4DQCh. 8 - Prob. 5DQCh. 8 - You have been assigned to write a newspaper report...Ch. 8 - Prob. 7DQCh. 8 - Define the Pareto principle, and discuss how it...Ch. 8 - Prob. 9DQCh. 8 - Prob. 10DQCh. 8 - Prob. 11DQCh. 8 - Prob. 12DQCh. 8 - Identify and briefly discuss four key tasks...Ch. 8 - Prob. 1PSECh. 8 - Prob. 2PSECh. 8 - A new sales ordering system needs a relational...Ch. 8 - Prob. 1WECh. 8 - Prob. 2WECh. 8 - Do research to determine the current level of...Ch. 8 - Prob. 1CECh. 8 - Perform research to learn what is required to have...Ch. 8 - Identify an information system frequently employed...Ch. 8 - It is perhaps not surprising that Etsy was an...Ch. 8 - Prob. 1.2CSCh. 8 - What would be some of the criteria you would use...Ch. 8 - Prob. 2.1CSCh. 8 - Prob. 2.2CSCh. 8 - Prob. 2.3CS
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
- 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…arrow_forwardDesign 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.arrow_forwardUsing the context diagram, create a data flow diagram.arrow_forward
- Change 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_forwardDraw 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_forwardWhat are the most important differences between a data item and a data property from the point of view of the data hierarchy? When it's said that a characteristic has reach, what exactly does that mean?arrow_forward
- No external sources may establish a direct link to the database. It's a consideration for any data flow diagram creators out there. What does this suggestion imply?arrow_forwardMapping this class diagram to a relational database during the design phase of the Software development (don't draw ER diagram, Just tables)arrow_forwardProject Synopsis: DATABASE MANAGEMENT:ABC Walk-in Clinic is located in a large metropolitan city in Canada. The clinic staff consists of ten doctors, six nurses, five office secretaries, two administrative assistants and one manager. First time Patients have to visit the clinic personally and fill a registration form that contains their personal and health related information. An office secretary would then enter that information in the computer based information system. Patients may become a permanent patient (at any time) for one of the doctors at the clinic by filling up necessary forms (they are called enrolled patients) or they may choose to come walk-in for every visit. (They usually called walk-in patients) Enrolled Patients may book their appointments online or by calling, the office and one of the secretaries would then book their appointment with their doctor on a particular day/time. Any booked appointment may be cancelled up to 24 hours in advance after which the clinic…arrow_forward
- b) 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_forwardTask 1: ER diagram for give scenario Consider building a database for a shopping mall with requirements as follows: Each product of the shopping mall has a unique project No, and also has a name, a supplier name, a category, a purchase price and a selling price. Products need to be supplied from suppliers. Each product has one supplier, but a supplier may supply many products for the shopping mall. Each supplier has a supplier name and address. A purchase order for product from a supplier has a unique order No, and a date. The order specifies one or more products and their quantities required for a product. A sales order for product to customers has a unique order No, and a date. The order specifies one or more products and their quantities required for a product The shopping mall has warehouses. Each warehouse has a warehouse number, an address and a contact phone number. Each warehouse has shelves to store products. Each shelf has a shelf-number and a capacity. The shelf…arrow_forwardIn 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_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Principles of Information Systems (MindTap Course...Computer ScienceISBN:9781305971776Author:Ralph Stair, George ReynoldsPublisher:Cengage Learning
Principles of Information Systems (MindTap Course...
Computer Science
ISBN:9781305971776
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning
9.1.2 Software Development Approaches; Author: EIToppo;https://www.youtube.com/watch?v=Z9znuSQ7Sz8;License: Standard YouTube License, CC-BY