AFYA pharmacy is a medicine dispensing shop located along Biashara Street in Nairobi ro fourth floor Eucalyptus towers. The daily operations of the pharmacy are documented in a f file system: Receive and validate prescription from the patient/customer. Search for the prescribed medicine from the data base • Packaging and labelling the medicine as per the prescription • Billing the customer/ patient for the prescription • Processing the payment for the prescription • Issue the medicine and educate the patient/customer on the appropriate use of the medication a) Identify possible entities and relationships in this case b) Produce a conceptual data model for this case c) For each entity in a) identify corresponding attributes and perform normalization up

AFYA pharmacy is a medicine dispensing shop located along Biashara Street in Nairobi ro fourth floor Eucalyptus towers. The daily operations of the pharmacy are documented in a f file system: Receive and validate prescription from the patient/customer. Search for the prescribed medicine from the data base • Packaging and labelling the medicine as per the prescription • Billing the customer/ patient for the prescription • Processing the payment for the prescription • Issue the medicine and educate the patient/customer on the appropriate use of the medication a) Identify possible entities and relationships in this case b) Produce a conceptual data model for this case c) For each entity in a) identify corresponding attributes and perform normalization up

Database Systems: Design, Implementation, & Management

12th Edition

ISBN:9781305627482

Author:Carlos Coronel, Steven Morris

Publisher:Carlos Coronel, Steven Morris

Chapter4: Entity Relationship (er) Modeling

Section: Chapter Questions

Problem 10P

See similar textbooks

Similar questions

