Information Systems. Creating a Database
The assignment consists of the making of a database from a set of data organized in a spreadsheet according the following requirements:
-Make the import process of each set of data to Database tables.
-Make the relations among the tables
-Program, at least, 3 queries focused to find out information relating geographical situation of customers, purchases, information about the most preferred products of our customers, historical progress of the transactions (consider a transaction as a customer’s purchase)
-Design at least one form per table and a form with a subform inside.
-Design at least one report per table with a specific organization of data based on one or two fields.
The source data are included in the attache spreadsheet. (Business.ods if the works will be carried out using LibreOffice Base and Business.xlsx is the works will be based in Microsoft Access)
