Create a database and import the text files into tables

Assignment Help Database Management System

Reference no: EM131177643

Assignment - Database Management System

Applicable course objective:

demonstrate problem-solving skills by identifying and resolving issues relating to information systems and their components, and proficiently utilise different types of information systems software (especially gaining proficiency in utilising databases, spreadsheets, and presentation applications).
demonstrate written communication skills by understanding basic information communication and technology (ICT) terminology for effective communication and applying it within a business environment.

Applicable graduate qualities and skills gained from this assessment instrument:

Problem Solving (Skill U2)
Written & Oral Communication (Skill U4)

This assignment is quite complex, and exposes you to many different components in Microsoft Access (any version from Access 2007 to current), some or all of which might be very unfamiliar to you. The assignment description provides some explanation of how to use these components, but you are also expected to use available resources such as Online Help, the Beskeen et al text, the Practical Skills sections at the end of each Module in the Study Materials, the SAM online tutorial activities and the course discussion forums, as well as exploring and experimenting on your own.

Preamble

Dr Nikola Teslaretired in 2012 after a long career in Logistics Management.To keep busy and to fulfil a lifelong dream, Dr Teslastarted a Steampunk Merchandise mail order business called the "Ye OldeSteampunk Emporium" and began selling various types of imported Steampunk merchandise such as ladies' and gentlemen's clothing, ladies' and gentlemen's boots, headwear,goggles and other assorted Steampunk related paraphernalia to customers via mail order around Australia. These types of Steampunk merchandise have become very popular, especially with the development ofsteampunk games (e.g. Bioshock II), steampunk graphic novels (e.g. League of Extraordinary Gentlemen), and even steampunk movies (e.g. Sherlock Holmes, Hugo, the Golden Compass, Sucker Punch and the Three Musketeers) and TV shows (e.g. Warehouse 13) have brought the phenomenon into the public's attention;and Dr Tesla'business has experienced a rapid growth in their mail orders. When Dr Teslafirst retired, the business bought a personal computer to help manage the books and finances.

Ye Olde Steampunk Emporiumis located at Shop 7, 1EdisonBoulevard, Toowoomba (about 100 km west of Brisbane).Dr Teslacan be contacted via phone on (07) 4632 1856; fax on (07) 4632 1943; or email on enquiries@steampunk_emporium.com.au.

Dr Tesla is extremely impressed with our computing firm "Einstein Technologies" and the business has contracted our firm to assist them in setting up their various computer-based information systems.

The first computer-based information system that Dr Teslais interested in is a Database Management System (DBMS) utilising Microsoft Access (any version from Access 2007 to current). The DBMS will be used to store all of the business's customer details, information about the stock items that the business sells, the suppliers that the business uses and all postal order transactions for the business. It will allow Dr Teslato run a number of queries on the data which the business has specified below and they wish to be able to print out an invoice for each customer at the end of each month.

All phases in this project must be developed with professionalism and user-friendliness in mind.

Dr Tesla has provided to us a partial list of the business's customers, stock items, and suppliers and a partial list of herpostal orders for the second quarter 2016(Apr - Jun) to use as test data in four comma delimited text files which can be found on your firm's Intranet (CIS5100 Study Desk).

MrsAda Lovelace, your manager, has set up the following tasks for you to complete for this phase of the project:

1. Create a Database and import the four (4) Text files into four (4) Tables

2. Modify Table Design

3. Set Primary Keys

4. Create Relationships between the Tables

5. Create Data and Update Queries

6. Create Data Display Forms

7. Create an Invoice Report

8. Create an End of Project Presentation to the Client.

Attachment:- Assignment.rar

Reference no: EM131177643

Questions Cloud

Find an infinite set of input instances of max-sat : Find an infinite set of input instances of MAX-SAT for which the expected solutions computed by RSAM are better than the expected solutions computed by RRR.

Estimate the average approximation ratio : Implement the algorithm COMB and test it for real MAX-SAT instances. Try to estimate the average approximation ratio with respect to your input data.

Calculate the eoq for dutch farms : Calculate the EOQ for Dutch Farms. - How many cases should Dutch Farms hold as safety stock against stockouts?

Change is successful : Think about the change you are developing in your extended project. How will you create a guiding coalition? Who will you need to engage to ensure the change is successful? Why is it important for you to make them a part of your guiding coalition..

Create a database and import the text files into tables : Assignment - Database Management System, MrsAda Lovelace, your manager, has set up the following tasks for you to complete for this phase of the project: Create a Database and import the four (4) Text files into four (4) Tables and Modify Table Desig..

Design a k-approximation algorithm for min-sc(k) : Apply the method of the relaxation to LP in order to design a k-approximation algorithm for MIN-SC(k).

Qualified results in losses for investors : Will a qualified opinion save us from liability if the portion qualified results in losses for investors?

Broadening set of interdependent relationships : What is the known as the broadening set of interdependent relationships among people from different parts of the world divided into nations?

Describe the responsibilities of a counseling supervisor : Explain how the social situation with Travon and Elliot could impact the work environment. Develop a policy that you would implement to minimize ethical concerns related to social activities between colleagues while supporting collegial relationsh..

User Account

All Pages