Respuesta :
The database must store information about customers, services, bookings, and payments.
What is database?
A database is a set of organised data stored on a computer system. It is intended to efficiently store, organised, and retrieve b. Databases are used for a variety of tasks, including as managing customer relations, tracking merchandise, and storing vast volumes of data for analysis and reporting. Typically, databases are set up as tables, each of which has rows of linked data. One or even more columns, which are separate data items connected to one another, are included in each row. Databases are utilized to keep information so that it may be accessed, analysed, and changed by users to provide useful results. Users can also quickly search for and obtain specific data using databases.
Application Background
This project will be carried out by a tiny online photography company. This company offers photography services for personal occasions like weddings, birthday parties, anniversaries, etc.
database specifications
The following details need to be kept in the database:
Name, address, mobile number, email address, and date of birth for customers
Services: name, details, and price.
Reservations: client name, communication services, date of reservation, and number of guests.
Payment information: customer name, communication services, payment amount, and method of payment.
ER Schematic
The database for the internet photography industry is depicted in the ER diagram below.
Schema for Relational Databases
The following is a list of the database engine schema again for online photographic business database.
Consumers (Customer Name, Address, Phone Number, Email Address, DOB)
Service (Service Name, Description, Cost) (Service Name, Description, Cost)
Admissions (Customer Name, Service Name, Date of Booking, Number of Guests)
FINANCES (Customer Name,
To learn more about database.
https://brainly.com/question/28033296
#SPJ4
