Fundamentals of Information Systems
9th Edition
ISBN: 9781337097536
Author: Ralph Stair, George Reynolds
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Question
Chapter 5, Problem 7LO
Program Plan Intro
Transaction processing systems associated with the order processing, purchasing and accounting business functions.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
Parts( pid, name, price);
Projects( jid, name, company, budget, start, duration );
Suppliers sid, name, address, phone );
Orders oid, pid, jid, sid, quantity, amount, date, comment );
Data environment
The most important tables of the Faculty Information System are as follows.
Course (cid, title, tid, description)
Teacher (tid, name, surname, address, phone)
Student (sid, name, surname, address, program, year, phone, descr)
Register(sid, cid,d_register,grade,d_grade)
A course is described by an identifier, a title, an identifier of a teacher that helds the
course, and a text field. A teacher is represented by an identifier, a name and a
surname, an address, and a phone number. A student is described by using an id, a
name and a surname, an address, a study program (string), a year (integer), a phone
number, and a text field. The table Register represents the registrations of students to
courses. Registration is described by a student identifier, a course identifier, the date of
registration (d_register), a grade, and the date of the grade (d_grade).
Data environment IBL
The company Internet Big Library (abbr. IBL) was established in the year 2000. The most
important tables of the IBL information system are as follows.
Books (bid, author, title, publisher, year, notes);
Members (mid, name, surname, street, city, country, birthday, phone, notes);
Borrow (rid, bid, mid, date, notes);
Chapter 5 Solutions
Fundamentals of Information Systems
Ch. 5 - Prob. 1LOCh. 5 - Prob. 2LOCh. 5 - Prob. 3LOCh. 5 - Prob. 4LOCh. 5 - Prob. 5LOCh. 5 - Prob. 6LOCh. 5 - Prob. 7LOCh. 5 - Prob. 8LOCh. 5 - Prob. 9LOCh. 5 - Prob. 10LO
Ch. 5 - Prob. 11LOCh. 5 - Prob. 1.1RQCh. 5 - Prob. 1.2RQCh. 5 - Prob. 1.1CTQCh. 5 - Prob. 1.2CTQCh. 5 - Prob. 2.1RQCh. 5 - Prob. 2.2RQCh. 5 - Prob. 2.1CTQCh. 5 - Prob. 2.2CTQCh. 5 - Prob. 3.1RQCh. 5 - Prob. 3.2RQCh. 5 - Prob. 3.1CTQCh. 5 - Prob. 3.2CTQCh. 5 - Prob. 4.1RQCh. 5 - Prob. 4.2RQCh. 5 - Prob. 4.1CTQCh. 5 - Prob. 4.2CTQCh. 5 - Prob. 1SATCh. 5 - Prob. 2SATCh. 5 - Prob. 3SATCh. 5 - Prob. 4SATCh. 5 - Prob. 5SATCh. 5 - Prob. 6SATCh. 5 - Prob. 7SATCh. 5 - Prob. 8SATCh. 5 - Prob. 9SATCh. 5 - Prob. 10SATCh. 5 - Prob. 11SATCh. 5 - Prob. 12SATCh. 5 - Prob. 13SATCh. 5 - Prob. 14SATCh. 5 - Prob. 15SATCh. 5 - Prob. 16SATCh. 5 - Prob. 17SATCh. 5 - Prob. 18SATCh. 5 - Prob. 1RQCh. 5 - Prob. 2RQCh. 5 - Prob. 3RQCh. 5 - Prob. 4RQCh. 5 - Prob. 5RQCh. 5 - Prob. 6RQCh. 5 - Prob. 7RQCh. 5 - Prob. 8RQCh. 5 - Prob. 9RQCh. 5 - Prob. 10RQCh. 5 - Prob. 11RQCh. 5 - Prob. 12RQCh. 5 - Prob. 13RQCh. 5 - Prob. 14RQCh. 5 - Prob. 15RQCh. 5 - Prob. 16RQCh. 5 - What is source data automation? What benefits can...Ch. 5 - Prob. 1DQCh. 5 - Prob. 2DQCh. 5 - Prob. 3DQCh. 5 - Prob. 4DQCh. 5 - Prob. 5DQCh. 5 - Prob. 6DQCh. 5 - Prob. 7DQCh. 5 - Prob. 8DQCh. 5 - Prob. 9DQCh. 5 - Prob. 10DQCh. 5 - Prob. 11DQCh. 5 - Prob. 12DQCh. 5 - You are a member of the engineering organization...Ch. 5 - Prob. 14DQCh. 5 - Prob. 15DQCh. 5 - Prob. 1PSECh. 5 - Prob. 2PSECh. 5 - Prob. 3PSECh. 5 - Prob. 1WECh. 5 - Prob. 2WECh. 5 - Prob. 3WECh. 5 - Prob. 1CECh. 5 - Prob. 2CECh. 5 - Prob. 3CECh. 5 - Prob. 1.1CSCh. 5 - Prob. 1.2CSCh. 5 - Prob. 1.3CSCh. 5 - Prob. 2.1CSCh. 5 - How important do you think the communication and...Ch. 5 - Prob. 2.3CS
Knowledge Booster
Similar questions
- Data environment IBL The company Internet Big Library (abbr. IBL) was established in the year 2000. The most important tables of the IBL information system are as follows. Books (bid, author, title, publisher, year, notes); Members (mid, name, surname, street, city, country, birthday, phone, notes); Borrow (rid, bid, mid, date, notes);arrow_forwardThe company Internet Big Library (abbr. IBL) was established in the year 2000. The most important tables of the IBL information system are as follows. Books (bid, author, title, publisher, year, notes); Members (mid, name, surname, street, city, country, phone, notes); Borrow (rid, bid, mid, date, notes);arrow_forwardData environment IBL The company Internet Big Library (abbr. IBL) was established in the year 2000. The most important tables of the IBL information system are as follows. Books (bid, author, title, publisher, year, notes); Members (mid, name, surname, street, city, country, birthday, phone, notes); Borrow (rid, bid, mid, date, notes);arrow_forward
- TASK 1: Suppliers Using domain and tuple relational calculus, find: 1. Find the sids of suppliers who supply some red or green part. 2. Find the sids of suppliers who supply some red part or are at „Koprska cesta 25". 3. Find the sids of suppliers who supply every part. 4. Find the sids of suppliers who supply every red part. 5. Find the sids of suppliers who supply every red or green part. 6. Find the pids of parts supplied by at least two different suppliers. Relation Relational schema Suppliers SUPPLIERS(sid, sname, address) Parts PARTS(pid, pname, color) Catalog CATALOG(#sid, #pid, cost)arrow_forwardTASK 2: Airline flight information Using domain and tuple relational calculus, find: 1. Find the eids of pilots certified for some Boeing aircraft. 2. Find the names of pilots certified for some Boeing aircraft. 3. Find the aids of all aircraft that can be used on non-stop flights from Paris to Vancouver. 4. Find the names of pilots who can operate planes with a range greater than 3,000 miles but are not certified on any Boeing aircraft. 5. Find the eids of employees who make the highest salary (multiple employees can have highest salary). Relation Flights Aircraft Certified Relational schema FLIGHTS(flno, from, to, distance, departs, arrives) AIRCRAFT (aid, aname, cruisingrange) CERTIFIED (#eid, #aid) Employees EMPLOYEES(eid, ename, salary)arrow_forwardData environment IBL The company Internet Big Library (abbr. IBL) was established in the year 2000. The most important tables of the IBL information system are as follows. Books (bid, author, title, publisher, year, notes); Members (mid, name, surname, street, city, country, birthday, phone, notes); Borrow (rid, bid, mid, date, notes);arrow_forward
- TASK 3: Airline transportation AIRPORT (IDLE, name, city, country) Relation Relational schema I airport a airplane p lands AIRPLANE (IdTL, type, description, manufacturer) LANDS (#IDLE, #IdTL, dateFrom) Relation LANDS includes information about where each type of an airplane can land, on what airports and since when. Using domain and tuple relational calculus, find: 1. Find all names of the airports, where type B747 airplanes can land. 2. Find all IDLE of airports, on which type B747 or B748 airplanes can land 3. Find all IdLE of airports, which are located in Austria or that type B747 airplane can land on them. 4. Find all IDLE of airports, on which all types of planes can land.arrow_forwardCan you find an example order DFS explores the vertices in the graph included assuming DFS starts at vertex 4. The adjacency lists are in ascending order by the numeric label of the vertices.arrow_forwardPlease original work What is differences between big data and data warehousing, which one is better for analytics, why it is better, and what would you think an example of when it would be a better choice. Please cite in text references and weblinksarrow_forward
- Identify the most applicable web analytics that a B2C (business to consumer) company should be monitoring at its website. Describe three or more metrics, provide a description of each, and explain why you believe they are important?arrow_forwardDiscuss by your own words the following areas of open Source : 1- Open Source Licenses 2- Open Source Projects 3- Adoption Support Models for Open Source 4- Evaluating Open Source Support Providers 5- OPEN SOURCE VS. CLOSED SOURCEarrow_forwardQuestion The radius of an orbit of hydrogen atom is 0.85 nm, the velocity of electron in this orbit is a × 10b m/s, What is the value of b?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
Enhanced Discovering Computers 2017 (Shelly Cashm...Computer ScienceISBN:9781305657458Author:Misty E. Vermaat, Susan L. Sebok, Steven M. Freund, Mark Frydenberg, Jennifer T. CampbellPublisher:Cengage Learning
Fundamentals of Information Systems
Computer Science
ISBN:9781337097536
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning
Enhanced Discovering Computers 2017 (Shelly Cashm...
Computer Science
ISBN:9781305657458
Author:Misty E. Vermaat, Susan L. Sebok, Steven M. Freund, Mark Frydenberg, Jennifer T. Campbell
Publisher:Cengage Learning