Answered step by step
Verified Expert Solution
Question
1 Approved Answer
In access create a database Accumulation. In stores, regular customers are usually offered to buy a store card. By presenting this card during the payment
In access create a database Accumulation. In stores, regular customers are usually offered to buy a store card. By presenting this card
during the payment of the product, virtual money is calculated, the size of which depends on the purchase amount
and which the buyer can use to pay for new purchases. Create a structure for a new relational database named Accumulation, intended for the accounting of virtual money. The database must contain information
about the buyer's name, card number, date of purchase and the amount of virtual money earned.
The database must meet the following conditions:
the database structure is created in such a way that data duplication is not allowed;
each table field contains an indivisible unit of information;
appropriate data types are selected for all fields;
all tables contain a primary key field;
a relation relation is established between the tables, ensuring referential integrity.
NO need to enter data into the database!
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started