Answered step by step
Verified Expert Solution
Link Copied!

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Navigating The Supply Chain Maze A Comprehensive Guide To Optimize Operations And Drive Success

Authors: Michael E Kirshteyn Ph D

1st Edition

B0CPQ2RBYC, 979-8870727585

More Books

Students also viewed these Databases questions

Question

List behaviors to improve effective leadership in meetings

Answered: 1 week ago