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

 



Table:

tblCustomers

Fields:

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.

 



Table:

tblItems

Fields:

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

 


Table:

tblSuppliers

Fields:

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

 

Table:

tblOrders

Fields:

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:

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.    
Edit Customers Table

6.    
Create Data and Update Queries

7.    
Create Data Display Forms

8.    
Create an Invoice Report

9.    
Create an End of Project Presentation to the Client



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


[2]
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

Share This Post

Email
WhatsApp
Facebook
Twitter
LinkedIn
Pinterest
Reddit

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

Related Questions

Introduction: Claims management is the art of consolidating, billing, filing,

  Introduction: Claims management is the art of consolidating, billing, filing, revising, and managing medical claims, an imperative aspect of the healthcare industry. Medical facilities cannot receive due funds if patients are unaware of how much they need to pay. Ensuring provider organizations understand the fundamentals of medical billing and

Overview of Quantitative Methods Quantitative methods have been the traditional

   Overview of Quantitative Methods Quantitative methods have been the traditional hallmarks of scientific inquiry.  From an early age, we are all aware of the mathematical rigors involved in quantitative analyses. In the discipline of criminal justice, researchers utilize a variety of statistical tools with which to analyze empirical data.

A disaster recovery plan describes scenarios for resuming work quickly

  A disaster recovery plan describes scenarios for resuming work  quickly and reducing interruptions in the aftermath of a disaster. It is  an important part of the business continuity plan and it allows for  sufficient IT recovery and the prevention of data loss. Write a 1-page paper describing the difference

Section-2Information Technology and Organizational Learning Assignment: Complete the following question

 Section-2Information Technology and Organizational Learning  Assignment: Complete the following question in 1 page and adhere to APA formatting standard Review the section on knowledge creation, culture, and strategy.  Explain how balance scorecards impact knowledge creation, culture, and strategy.  Why are these important concepts to understand within an organization? Article/Section for

A project plan is based on research and organizational goals.

A project plan is based on research and organizational goals. To see an exemplar project plan, review the Project Plan Example. Use the Project Plan Template and the business needs identified in your Week 3 Balanced Scorecard to: Develop the project objectives. Explain what operational steps will be taken to achieve your

Cryptography Basics: Basic Cryptography

“Basic Cryptography” will be the first section of your job aid. It should include two parts: 1. A description of the basic elements of cryptography including the following: o the roles of encryption and decryption in public and private keys o the differences between asymmetric and symmetric key cryptography o

When you drive on the roads that are shared with

When you drive on the roads that are shared with trucks, put yourself in the shoes of truck drivers. What do you think is the biggest headache that truck drivers face? Why?ALSO PLEASE REPLY TO ANOTHER STUDENTS COMMENT BELOW  SARA: I absolutely think that passenger vehicles are the number one

Explain the current relationship between the US and China, such as

Description The reaction paper is an argument that uses the readings you have selected for a specific theory to assess. As you develop your argument, critically reflect on the assumptions, claims, and predictions of the theory being written about. Your argument needs to focus in on one theory which is

Describe how your business operations will work. In other words,

Premium Paper Help is a professional writing service that provides original papers. Our products include academic papers of varying complexity and other personalized services, along with research materials for assistance purposes only. All the materials from our website should be used with proper references.

Psychology Movie Response Paper – Premium Paper Help

Premium Paper Help is a professional writing service that provides original papers. Our products include academic papers of varying complexity and other personalized services, along with research materials for assistance purposes only. All the materials from our website should be used with proper references.

Vital Signs. Hello, this is a Med Sur Lab assignment.

   Vital Signs.  Hello, this is a Med Sur Lab assignment. Please see the PowerPoint and complete the attachments. Please complete each attachment separately Check off skills on the lists  Check S (satisfactory) if you fully comprehend and can perform the skill. Check U (unsatisfactory) if you need improvement in

1. * What’s this Strategic Management Business Case about? —————————————————————————————————————————- 2. * Detailed Financial Analysis 7.1 Strategic

1. * What’s this Strategic Management Business Case about? —————————————————————————————————————————- 2. * Detailed Financial Analysis 7.1 Strategic Management, Key Financial Ratios.ppt   7.2 . Financial Ratios Tutorial.pdf         Please explain, analyze, and discuss in great detail your Financial Analysis section … —————————————————————————————————————————- 3. * Industry Analysis (PESTEL

Assignment: Termination of Employment Letter You have just been asked

   Assignment: Termination of Employment Letter You have just been asked to terminate an employee. For this assignment you need to write a termination letter to include all of the following: 1.  Name and Employee Information. 2. Date(s) when the incident(s) or action(s) occurred. 3. Reason for termination. 4. Notify

Choose a perspective and explain it. Be specific and thorough.

Choose a perspective and explain it. Be specific and thorough. Think of someone in your life (a client, co-worker, family, friend, etc.). How can using this perspective help assess this person more fully and look for their strengths? What are their strengths? Can this perspective help assess your needs and

A strategic initiative plan may include multiple initiatives that are

A strategic initiative plan may include multiple initiatives that are designed to work together toward a single larger goal. To create an initial plan, you need to define both your larger goal and what is required to achieve it. Your plan should include the following: An end goal, or what

on your own career map concept (which highlights your own

    on your own career map concept (which highlights your own stages of progression).  map should include and identify future stages of your nursing career progression, as well. Educational status Training Experience present and future Work setting Nursing level of practice Associations Certifications Community activities Mentoring Certifications   

Taking as guiding questions based on the objectives of the

   Taking as guiding questions based on the objectives of the module, carry out a paper taking as reference these objective questions: Do a search and investigate about: 1. Explain that you understand human rights 2. Highlight the concept of human rights and why they are important to business. 3.