PLEASE DRAW THE DIAGRAM ACCORDING TO THE QUESTION: 4. Company TeaLeaves has recently adopted a new order management system for handling production requests. The sales representative can place a new order for production. If special materials are required for producing the new order, then an order is placed for special materials with the supplier. Otherwise, if no special materials are required for producing the new order or the supplier has finished providing the special materials, the order is added to the production list. Afterwards, the order is scheduled for production. Once the order is confirmed, a letter is generated to the sales representation and to the manager.

PLEASE DRAW THE DIAGRAM ACCORDING TO THE QUESTION: 4. Company TeaLeaves has recently adopted a new order management system for handling production requests. The sales representative can place a new order for production. If special materials are required for producing the new order, then an order is placed for special materials with the supplier. Otherwise, if no special materials are required for producing the new order or the supplier has finished providing the special materials, the order is added to the production list. Afterwards, the order is scheduled for production. Once the order is confirmed, a letter is generated to the sales representation and to the manager.

Database Systems: Design, Implementation, & Management

12th Edition

ISBN:9781305627482

Author:Carlos Coronel, Steven Morris

Publisher:Carlos Coronel, Steven Morris

Chapter2: Data Models

Section: Chapter Questions

Problem 15P

See similar textbooks

Similar questions

Given the following relation that stores details of employees and their projects: ProjectID EmployeeName EmployeeSalary 100-A Salim Housni 2000 100-A Taleb Maashani 1800 100-B Taleb Maashani 1800 200-A Salim Housni 2000 200-B Salim Housni 2000 200-C Salim Housni 1350 200-C Taleb Maashani 1800 200-D Salim Housni 1350 If the functional dependencies are consistent with the above relation, put TRUE. If they are not, put FALSE ProjectID --> EmployeeName (....) ProjectID --> EmployeeSalary (....) ProjectID , EmployeeName -->EmployeeSalary (....) EmployeeName --> EmployeeSalary (....) EmployeeSalary --> ProjectID (....) EmployeeSalary --> EmployeeName , ProjectID (....)
University AAA has 150 staff which consists of an academic and a non-academic category. Each staff is given an option to select either a PENSION ON 56 YEARS scheme or a PENSION ON 60 YEARS scheme. Display the details of each staff information and the total number of academic staff and non-academic staff that have selected a PENSION ON 56 YEARS scheme and a PENSION ON 60 YEARS scheme. Staffs’ InformationName NoIC Age Category Scheme……. …… …….. …… …..……. …… …….. …… …..……. …… …….. …… …..Report of selected SchemeCategory AcademicPENSION 56 : ....PENSION 60 : ....Report of selected SchemeCategory Non-AcademicPENSION 56 : ....PENSION 60 : .... (a) identify input, process and output for above program.(b) write a pseudocode or draw a flowchart for above program
Given the following relation that stores details of employees and their projects:
Write the business rules that are reflected in the ERD shown in Figure P2.15. (Note that the ERD reflects some simplifying assumptions. For example, each book is written by only one author. Also, remember that the ERD is always read from the “1” to the “M” side, regardless of the orientation of the ERD components.) FIGURE P2.15 THE CROW’S FOOT ERD FOR PROBLEM 15
When a customer contacts the company to ask for an estimate, the proprietormakes a note of the customer’s contact details and an outline of the proposedwork. He agrees a date with the customer to view the property in order to givean estimate of the cost for the work. When visiting the property on the agreeddate the proprietor adds more detail to the outline of the proposed work. Within3 days of visiting the property the proprietor produces a fully detailed estimateand sends it to the customer. If the customer agrees the estimate, the proprietorschedules a date to start the job (this is based on the size of the job and otherjobs that have already been scheduled).A few days before the agreed start date of a job, the proprietor contacts thecustomer to confirm the start date, and then orders the required buildingmaterials from suppliers to be delivered on the date the job starts. At theend/completion of the job the proprietor calculates the actual cost of the job toproduce an invoice which…
Task Description: consider the following relations for a university: Student (sid: integer, sname: string, GPA: real, dateOfBirth: date) Department (did: integer, dname: string, capacity: integer) Course (cid: integer, cname: string, credit: integer) Enroll (studentID: integer, courselD: integer, departmentID: Integer, enrollmentDate: date) studentlD, courselD, and departmentID in Enroll are foreign keys referencing the primary keys of the student, course, and department relations, respectively.
Create a decision table for the below case: An order will be accepted only if the product is in stock and the customer’s credit is OK. If both conditions are met, the order is accepted. Otherwise, the order is rejected. Then, the company decides that the credit manager can waive the customer’s credit requirement.
WEEK 8 ASSIGNMENT create a star schema for the Bob's Fixit Group Case Study . The star schema needs to support the analysis or measurement of material price by suppliers, date, and jobs. Case Study Bob owns a small company called Bob’s Home repairs. He does the small home repair jobs that the large companies pass by. Need some woodwork or wood furniture fixed? Call Bob. Here is how the business works: Someone calls Bob and asks him to bid on a job. He drives over, looks at the situation, and gives them a bid. Sometimes it is an official looking bid by mail, and sometimes it is scribbled on notebook paper. He decides how long it will take to do the job (he bills by the hour), how much wood will be needed, any odds and ends that are unique to the job, and an overall price. He moves from job to job and bills customers as he finishes the work. Bob buys items and supplies from a variety of places, but he buys stuff only when it is needed for a particular project. A potential problem:…
In the attached diagram, which of the following statements are true? primary key for section is course_id, sec_id, semester, year primary key for section is equivalent to the primary key for course unioned with the discrimator section is a weak entity set whose existence depends on course the discrimator of section is sec_id, semester, year
Create a Crow's Foot ERD to include the following business rules for the ProdCo company:a. Each sales representative writes many invoices.b. invoice is written by one sales representative.c. Each sales representative is assigned to one department.d. Each department has many sales representative.e. Each customer can generate many invoicesd. Each invoice is generated by one customer
To manage the materials of a factory, please give the E-R diagrams. Such entity sets are involved as below: Warehouse: with attributes as Number, area and telephone Accessory : with attributes as number, Name, Specification, price and description Supplier: with attributes as Number, name, address, telephone and асcount Project : with attributes as number and budget Employee : with attributes as number, name and age
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?

SEE MORE QUESTIONS

Recommended textbooks for you

Database Systems: Design, Implementation, & Manag…

Computer Science

ISBN:

9781305627482

Author:

Carlos Coronel, Steven Morris

Publisher:

Cengage Learning

Database Systems: Design, Implementation, & Manag…

Computer Science

ISBN:

9781285196145

Author:

Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel

Publisher:

Cengage Learning

Database Systems: Design, Implementation, & Manag…

Computer Science

ISBN:

9781305627482

Author:

Carlos Coronel, Steven Morris

Publisher:

Cengage Learning

Database Systems: Design, Implementation, & Manag…

Computer Science

ISBN:

9781285196145

Author:

Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel

Publisher:

Cengage Learning

SEE MORE TEXTBOOKS