(Answered) CIS1000 Assignment: Database Management System


Dr Gustav Holst retired in 2012 after a long career in Human Resource Management. To keep busy and to fulfil a lifelong dream, Dr Holst started a mail order musical instrument business, specialising in unique musical instrument related products called the “Holst’s Planets Music Emporium”. The business specialises in various types of imported musical instruments such as harps, bagpipes, banjos, xylophones, Hawaiian guitars, and mandolins to customers via mail order around Australia.

Dr Holst’s business has experienced a rapid growth in their mail orders. When Dr Holst first retired, the business bought a personal computer to help manage the books and finances.

Holst’s Planets Music Emporium is located at Shop 1, 10 Concerto Crescent, Toowoomba (about 100 km west of Brisbane). Their ABN is 137 168 521. Dr Holst can be contacted via phone on (07) 4633 4572; fax on (07) 4633 4574; or email on enquiries@hpme.com.au.  

Dr Holst is extremely impressed with our computing firm “Celestial 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 Holst is interested in is a Database Management System (DBMS) utilising Microsoft Access (any version from Access 2007 to current). The DBMS will store all 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 Holst to 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.

Anne Vallayer-Coster, Attributes of Music, 1770.

Your firm’s Systems Analyst has developed a database structure that has been determined to be suitable to create a database to store Dr Holst’s customer, item, supplier and order data for the business, which has been provided as follows:

Table Specifications





Cust ID (Primary Key), Title, Family Name, Given Names, Date of Birth, Address, City, State, Postcode, Freight Distance (Km), Mobile Number, eMail Address, Mailing List.





Item ID (Primary Key), Classification, Instrument, Freight Weight (Kg), Supplier ID, In Stock, On Order, Cost Price (AT)
, Cost Price (LC)





Supplier ID (Primary Key), Supplier Name, Address, City, State, Postcode, Phone Number, Recommended MarkUp





Cust ID, Item ID, Order Date (Primary Key), Dispatch Date, Order Qty

Note: The primary key of the Orders table is a combined multiple-field key. It has three fields in one key.

Dr Holst has provided to us a partial list of the business’s customers, stock items, and suppliers and a partial list of the business’s postal orders placed between Sept and November 2018 to use as test data in four comma delimited text files, which can be found on your firm’s Intranet (CIS1000 Study Desk). 

Dr Colin Matthews, 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

Set Primary Keys

Create Relationships between the Tables

Edit Customers Table

Create Data and Update Queries

Create Data Display Forms

Create an Invoice Report

Create an End of Project Presentation to the Client

AT is the country code for Austria (their currency is the Euro)

LC is the country code for Saint Lucia (their currency is the East Caribbean Dollar)

Click here to request for this assignment help

#CIS1000 #Assignment #Database #Management #System

How useful was this post?

Click on a star to rate it!

Average rating 0 / 5. Vote count: 0

No votes so far! Be the first to rate this post.

Share This Post


Order a Similar Paper and get 15% Discount on your First Order

Related Questions

(Answered) Task 2: Argumentative Research Paper- Organic foods verses GMOs

0 (0) Writing a research paper gives you an opportunity to explore a topic of special interest, research that topic, and organize your research findings in writing for an academic audience.   Through your preparation work, you have established an argumentative thesis statement and have planned a clear organization of

(Answered) M3A1: Citizens United

0 (0) (copy and paste the link) Review Campaign Finance: Abuses and Reforms. [Video File] [48 min 25 sec] before you participate in this activity. Parts of the video will discuss aspects of campaign finance and reform. Before engaging in this activity, please return to the first discussion topic on

(Answered) The decision in Williams v Roffey Bros signals that the courts in deciding whether or not to enforce a promise, may be guided less by technical questions of consideration than by questions of fairness, reasonableness and commercial utility.

0 (0) The decision in Williams v Roffey Bros signals that the courts in deciding whether or not to enforce a promise, may be guided less by technical questions of consideration than by questions of fairness, reasonableness and commercial utility.   The assignment will be in accordance with the following

