1. Draw a Logical Data Flow Diagram (Diagram 0) for the given scenario and Context diagram. The Student Registration System wil1 take the data from students and create students' records at the time admission to the college and store in the student file. Registration department creates Time Table for all the courses for registration purpose and store it in a time table file. Each semester students register for the courses they want to study. After registration is done by the students, this System will print the time table for students and also for teachers..

1. Draw a Logical Data Flow Diagram (Diagram 0) for the given scenario and Context diagram. The Student Registration System wil1 take the data from students and create students' records at the time admission to the college and store in the student file. Registration department creates Time Table for all the courses for registration purpose and store it in a time table file. Each semester students register for the courses they want to study. After registration is done by the students, this System will print the time table for students and also for teachers..

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Similar questions

Draw the Level 0 and Level 1 Data Flow Diagram for a Car Purchasing System. Scenario: An owner has to register first to buy a car by providing his personal details, which are later saved in the registration database, then the system will give the registration number back to the owner. The owner will then need to provide the model, name, type of car he wants to buy, and the system automatically reads the status of the car from the car database, which later informs the owner regarding its availability. The owner pays the cost of the car. The system will update the payment database and issue a receipt back to the owner.
4. Sequence Model: a. A sequence diagram is useful for what purpose? b. b. Create a scenario in the proper format for a sequence of events that occur during the execution of a travel agency system, such as for a use case, c. Create a sequence diagram for a session with the travel agency system, |
You are asked to design a sequence diagram to describe the interactions of a part of a library system. This part can be described as a use case. In this use case, a librarian uses the system to check out an item for a legitimate borrower. First, the system needs to check the borrower's record. Second, check if the item is available or not, then update the library data, the borrower's record, etc. Use the following class diagram and details to get information about the system. Record CheckOut LibraryData recordlsGood checkRecord() addToRecord() checkData() changeData() available 1 1 requestCheckOut() 1 *
Develop a context diagram and level-0 diagram for following case study: “Drugstore at Combined Military Hospital fills medical prescriptions for all hospital patients and distributes these medications to the nurse sections responsible for the patients’ care. Doctors write prescriptions and send them to the drugstore. A drugstore technician reviews each prescription and sends it to the appropriate drugstore section. Prescriptions for drugs that must be formulated within the hospital are sent to the lab section, prescriptions for off-the-shelf drugs are sent to the LP (local purchase) section, and prescriptions for narcotics are sent to the LP (local purchase) section. At each section, a pharmacist reviews the order, checks the patient’s file to determine the appropriateness of the prescription, and fills the order if the dosage is at a safe level and it will not negatively interact with the other medications or allergies indicated in the patient’s file. If the pharmacist does not fill…
Develop a context diagram and level-0 diagram for the hospital pharmacy system described in the following narrative. If you discover that the narrative is incomplete, make up reasonable explanations to complete the story. Supply these extra explanations along with the diagrams. The pharmacy at Mercy Hospital fills medical prescriptions for all hospital patients and distributes these medications to the nurse stations responsible for the patients’ care. Prescriptions are written by doctors and sent to the pharmacy. A pharmacy technician reviews each prescription and sends it to the appropriate pharmacy station. Prescriptions for drugs that must be formulated (made on-site) are sent to the lab station, prescriptions for off-the-shelf drugs are sent to the shelving station, and prescriptions for narcotics are sent to the secure station. At each station, a pharmacist reviews the order, checks the patient’s file to determine the appropriateness of the prescription, and fills the order if the…
Design an ER diagram for keeping track of information about votes taken in the U.S. House of Representatives during the current two-year congressional session. The database needs to keep track of each U.S. STATE’s Name (e.g., Texas, New York, California) and includes the Region of the state (whose domain is {Northeast, Midwest, Southeast, Southwest, West}). Each CONGRESSPERSON in the House of Representatives is described by their Name, and includes the District represented, the StartDate when they were first elected, and the political Party they belong to (whose domain is {Republican Democrat, Independent, Other}). The database keeps track of each BILL (i.e., proposed law), and includes the BillName, the DateOfVote on the bill, whether the bill PassedOrFailed (whose domain is {YES,NO}), and the Sponsor (the congressperson(s) who sponsored--i.e., proposed--the bill). The database keeps track how each congressperson voted on each bill (domain of vote attribute is {Yes, No, Abstain,…
Draw the Level 0 and Level 1 Data Flow Diagram for the Omantel Billing System Scenario: The teacher uploads the eLearning question, which is then saved in the QUESTIONS database, and informs the students that the quiz is now available for them to take. When taking the quiz, the student will be randomly assigned questions from the QUESTIONS database. All of the student's answers will be saved in the ANSWER database. The system will automatically mark the quiz by accessing the student answers from the ANSWER database and the correct answer from the Question database, after which the system will notify both the teacher and the student of the results.
Create a sample data flow diagram of a database: For example, a residents filling out the form (personal information) and an admin updating/accessing the records of the residents. (Name, address, contact #, family members).
Complete a decomposed lower level data flow diagram (DFD) for the following requirements for a customer posting payment to a store charge account. This is done by scratch using Microsoft Visio and based on the Gane and Sarson shapes as explained in the lesson and textbook (Chapter 6). The customer will send payment by mail and the payment will be posted through the system that updates the customer charge account. The payments have to be deposited systematically to the bank, recorded in the general ledger by the system, and the system should automatically send the customer a receipt. Your DFD should have two external entities, two data stores, and three processes. You should utilize Microsoft Visio to create this DFD.
b. Develop a sequence diagram showing the interactions involved when a student registers for a course in a university. Courses may have limited enrolment, so the registration process must include checks that places are available. Assume that the student accesses an electronic course catalog to find out about available courses.
Question 3 Draw an activity Diagram in draw.io and screenshot it for me. 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 all subjects have been scheduled.
You are required to draw a complete State Transition Diagram (STD) of a university from enrollment of student to his/her pass-out. You will have to draw the diagram up to N level to cover all the activities of university starting from enrollment request by student to final pass-out process after completion of degree.