w a data flow diagram for a simple Food Delivery System for Faculty and Staff. Label them properly. The system’s information are the ff: • The school’s canteen personnel inform the faculty and staff of available viands/desserts for lunch on the canteen’s website. Food prices are also indicated on the website. • The faculty and staff inform the canteen of their names, dept., food order, amount of money for payment (ex: P200, P100). The expected change, ordered foods, receipt/s are usually delivered at 11:30AM to their respective offices. • The canteen personnel update the status of the food order of the faculty and staff as delivered or cancelled. Required: Context Diagram, Detailed DFD

w a data flow diagram for a simple Food Delivery System for Faculty and Staff. Label them properly. The system’s information are the ff: • The school’s canteen personnel inform the faculty and staff of available viands/desserts for lunch on the canteen’s website. Food prices are also indicated on the website. • The faculty and staff inform the canteen of their names, dept., food order, amount of money for payment (ex: P200, P100). The expected change, ordered foods, receipt/s are usually delivered at 11:30AM to their respective offices. • The canteen personnel update the status of the food order of the faculty and staff as delivered or cancelled. Required: Context Diagram, Detailed DFD

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

Kindly explain the flow of data on the diagram
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?
QUESTION 1 An admission charge for Bandar Orchid Wetlands varies according to the age of the customer as in Figure 1. The system will receive the input for the number of persons for each category as in Figure 2. Then, it will calculate and display the total charge (include SST 8%) and the category Figure 3. [Assume all items are required. The process is not involving any decision]. Category (Age) 50 and above 13- 49 7-12 4-0 Charge (RM) 30.00 35.00 25.00 15.00 Below 4 Figure 1: Charges for Visitors Free The Bold items are the input from the user. WELCOME TO BANDAR ORCHID WETLANDS Enter the number of persons for each category Age Over 50 Age 13 - 50 Age 7 - 12 Age 4 - 6 Age Below 4 1 2 Figure 2: The Input Total for Over 50 (1 Fersons): BM 30.00 Total for 13 - 50 (2 Persons): RM 70.00 Total for 7 - 12 (4 Persons): RM 100.00 Total for 4 - 6_(O Persons): RM 0.00 Total for Below 4 (FREE) : RM 0.00 ITEMS RM 200.00 12.00 TOTAL 3ST (6R) SUB-TOTAL = 212.00 THANK YOU.ENJOY YOUR HOLIDAY!! Figure…
A laboratory has several chemists who work on one or more projects. Chemists also may use certain kinds of equipment on each project. Attributes of CHEMIST include Employee ID (identifier), Name, and Phone No. Attributes of PROJECT include Project ID (identifier) and Start Date. Attributes of EQUIPMENT include Serial No and Cost. The organization wishes to record Assign Date—that is, the date when a given equipment item was assigned to a particular chemist working on a specified project. A chemist must be assigned to at least one project and one equipment item. A given equipment item need not be assigned, and a given project need not be assigned either a chemist or an equipment item. Provide good definitions for all of the relationships in this situation.
Question 3 Draw a detailed activity Diagram in draw.io and screenshot it for me. ( **Please take note is a detailed activity diagram) Scenario The exam unit uses the system after the subject registration period has closed. The system will display a list of subjects that have registered students. Using this list, the exam unit will plan out examination week. Examination week lasts 6 days, from Monday to Saturday. For each day, the exam unit will assign a subject to that day. Each day can have a total of 6 examination hours with subjects having 2- hour or 3-hour examinations. For example, if the subjects are 2-hour examinations, then 3 of them can be scheduled for the day and if the subjects are 3-hour examinations, then only 2 of them can be scheduled for the day. There can also be a mixture of 2-hour and 3-hour examinations. If the exam unit schedules too many examination hours for that day then the day resets and the exam unit needs to reschedule again. This process stops when…
Each publisher has a unique name; a mailing address and telephone number are also kept on each publisher. A publisher publishes one or more books; a book is published by exactly one publisher. A book is identified by its ISBN, and other attributes are title, price, and number of pages. Each book is written by one or more authors; an author writes one or more books, potentially for different publishers. Each author is uniquely described by an author ID, and we know each author’s name and address. Each author is paid a certain royalty rate on each book he or she authors, which potentially varies for each book and for each author. An author receives a separate royalty check for each book he or she writes. Each check is identified by its check number, and we also keep track of the date and amount of each check. As you develop the ERD for this problem, follow good data naming guidelines.
The definition of a variable is required to contain, in addition to the variable's name, the variable's "type" as well as the variable's "additional attributes." Every variable may be assigned to more than one data type. If you could describe the concept, would it be possible for us to more accurately define any variables in the future?
Using the context diagram, create a data flow diagram.
An Entity Relationship (ER) Diagram is a type of flowchart that illustrates how “entities” such as people, objects or concepts relate to each other within a system. Consider the following description of a system: A university registrar’s office maintains data about following entities: Courses, including number, title, credits, syllabus, and prerequisites. Course offerings, including course number, year, semester, section number, instructor, timings and classroom. Students, including student-id, name, and program. Instructors, including identification number, name, department, and title. Furthermore, the enrollment of students in courses and grades awarded to students in each course they are enrolled for must be appropriately modeled. Construct an ER Diagram for the registrar’s office. Document all assumptions that you make about the mapping constraints.
Q : Draw an ERD from the following business rules: Use proper notations for the type of attributes. A software system is to be developed for an educational institute. The software is intended to be used by faculty members, students and designated support staff. System administrator will also use system for system administration and management. Student’s data including names, registration number, cell numbers and address will be added and edited by Clerk. The data will be added at the time of student reporting at campus. Student can enroll into any course of their choice from the offered courses. They can also request for dropping a course. Approval of course dropping of a student will be granted or refused by academic coordinators.
Draw an E-R diagram for each of the descriptions below. Q -An architectural design firm has a number of design projects underway at any point in time. Each of these projects is identified by a unique project identification code. Additional data stored for each project includes a description, a target completion date, and a dollar budget amount. Design associates staff these projects. These associates include architects, engineers, and computer CAD (Computer-Aided Design) specialists. Each associate is identified by a unique code. Other information about associates includes their name, specialty, their level. There are three levels of associates (gold, silver, and bronze). The bronze associates report to one and only one silver associate (who typically has at least one bronze associates reporting to her), and the silver associate reports to a gold associate in the same fashion. Each project staffed by at least one associate staff. It is also common to find any particular associate…
Draw 1 . Question diagram