(Answered) What are the effects of Ketamine treatment on treatment resistant depression?

0 (0) • Introductory statement clearly describes the phenomenon and main health issue • Clearly identifies the problem and gives an argument for examining the problem • Thesis statement is clear and well-articulated • Clearly articulates the particular population with clinical setting provided 1. Operational Definitions • Operational definitions of

(Answered) Management and Organizational Behavior.

0 (0) Description Exercise 17: Read Annual Pay Raises (W-68-69). This is located in the color-coded workbook section in the back of your book. ( Uhl-Bien, M., Osborn, R. N., & Schermerhorn, J. R. (2014).) Organizational Behavior. Hoboken, NJ: Wiley. ISBN:9781118517376 Review the exercise and complete steps 1 and 2.

(Answered) The Wall of Silence Reflective Journal

0 (0)  Assignment Instructions: For this course, you will be reading The Wall of Silence by Gibson and Singh (2003). Please read the book and reflect upon what you have read, and complete the assignment as described. The purpose of this reflective assignment is to provide the approach for connecting


0 (0) Determination of Human Subjects Research Form and my project proposal. please, research about IRB. write the Description. Referencing the Determination Checklist on Page 2, briefly describe project objectives, the subject population and types of data/specimens to be collected and analyzed, how the data/specimens will be obtained, and why

(Answered) Company Description and SWOT

0 (0) Non Alcoholic Beverage company!!!! n this assignment, you will conduct a SWOT (Strength, Weakness, Opportunity, and Threat) analysis for the type of beverage you have selected, and for your company overall. As you work on the assignment, consider why you have chosen one type of non-alcoholic beverage over

(Answered) Oral Language chart of phone conversation

0 (0) Instructions In an APA formatted paper, paste the template found in doc. sharing. Define each of the terms and then watch the video of two children talking on the phone. Rate the language development of one of the two children in the video found at Use the SOLOM.

(Answered) Motivations of Private-Sector Organizations

0 (0)  Presidential Policy Directive 8 (PPD-8) is part of the national preparedness goal and provides a description for preparing for the threats in an all-hazards approach that pose the greatest risk to the United States. Community preparedness is a shared responsibility of the whole community. In addition to the

(Answered) Effective Resource Allocation

0 (0)  The discussion assignment for this week includes a review of the Key Assignment Outline completed by one of your classmates, as well as a substantial response to at least one other student. Primary Task Response: Your first task is to post your own Key Assignment Outline to the

(Answered) Ethics Case Study

0 (0) A student’s analysis of the ethic case must use the following written structural framework, which can be written as a memorandum to the file. Without the bullet points – these indicate required headings for each of the four sections. The following the description heading below to form a

(Answered) The Relativist Ethical Position.

0 (0)  In your post, address the following: To what extent would you agree with the view that research should rely on a relativist ethical position—rules or duties may vary across different communities and professional groups? What examples could you suggest to support this view? References: – Doing Research in

(Answered) Poverty in the classroom

0 (0) A four-unit research paper in APA formatting centered around the effects of poverty in education. The first unit needs to be about the effects poverty has on students in the classroom and needs to be 8-10 pages. Second unit is on the effects of substance abuse on students

(Answered) Causes of America’s War in Vietnam

0 (0) Description Formatting 12 font or smaller, standard script (e.g. Calibri, New Times Roman), 1.00-1.25 margins maximum, double spaced, clean appearance, etc. Basic organization is simple— don’t make it difficult Title— choose one that reflects your views on the topic to inform and engage your reader from the start,

(Answered) Workflows in telemetry

0 (0) Workflow analysis aims to determine workflow patterns that maximize the effective use of resources and minimize activities that do not add value. There are a variety of tools that can be used to analyze the workflow of processes and clarify potential avenues for eliminating waste. Flowcharts are a

(Answered) Critical Decision Making for Providers

0 (0) View the scenario called “Critical Decision Making for Providers”. In a 750-1,200 word paper, describe the scenario involving Mike, the lab technician, and answer the following questions: What were the consequences of a failure to report? What impact did his decision have on patient safety, on the risk