Church Information System XYZ Church is a fast-growing church in Grand Rapids area. Over the past three years, since the popular Reverend Timothy Becker has taken over leadership of the congregation, the church has more than doubled in size. It now has approximately 400 registered households. Reverend John Howard has also recently been added as a second minister. Since the Church was rather small in the past, most of its records have been kept on paper forms. However, the Church’s Business Manager, Margie Roberts, has suggested to Reverend Becker that a computerized system might help the Church better meet its information needs and manage its activities. In addition to Ms. Roberts, the Church employs a part-time administrative assistant, Mabel McGregory. Mabel performs clerical duties such as filing, record keeping, answering phone calls, and typing the weekly church bulletin using WordPerfect for Windows on the Church’s only personal computer. A retiree, Leroy Stricty, is employed…
Happy Travel (HAT)A Case Study Case Narration Section 1. Happy Travel (HAT) is a web-based company that has decided to expand its business by providing its registered customers a one-stop shop flight information system to any destination in the world. The database will assist the customer in planning his/her trip in advance as every registered airline with Happy Travel sends its entire fleet’s flight information which will then be posted on the website. This information is updated regularly to ensure the accuracy of the information. 2. However, the company is also accepting transactions over the counter to serve customers who do not have access to the Internet. They can fill-up forms that can be fed to company database at the end of the day. These forms contain passengers’ data and information for the flight they wish to avail. 3. On any given day, several airlines have flights to the same destination. On these flights, information about the plane such as the plane model, seating…
Happy Travel (HAT) A Case Study Case Narration Section 1. Happy Travel (HAT) is a web-based company that has decided to expand its business by providing its registered customers a one-stop shop flight information system to any destination in the world. The database will assist the customer in planning his/her trip in advance as every registered airline with Happy Travel sends its entire fleet’s flight information which will then be posted on the website. This information is updated regularly to ensure the accuracy of the information. 2. However, the company is also accepting transactions over the counter to serve customers who do not have access to the Internet. They can fill-up forms that can be fed to company database at the end of the day. These forms contain passengers’ data and information for the flight they wish to avail. 3. On any given day, several airlines have flights to the same destination. On these flights, information about the plane such as the plane model, seating…
Instructions: Each student shall provide his own answers to the following questions. Similarity in the students' answers will be classified as CHEATING cases. University of Hafr AIBatin (UOHB) is planning to develop a new student information system (SIS). The system will enable the secondary school graduates to apply to UOHB programs. In addition, the system will enable UOHB students to login, register courses, drop courses, selects major, view attendance data, and view grades. Lecturers can login to the system and view students registered in any course. Lecturers can enter the attendance data and final marks of registered students. The university registrar is responsible to create, modify and remove courses. SIS shall connect to Ministry of Education System (MOES) to retrieve the secondary school results of applicants. SIS shall connect also to Qiyas System (QS) to retrieve the applicant's results in General Aptitude Test and Educational Attainment Test. Creating Blackboard classes…
Happy Travel (HAT)A Case StudyCase Narration Section1. Happy Travel (HAT) is a web-based company that has decided to expand its business by providing its registered customers a one-stop shop flight information system to any destination in the world. The database will assist the customer in planning his/her trip in advance as every registered airline with Happy Travel sends its entire fleet’s flight information which will then be posted on the website. This information is updated regularly to ensure the accuracy of the information.2. However, the company is also accepting transactions over the counter to serve customers who do not have access to the Internet. They can fill-up forms that can be fed to company database at the end of the day. These forms contain passengers’ data and information for the flight they wish to avail.3. On any given day, several airlines have flights to the same destination. On these flights, information about the plane such as the plane model, seating capacity…
This organization provides following functionalities Emergency Care 24x7 Support Groups Support and Help Through calls Any new Patient is first registered in their database before meeting the doctor. Each Doctor have ID, specialization, age, name, gender and phone no. every doctor have unique ID. The Doctor can update the data related to the patient upon diagnosis (Including the disease diagnosed and prescription).doctor examined number of patients on daily bases. Patient has unique id, name, age, gender, disease status (admitted, discharged, expired), date and address. Patients with critical condition are examined by many doctors. This organization also provides rooms facility for admitting the patient who is critical. One room can be booked by one patient only and each room has room#, location attributes. Rooms are distributed among two categories general and VIP. Apart from doctors, this organization has nurses and ward boy. Each nurse and ward boy is assigned to no of doctor.…
This organization provides following functionalities Emergency Care 24x7 Support Groups Support and Help Through calls Any new Patient is first registered in their database before meeting the doctor. Each Doctor have ID, specialization, age, name, gender and phone no. every doctor have unique ID. The Doctor can update the data related to the patient upon diagnosis (Including the disease diagnosed and prescription).doctor examined number of patients on daily bases. Patient has unique id, name, age, gender, disease status (admitted, discharged, expired), date and address. Patients with critical condition are examined by many doctors. This organization also provides rooms facility for admitting the patient who is critical. One room can be booked by one patient only and each room has room#, location attributes. Rooms are distributed among two categories general and VIP. Apart from doctors, this organization has nurses and ward boy. Each nurse and ward boy is assigned to no of doctor.…
This organization provides following functionalities Emergency Care 24x7 Support Groups Support and Help Through calls Any new Patient is first registered in their database before meeting the doctor. Each Doctor have ID, specialization, age, name, gender and phone no. every doctor have unique ID. The Doctor can update the data related to the patient upon diagnosis (Including the disease diagnosed and prescription).doctor examined number of patients on daily bases. Patient has unique id, name, age, gender, disease status (admitted, discharged, expired), date and address. Patients with critical condition are examined by many doctors. This organization also provides rooms facility for admitting the patient who is critical. One room can be booked by one patient only and each room has room#, location attributes. Rooms are distributed among two categories general and VIP. Apart from doctors, this organization has nurses and ward boy. Each nurse and ward boy is assigned to no of doctor.…
Premier University's admissions process is well-known to you. Students can access the enrollment portion of their accounts by logging in. Afterwards, individuals can choose the courses they wish to take. When all the courses are submitted, they move on to the awaiting requests. Each request that has been put on hold is approved by the adviser. For the whole registration process, create an SRS document
This organization provides following functionalities Emergency Care 24x7 Support Groups Support and Help Through calls Any new Patient is first registered in their database before meeting the doctor. Each Doctor have ID, specialization, age, name, gender and phone no. every doctor have unique ID. The Doctor can update the data related to the patient upon diagnosis (Including the disease diagnosed and prescription).doctor examined number of patients on daily bases. Patient has unique id, name, age, gender, disease status (admitted, discharged, expired), date and address. Patients with critical condition are examined by many doctors. This organization also provides rooms facility for admitting the patient who is critical. One room can be booked by one patient only and each room has room#, location attributes. Rooms are distributed among two categories general and VIP. Apart from doctors, this organization has nurses and ward boy. Each nurse and ward boy is assigned to no of doctor.…
DATABASE SYSTEMS AllTaste Restaurant is a restaurant that is famous for its taste, so it has a lot of customers. All the flavors are here, serving typical archipelago food that has spread in several cities with various mainstay menus. However, even though it already has many branches and a large number of order transactions every day, AllTaste Restaurant does not yet have an application and database to manage transactions and data. Order recording and sales reports are still done manually. AllTaste Restaurant owners know that information technology can support their business, so they plan to build applications to serve food orders both offline and online. In the database design stage, it is known as bottom-up, top-down, and inside-out approaches. Explain the three approaches! In your opinion, what approach is used for database system development at AllTaste Restaurant? Explain why you chose this approach! What techniques do you use to collect information (fact-finding technique)?…
Payor: You are working for an insurance company and you need a database to help track your quality measure of how many of your clients have a 1 year well child check. You need collect parent name, address and phone number You need to know when the child is due for the 1 year visit There are 3 pediatric practices that your clients can choose from each of which have 2 pediatricians on staff. Each family has determined their preferred communication method Email Text Mail Each patient is assigned to one of 2 navigators at the insurance company who will provide a reminder via the family’s prefered communication method Your submission should include: A list of business rules written so that your 'customer' would understand how their database is designed. A crow's foot ERD for your database that demonstrates your understanding of entities attributes relationships naming conventions primary and foreign keys Tables showing 3-5 records for each entity.

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

Np Ms Office 365/Excel 2016 I Ntermed

Computer Science

ISBN:

9781337508841

Author:

Carey

Publisher:

Cengage

Principles of Information Systems (MindTap Course…

Computer Science

ISBN:

9781305971776

Author:

Ralph Stair, George Reynolds

Publisher:

Cengage Learning

MIS

Computer Science

ISBN:

9781337681919

Author:

BIDGOLI

Publisher:

Cengage

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

Np Ms Office 365/Excel 2016 I Ntermed

Computer Science

ISBN:

9781337508841

Author:

Carey

Publisher:

Cengage

Principles of Information Systems (MindTap Course…

Computer Science