Principles of Information Systems (MindTap Course List)
13th Edition
ISBN: 9781305971776
Author: Ralph Stair, George Reynolds
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Concept explainers
Expert Solution & Answer
Chapter 4.3, Problem 2RQ
Explanation of Solution
Reasons for Walmart insisting on a “one size fits all” approach:
- To guarantee that every suppliers access the data in the same method and all information will be well-matched with each other...
Expert Solution & Answer
Trending nowThis is a popular solution!
Students have asked these similar questions
What is wrong with the following designs from the perspective of cohesion, and what could be done to improve them?
There are two subsystems in a university registration system that do the following. Subsystem A displays lists of courses to a student, accepts requests from the student to register in courses, ensures that the student has no schedule conflicts and is eligible to register in the courses, stores the data in the database and periodically backs up the database. Subsystem B allows faculty members to input student grades, and allows administrators to assign courses to faculty members, add new courses, and change a student registration. It also prints the bills that are sent to students.
In an electronic commerce application, a module is created to add books to the ‘shopping basket’ and perform such operations as computing the total amount the customer owes. A second module adds ‘special reward’ merchandise to the shopping basket; this module also displays the contents of the…
Consider a school system in which data is recorded about the movie industry. The data requirements are summarized as follows:
Each subject is owned by a department and each department ismanaged by a teacher, called Head of Department (HOD). Eachdepartment has a name and a unique code number. Each subjecthas a name, unique number and credit value. All teachers have aunique ID. A HOD cannot manage more than one department at atime. Also, a HOD does not teach subjects. A subject cannot betaught by more than one teacher. Finally, the system needs toknow each student’s contact details, including, full name, studentID, address, age and gender, as well as date of enrolment in thesubject.
Design an Entity-Relationship diagram for the movie database
Q1: What is wrong with the following designs from the perspective of cohesion, and what could be done to improve them?
(a) There are two subsystems in a university registration system that do the following. Subsystem A displays lists of courses to a student, accepts requests from the student to register in courses, ensures that the student has no schedule conflicts and is eligible to register in the courses, stores the data in the database and periodically backs up the database. Subsystem B allows faculty members to input student grades, and allows administrators to assign courses to faculty members, add new courses, and change a student registration. It also prints the bills that are sent to students.
¬
(b) In an electronic commerce application, a module is created to add books to the ‘shopping basket’ and perform such operations as computing the total amount the customer owes. A second module adds ‘special reward’ merchandise to the shopping basket; this module also displays the…
Chapter 4 Solutions
Principles of Information Systems (MindTap Course List)
Ch. 4.1 - Prob. 1RQCh. 4.1 - Prob. 2RQCh. 4.1 - Prob. 1CTQCh. 4.1 - Prob. 2CTQCh. 4.2 - Prob. 1RQCh. 4.2 - Prob. 2RQCh. 4.2 - Prob. 1CTQCh. 4.2 - Prob. 2CTQCh. 4.3 - Prob. 1RQCh. 4.3 - Prob. 2RQ
Ch. 4.3 - Prob. 1CTQCh. 4.3 - Prob. 2CTQCh. 4.4 - What is the primary difference between purchasing...Ch. 4.4 - What are the pros and cons of using open-source...Ch. 4.4 - What risks and start-up issues are associated with...Ch. 4.4 - Prob. 2CTQCh. 4 - Prob. 1SATCh. 4 - Prob. 2SATCh. 4 - Prob. 3SATCh. 4 - Prob. 4SATCh. 4 - Prob. 5SATCh. 4 - Prob. 6SATCh. 4 - Prob. 7SATCh. 4 - Prob. 8SATCh. 4 - Prob. 9SATCh. 4 - Prob. 10SATCh. 4 - ______ is software that makes its source code...Ch. 4 - Software ______ are an important source of...Ch. 4 - Identify and briefly discuss the three spheres of...Ch. 4 - Prob. 2RQCh. 4 - Prob. 3RQCh. 4 - What is the kernel of the operating system?Ch. 4 - Prob. 5RQCh. 4 - Prob. 6RQCh. 4 - Prob. 7RQCh. 4 - Prob. 8RQCh. 4 - Prob. 9RQCh. 4 - Distinguish between proprietary software and...Ch. 4 - Prob. 11RQCh. 4 - Prob. 12RQCh. 4 - Prob. 13RQCh. 4 - Prob. 14RQCh. 4 - Prob. 15RQCh. 4 - Prob. 16RQCh. 4 - Prob. 1DQCh. 4 - Assume that you must take a computer-programming...Ch. 4 - Prob. 3DQCh. 4 - Prob. 4DQCh. 4 - Prob. 5DQCh. 4 - Prob. 6DQCh. 4 - Prob. 7DQCh. 4 - Prob. 8DQCh. 4 - Prob. 9DQCh. 4 - Prob. 10DQCh. 4 - Prob. 1PSECh. 4 - Prob. 2PSECh. 4 - Prob. 3PSECh. 4 - Prob. 1TACh. 4 - Prob. 1WECh. 4 - Do research on the Web to learn which programming...Ch. 4 - Prob. 3WECh. 4 - Prob. 1CECh. 4 - Prob. 2CECh. 4 - Think of your ideal job. Identify two existing...Ch. 4 - Prob. 1CTQ1Ch. 4 - Prob. 2CTQ1Ch. 4 - Prob. 3CTQ1Ch. 4 - Prob. 1CTQ2Ch. 4 - Prob. 2CTQ2Ch. 4 - 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
- a)Briefly explain the benefits that can be achieved from a high-quality Requirement Engineering Process? b) Shortcomings in requirement practices pose many risks, creeping user requirements is one of these risks. How this risk can be managed? c) Write the FURPS+ category of the following requirements. i. The Persistence will be handled by a relational database ii. A chemist who has never used the Chemical Tracking System before shall be able to place a request for a chemical correctly with no more than 30 minutes of orientationarrow_forward1. PART (40%): Evaluation and optimization:A schema of the ski shop information system is given:Customer (cid, name, surname, address, telephone);Employee (eid, name, surname, address, telephone);Purchase (pid, sid, cid, eid, date);Skiis (sid, brand, model, length, hardness)Additional information is given:|Customer| =150 pages, 40 records/page|Employee| = 2 pages, 40 records/page|Purchase| = 2000 pages, 100 records/page|Skiis| = 250 pages, 30 records/pageBuffer can store up to 2500 pages.Let's assume that the following indices are now set on the schema from the previoustask:- Level 2 B+ index on the attribute Purchase.date- Hash index on the attribute Skiis.sidOur DBMS has the following algorithms to perform the join:- Hash join- Index nested loops join- Sort-merge joinTranslate the following SQL query into relational algebra and find the plan that readsthe fewest pages or blocks:SELECT Skiis.model, Skiis.lengthFROM Skiis JOIN Purchase ON (Skiis.sid = Purchase.sid)WHERE Skiis.brand =…arrow_forwardBIIT software house wants to maintain a database of its employees, projects assigned to employees and accounts. Database schema is given below.1- EMPLOYEE( eid, eName, eAge, eCity, eRank, eDep) 2- PROJECT ( pid, pName, pBonusAmout)3- Project_Allocation ( eid, pid)4- ACCOUNTS ( eid, Year, Month, Basic_Salary, Project_Bonus)5- ACCOUNTS_BACKUP( eid, Year, Month, Basic_Salary, Project_Bonus) 6- LOG( srNo, table_name , Date, Time, event, no_of_rows_effected) Perform following tasks a- Whenever a record is inserted or updated from ACCOUNTS table, it must also be inserted / updated in ACCOUNT_BACKUP table as well. Do not allow user to delete any record from ACCOUNTS or ACCOUNTS_BACKUP table. On insertion in ACCOUNTS table, Project_Bonus will be calculated by system on the basis of projects assigned to employee. b- Make sure primary foreign keys must not violate in any table. You must use triggers to apply any type of constraints. All keys are mentioned at the end. c- LOG table will maintain…arrow_forward
- a) Suppose that You have gotten a job planning databases for the European Union. Yourfirst on job assignment is to help the various countries maintain information about theirinhabitants. Your model should capture the following information:• In each country, there are provinces, which contain towns. There cannot be twoprovinces with the same name in a single country. Similarly, there cannot be two townswith the same name in a single province.• People live in towns. Men and women work in a town. Children learn in a school in atown.• A person can be a man, a woman, or a child, and has a first-name, last-name, id, andbirthday.Children are any people under the age of 18.• A man can be married to a woman (polygamy is not allowed, i.e., one man can bemarried only to one woman). Although the Pope strongly disapproves, divorce, andsubsequent remarriage, is possible.• For each marriage, store the date of the marriage and information about who are thechildren of the married couple. You should…arrow_forwardTake, for example, the database of a major airline company that bases its data management on snapshot isolation. What type of circumstances would need to take place before an airline would be prepared to tolerate a nonserializable execution in exchange for enhanced overall performance?arrow_forward1.13) The implicit goals of the design activity are information preservation and minimum redundancyTrue False 1.14) Update anomalies are known as insertion anomalies, deletion anomalies, and modification anomaliesTrue False 1.15) A well-designed database can handle both OLTP and OLAP operations efficientlyTrue False 1.16) Database engine uses statistics to generate estimated execution plans then picks the best oneTrue False arrow_forward
- Air-india want to create database to stores details about an airline’s fleet, flights, and seat bookings. Again, it’s a hugely simplified version of what a real airline would use, but the principles are the same. Draw an ER diagram based on the information given.Consider the following requirements list: • The airline has one or more airplanes.• An airplane has a model number, a unique registration number, and the capacity to take at most 100 passengers.• An airplane flight has a unique flight number, a departure airport, a destination airport, a departure date and time, and an arrival date and time.• Each flight is carried out by a single airplane.• A passenger has given names, a surname, and a unique email address.• A passenger can book at most 5 seats on a flight.[7](b) Convert the diagram 1(a) in relational model.arrow_forwardA private bank, for instance, Bank Podo, has several branches in numerous American cities. The strategy of Bank Podo emphasizes consumers in distant places, where infrastructural challenges, such as Internet access, are unavoidable. However, given Bank Podo's aim is to serve the archipelago, infrastructural limitations are not a barrier to service delivery. The IT Division decided to construct a distributed database in which each branch has its own database that maintains data especially for that branch, i.e., each branch has its own database. Despite the fact that the databases are independent, each branch may access (share) the data of other branches, giving the impression to the user that all databases are a single entity; this is known as distribution transparency. We are experienced with difficulties such as fragmentation, allocation, and replication in distributed databases. What sorts of difficulties does Podo Bank contain? What form of fragmentation is used when a customer…arrow_forwardDraw ER Diagram & Schema Diagram ================================ ER Diagram Description... During COVID-19 pandemic, it is not safe for the people to go out frequently for their daily needs. Similarly, people cannot live without their daily needs. ‘Online Sheba’ can minimize the suffering of people. ‘Online Sheba’ provides food delivery, emergency medicine delivery, laundry and grocery delivery. Besides, ‘Online Sheba’ provides courier services also. In this case, you have to build database management system for ‘Online Sheba’ to handle all the services it provides and to store all information related to ‘Online Sheba’ securely, like employee, customer, safety vehicle, shops, seller, receiver information. ‘Online Sheba’ provides few home services, food delivery, emergency medicine delivery, laundry, grocery delivery & courier service. Therefore, it must have few employees to initiate all the work. As COVID-19, safety issue is a very important factor; every employee must have a…arrow_forward
- B.The Hudson Engineering Group (HEG) has contacted you to create a conceptual model whose application will meet the expected database requirements for the company's training program. The HEG administrator gives you the following description of the training group's operating environment. (Hint: Some of the following sentences identify the volume of data rather than cardinalities. Can you tell which ones?) The HEG has 12 instructors and can handle up to 30 trainees per class. HEG offers 5 Advanced Technology courses, each of which may generate several classes. If a class has fewer than 10 trainees, it will be canceled. Therefore, it is possible for a course not to generate any classes. Each class is taught by one instructor. Each instructor may teach up to 2 classes or may be assigned to do research only. Each trainee may take up to 2 classes per year. Given that information, do the following: Define all of the entities and relationships. (Use Table 4.4 as your guide.) Describe…arrow_forwardYou are one of the team members who your project team leader has assigned to involve in the discussion of developing an Automated Teller Machine (ATM) system. Throughout the discussion, you have gathered the following requirements statement for the ATM system from your clients' team members. The IT personnel from your client’s team need to understand the structure of your database and the interaction between the actor(s) or object(s) in the system. Therefore, you have instructed your System Analyst to provide the structural and behavioural modelling of the ATM system based on the requirements statement you gathered, as shown below : AutomatedTellerMachine The software to be designed will control a simulated Automated Teller Machine (ATM) having a magnetic stripe reader for reading an ATM card, a customer console (keyboard and display) for interaction with the customer, a slot for depositing envelopes, a dispenser for cash (in multiples of $20), a printer for printing customer…arrow_forwardClients can expect to see a 10% improvement in NIMO database development labor spending through which of the following? a) Use of DevSecOps b) Using operators and container platform capabilities in parallel c) Faster provisioning of standardized environment d) Elimination of costly overhead of database configuration e) Containerization of workloadsarrow_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