FINANCIAL DECISION MAKING

Managing finance and information

Managing finance and information

Task 1: Databases

Database refers to set of organized set of data in the computer. Mostly the data in the databases is provided to the users who need that data. Databases are important for businesses as there is freedom in the computer database for user to add, remove, modify or retrieve the data in moment of time. This enhances the productivity of the business in cost effective manners. In this task we need to develop the database for http://www.web-blinds.com/ using MS Access.

Tables

The first table is customer table. In customer table there are five fields which are: Customer ID, Customer Name, Phone Number, Address and City. Among them all fields except phone number are set as required fields. Customer ID is set as primary key for the table and validation is set that this field should not exceeds from four characters by setting the field size to 4. Cropped image of the customer table is provided below.

Second table in the database is product table. There are five fields in product table as well and these fields are: Product ID, Name, Product Type, Quantity in a Pack and Price. All the fields in the product table are marked as required and the primary key for the table is Product ID and validation is set that this field should not exceeds from four characters by setting the field size to 4. In addition to this the product category field contains lookup or list and this is done, this is done to select whether the product belongs to a whole product category or parts and accessories categories. This is done to avoid multiple categories in the field and keep a good track of both categories and manage them well.

Third table in the database is invoice table. There are five fields in the table which includes: Invoice ID, Date, Customer ID, Product ID and Unit Sols. In this table all fields are marked as required fields. There is no primary key in the table as invoice number may be duplicated for the invoice regarding multiple products. There are two foreign keys that are present in the invoice table; Customer ID and Product ID. Customer ID is taken from customer table and it links the invoice to the customer table. In the same manners the Product ID links the invoice number to the product details that are purchased in the product table. Invoice ID is restricted to 4 characters in the fields.

As per requirement all these tables are filled with 13 hypothetical records and also the invoice are recorded for month of July only.

Relationship of tables explained above is illustrated in diagram below:

Forms

The invoice form is created by integrating all three tables in the form. All fields from all tables are added. This is done as it helps to maintains all records if there is a new customer than form will automatically adds the customer detail in the ...