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)


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

Construct a relational database for leslies auto sales

Vehicle Identification Number, Manufacturer, Model, Year, Sticker Price Leslie' s, including the date of the sale and the negotiated price. Construct a relational database f

Create a form to link the spreadsheet to a table in database

Create a form (frmUpdateMediaLink) to link the spreadsheet to a table in the database. Create a form (frmUpdateMedia), write a VBA code to extract the data and display

Create an internal dtd for the xml document

Create an internal DTD for the XML document above, write the whole XML document - Create an external DTD for the XML document above, write the whole XML document by linking t

What is your justification selecting your strategy

MN692 Capstone Project Purpose of the assessment How did you do constrain the problem - What alternate strategies did you consider? What is your justification selecting your s

How organizations can use data warehouses

Write a one- to two-page (250-500 word) paper that discusses the differences between data warehouses and data marts. Also, discuss how organizations can use data warehouses

Implement a relational database management system

You have been hired by National Bank as their new database administrator. Your first task is to upgrade the bank's outdated computer system and implement a relational databa

Identify the type dependencies found

CIT 310- In the diagram below there are dependencies. Identify the dependencies. In a Word document, identify the type dependencies found and the attributes found in them.

Describe a dbms and its functions

Describe a DBMS and its functions. List, at minimum, three of the popular DBMS products and give a brief description of each.Explain what mobile devices are and why mobile sys



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

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd