Create a database and import text files into tables

Assignment Help Database Management System

Reference no: EM131338384

Assignment - Database Management System (DBMS)

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)

Preamble

Dr Rod N Berry retired in 2012 after a long career in Logistics Management.To keep busy and to fulfil a lifelong dream, Dr Berrystarted a Memorabilia mail order business, specialising in Star Trek Memorabilia related products called the "The Borg Collective" and began selling various types of imported Star Trek merchandise such as statues, replicas, giftware, clothing and other assorted Star Trek paraphernalia to customers via mail order around Australia. These types of Star Trek merchandise have become very popular, especially since J.J. Abrams' reimagining of the franchise with Star Trek (2009), Star Trek Into Darkness (2013), Star Trek Beyond (2016) and the new Television series called Stat Trek Discovery (2017) have brought the phenomenon back into the public's attention. Dr Berry has experienced a rapid growth in their mail orders. When Dr Berryretired, the business bought a personal computer to help manage the books and finances.

Dr Berry is extremely impressed with our computing firm "Klingon Systems" and the business has contracted our firm to assist them in setting up their information systems.

The first information system that Dr Berryis interested in is a Database Management System (DBMS) using 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 Berryto 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 every month.

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

Dr Berry has provided 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 tab delimited text files (*.txt) which can be found on your firm's Intranet (CIS1000 Study Desk).

Mr Sev N O'Nine, 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: EM131338384

Questions Cloud

Asset expansion and asset replacement projects : Distinguish between asset expansion and asset replacement projects. How does this distinction affect the capital expenditure analysis process?

Article on virtual health or telehealth : Find a scholarly article on Virtual Health or TeleHealth. Summarize the article and provide your thoughts on it. Please ensure that you cite your source in APA format.

How you compete in the current job market : Identify your options in the job market based on your educational level - How will increasing your level of education affect how you compete in the current job market and how will increasing your level of education affect your role in the future of n..

Calculate maccauley companys after tax operating cash flow : How is the opportunity cost concept used in the capital budgeting process?- Calculate the MacCauley Company's after-tax operating cash flow using both straight-line and accelerated depreciation.

Create a database and import text files into tables : Mr Sev N O'Nine, 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, Modify Table Design and Set Primary Keys

Pressing ethical issues surrounding genetic testing : What do you consider the most pressing ethical issues surrounding genetic testing? Provide at least two examples, and explain why you consider these most important.

How would differing level of project risk influence : In general, how would a capital budgeting constraint on the available amount of investment funds influence these decisions?

Explain why the cosine function is a periodic function : Sketch the graph of a periodic function that is neither the sine nor cosine function. State the period of the function.

Incapacitated or incompetent : A patient's family may be actively involved in end-of-life decisions for patients who are incapacitated or incompetent. Compare and contrast two legal cases that address the rights of families in participating in end-of-life decisions. For each le..

Reviews

len1338384

1/3/2017 1:52:16 AM

Australian student, need this assignment totally as per the requirements. This assignment must be all your own work. It is acceptable to discuss course content with others to improve your understanding and clarify requirements, but solutions to assignment questions must be done on your own. You must not copy from anyone, including tutors and fellow students, nor allow others to copy your work. All Assignments will be checked using collusion monitoring tools to ensure that each assignment is the original work of the submitting student. 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.

Write a Review

Required(*) Message

User Account

All Pages