Experiencing MIS
8th Edition
ISBN: 9780134792736
Author: KROENKE
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Concept explainers
Expert Solution & Answer
Chapter 2, Problem 7CE
Explanation of Solution
Returning allocated inventory:
- Inventory is allocated for determining if future orders have available inventory.
- The allocated inventory must be returned when an order is rejected due to unapproved credit or special terms.
- The customer will be notified that the order was not approved if credit or special terms are not approved.
- The customer can then resubmit the order and the new credit limit will be checked.
- A notification of the rejected order will be sent to the person who releases the reserved inventory for the order...
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
A college course may have one or more scheduled sections or may not have a scheduled section. Attributes of COURSE include Course ID, Course Name, and Units. Attributes of SECTION include Section Number and Semester ID. Semester ID is composed of two parts: Semester and Year. Section Number is an integer (such as 1 or 2) that distinguishes one section from another for the same course but does not uniquely identify a section. How did you model SECTION? Why did you choose this way versus alternative ways to model SECTION?
Requirement analysis:
Course evaluation must have a student, the students relation contains a unique student id, full name for each student, email address, phone number, address and date of birth.
For each course, the courses contain course id, course name and credit.
Each student can take many courses.
For each Instructor, the instructors contain id, name and email.
Each instructor can instruct many courses.
For each section, the sections contain section id, year and semester.
Students are able to evaluate the current courses.
ER-diagram: Please complete the ER diagram using Microsoft word.
Instructor
ID
Full name
Email
Student
ID
Full name
Email
Phone number
Address
Date of birth
Course
ID
Course title
Description
Credit
Section
ID
Year
Semester
Please Complete the diagram on MS word.
Vacation days are based on status. Using the information in the lower table below, do a lookup in the upper table determine the amount of vacation time earned by each employee.
Status Vacation Time Earned
Full TIme 10
Part Time 7
Contract 0
Employees Status Vacation TIme Earned
John Contract
Jane Part Time
Al Full TIme
Chapter 2 Solutions
Experiencing MIS
Ch. 2.4 - Prob. 1SWCh. 2.4 - Prob. 2SWCh. 2.4 - Prob. 3SWCh. 2.4 - Prob. 4SWCh. 2.4 - Prob. 5SWCh. 2 - Prob. 1EGDQCh. 2 - Prob. 2EGDQCh. 2 - Prob. 3EGDQCh. 2 - Prob. 4EGDQCh. 2 - WHY DOES THE FALCON SECURITY TEAM NEED TO...
Ch. 2 - Prob. 2ARQCh. 2 - Prob. 3ARQCh. 2 - Prob. 4ARQCh. 2 - Prob. 5ARQCh. 2 - Suppose you are discussing 3D printing with the...Ch. 2 - Prob. 2UYKCh. 2 - Prob. 3UYKCh. 2 - Prob. 4CECh. 2 - Prob. 5CECh. 2 - Prob. 6CECh. 2 - Prob. 7CECh. 2 - Prob. 8CECh. 2 - Prob. 9CECh. 2 - Prob. 10CECh. 2 - Prob. 11CECh. 2 - Prob. 13CSCh. 2 - Prob. 14CSCh. 2 - Prob. 15CSCh. 2 - Prob. 16CSCh. 2 - Prob. 17CSCh. 2 - Prob. 18CS
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
- kindly explain the flow of data on the diagram.arrow_forwardConsidering the un-normalized relational table PROJECT below: PROJECT (Project Title, EmpeName, ManagerName, Location, Hours Work, ManagerPhone) The attributes of PROJECT table satisfy the following properties: Each project has many employees, Each employee may involve in one or more projects, Projects are managed by managers; there are many managers in the company, hence a project may be assigned to any one of the managers, but each manager manages only one project. Each project is located in a specific location, The number of hours an employee works at each project is determined by a project title and the name of an employee. Each manager has a telephone number. Normalize the relational table PROJECT into a minimal number of relational tables in BCNF. Use the functional dependencies to prove that each one of the relational tables obtained from the decomposition of the original table is in BCNF.arrow_forwardRegional Labs is a company that conducts research and development work on a contract basis for other companies and organizations. Figure 2-31 shows data that Regional Labs collects about projects and the employees assigned to them. This data is stored in a relation (table) named PROJECT: PROJECT (ProjectID, EmployeeName, EmployeeSalary)arrow_forward
- Find the location that has average salary more than 4000 dollars. Usually each location mayhave several departments.A) select loc from dept, emp where dept.deptno = emp.deptno group by loc having avg(sal) > 4000;B) select loc from emp group by loc having avg(sal) > 4000;C) select loc from dept group by loc having avg(sal) > 4000;D) select loc from dept where deptno in (select deptno from emp group by loc having avg(sal) > 4000);E) select loc from dept where deptno in (select deptno from emp group by deptno having avg(sal) > 4000);arrow_forwardRegional Labs is a company that conducts research and development work on a contract basis for other companies and organizations. The table below shows data that Regional Labs collects about projects and the employees assigned to them. This data is stored in a relation (table) named PROJECT: PROJECT(ProjectID, EmployeeName, EmployeeSalary)arrow_forwardWrite the resulting relations based on the following ER diagram Like_Group N Customer N name N name address Group Like_Artist amoun t N name Classify Artist year N birthplace 1 title style age type Artwork N Paints pricearrow_forward
- Update the emp table to set the commission of all employees to SR 1000 who are working as managersarrow_forwardPlease design a Task durations and a Dependencies table, and also calculate the Task durations and the Dependencies using the image below:arrow_forwardThe data requirements are summarized as follows: Each movie is identified by title and year of release. Each movie has a length in minutes. Each has a production company, and each is classified under one or more genres (such as horror, action, drama, and so forth). Each movie has one or more directors and one or more actors appear in it. Each movie also has a plot outline. Finally, each movie has zero or more quotable quotes, each of which is spoken by a particular actor appearing in the movie. Actors are identified by name and date of birth and appear in one or more movies. Each actor has a role in the movie. Directors are also identified by name and date of birth and direct one or more movies. It is possible for a director to act in a movie (including one that he or she may also direct). Production companies are identified by name and each has an address. A production company produces one or more movies. Consider the database schema in 3NF for the “Movie” database obtained in…arrow_forward
- Identify week entity in the following scenario: "Students registered in a particular course section of a specific course". AS. A. Course Section B. Course C. Student D. Register Foc 耳 hp f10arrow_forwardConsidering the un-normalized relational table PROJECT below: PROJECT (ProjectTitle, EmpeName, ManagerName, Location, HoursWork, ManagerPhone) The attributes of PROJECT table satisfy the following properties: Each project has many employees, Each employee may involve in one or more projects, Projects are managed by managers; there are many managers in the company, hence a project may be assigned to any one of the managers, but each manager manages only one project. Each project is located in a specific location, The number of hours an employee works at each project is determined by a project title and the name of an employee. Each manager has a telephone number. Normalize the relational table PROJECT into a minimal number of relational tables in BCNF. Use the functional dependencies to prove that each one of the relational tables obtained from the decomposition of the original table is in BCNF.arrow_forwardThe data requirements are summarized as follows: Each movie is identified by title and year of release. Each movie has a length in minutes. Each has a production company, and each is classified under one or more genres (such as horror, action, drama, and so forth). Each movie has one or more directors and one or more actors appear in it. Each movie also has a plot outline. Finally, each movie has zero or more quotable quotes, each of which is spoken by a particular actor appearing in the movie. Actors are identified by name and date of birth and appear in one or more movies. Each actor has a role in the movie. Directors are also identified by name and date of birth and direct one or more movies. It is possible for a director to act in a movie (including one that he or she may also direct). Production companies are identified by name and each has an address. A production company produces one or more movies. Q: Suppose a single relation “Movie” which contains all attributes of all…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
A Guide to SQLComputer ScienceISBN:9781111527273Author:Philip J. PrattPublisher:Course Technology Ptr
A Guide to SQL
Computer Science
ISBN:9781111527273
Author:Philip J. Pratt
Publisher:Course Technology Ptr