Database "Operations with Currency in Bank Offices"
Task 3. MS Access DBMS
Within the scope of the assignment, it is necessary to form a two-table database. When creating a table structure, you must correctly determine the types of fields (for text fields it is recommended to specify their sizes), in the main table, create a key field. When you enter field names into the structure of tables, they can be abbreviated, without leading to a loss of understanding of the field name (for example, Date of privatization - DatePrice).
In accordance with the sample presented in the task, enter in the main table 3 - 4 records, in the subordinate table - at least 10 records. The values of the data placed in the primary key field of the main table must be unique, in the external key field of the subordinate table it should be repeated several times. A prerequisite is the consistency of the data entered in the primary and external key fields of the tables (they must also ensure that queries to the database specified in your variant of the task are executed).
In order to counter copyright infringement and property rights, we ask you to immediately inform us at firstname.lastname@example.org the fact of such violations and to provide us with reliable information confirming your copyrights or rights of ownership. Email must contain your contact information (name, phone number, etc.)