Long Answer Question 2: Read the following scenario and draw a logical data flow diagram that includes both the Context diagram and Level '0' diagram (Diagram 0 only for customer) on a piece of paper, take clear photo and upload it as a a solution for this question. Nizwa Hypermarket wants to develop a Sales Information System. This system allows customers to purchase items. The system will check for the price of each item in the price file and calculate the total bill amount. The customer can make the payment by cash or card for purchased items. Then system will print the Bill/Receipt and issues it to the customer.

Long Answer Question 2: Read the following scenario and draw a logical data flow diagram that includes both the Context diagram and Level '0' diagram (Diagram 0 only for customer) on a piece of paper, take clear photo and upload it as a a solution for this question. Nizwa Hypermarket wants to develop a Sales Information System. This system allows customers to purchase items. The system will check for the price of each item in the price file and calculate the total bill amount. The customer can make the payment by cash or card for purchased items. Then system will print the Bill/Receipt and issues it to the customer.

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

can you help me create a Data flow diagram based on this system analysis please.
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.
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.
Q1: The following Component Diagram has some errors circle the error and draw the correct diagram: Student Registeration Database Examination Graduation Admin
Design EERD schema for the system.
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.
Please help me with this
There has been a use case diagram posted for you below, just add more things to it. Please make sure to include "uses" and "extends" just like in the diagram below. Please also provide an explanation for the diagram (maybe explain all the associations).
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…
Create a database Entity and Relationship Diagram (ERD) for the following application (Submitted An image of the Diagram By using Any Application:The Application idea: It is a mobile application called (Khair) to help people. This assistance is moral, material. This assistance is also provided by good people in our community. Example to understand the Application idea more: For example, a person urgently needs a medical chair or bed and does not have the ability to purchase what he needs. The medical chair or bed is requested through the application, and whoever has what he requests initiates the request through the application’s messages and determines the meeting place. Application models (page): Login included: login registration login included: user name password New registration included: name E-mail Password phone number date National Identification Number Home page included: Request - applicant name - address - send message Messages list form included: list of users Messager…
Information system course
Create a diagram for a database with at least 5 tables. This should show your table names and column names. Show the relationships between the tables. Write a statement explaining your database design (why did you use the tables that you did). Create a database in Access based on your diagram. Include all tables in your diagram. Tables should each have a minimum of 5 rows. Create 5 SQL statements using your database. At least 2 of these should be manipulation statements (insert, update, etc). The others should be select statements. Explain what your sql statements do and how they would be useful to your database.