Reference no: EM132555462

CIS1000 Information Systems Concepts Assignment - University of Southern Queensland, Australia

Assessment - Database Management System (DBMS) & Presentation

LEARNING OBJECTIVES - Applicable course objective:

Course Objective 3: apply information systems concepts to identify and resolve organisational problems and to develop ethical considerations within a business context

Course Objective 4: apply information systems skills to develop practical solutions within a business context

Course Objective 5: communicate information systems concepts to both technical and non-technical audiences within a business context.

ASSIGNMENT REQUIREMENTS -

Task 1: Create and Import

Create a new blank Access Database (using any version from Access 2007 to current) and name it [lastname] [initial] _ [student number] _ [course code] _ assign1.accdb (eg. genrichr_0050051005_cis1000_assign1.accdb).

Import the four sets of data from your firm's Intranet (CIS1000 Study Desk).

The easiest and quickest way to import data into Access is by using the Import Text Wizard. The following steps must be followed carefully to ensure the data is imported correctly.

Importing Tab Delimited Text files into Access (any version from Access 2007 to current) using the Wizard.

1) On the External Data tab, in the Import & Link group, click the Text File data source icon.

2) In the Get External Data - Text File wizard popup, browse to find the 'Assignment01 Text File Customers.txt' text file and select the Import the source data into a new table in the current database option - then click OK.

3) Select the Delimited - Characters such as commas or tab separate each field option on the first page of the wizard - then click Next.

4) Select the Tab option on the second page of the wizard and turn on the First Row Contains Field Names check box - then click Next.

5) Set the following for each field on the third page of the wizard:

Field Name - keep the field name as it appears when imported

Data Type - giving each an appropriate data type (students will be marked on their logical choice of data types, based on the sample data provided).

When you are sure that each field has the appropriate data type, click Next.

6) Select No Primary Key option on the fourth page of the wizard - these will be set in Task 2 - then click Next.

7) Name the table tblCustomers on the final page of the wizard and click Finish.

Task 2: Modify Table Design

Modify the four imported tables' structures using the given Table Specifications, from the section above, in Microsoft Access using Table Design View.

Task 3: Set Primary Keys

Set the Primary Keys for the four (4) Tables as per the following table specifications in Microsoft Access using Table Design View.

Task 4: Create Relationships between the Tables

Create the following relationships between the four (4) tables:

tblCustomers to tblOrders

tblItems to tblOrders

tblSuppliers to tblItems

Task 5: Edit Customers Table

Edit Customer ID 112 in the Customers Table as per the following instructions in Microsoft Access using Table Datasheet View:

1. Change the Title, Given Names and Family Name to your own details.

2. Change the Address, City, State and Postcode to your own details.

Task 6: Create Data and Update Queries

Create the following Five (5) queries using the Query Design View. Use the names given for each query to avoid confusion for the client (make sure you submit them in the order given below).

Query 1: Out of Stock Statues and Busts Orders:

Query 2: Southern Australian Batman related Orders from a Supplier:

Query 3: Import Duty Canada (CA) Cost Price Increase:

Query 4: Late Dispatched Orders Form Query:

Query 5: Invoice Query with Calculated Fields:

Task 7: Create Data Display Forms

Create the following two (2) data entry forms using the Form Wizard and Form Design.

Form 1: Late Orders Form Display with Calculated Fields:

Form 2: Supplier Items Display Form with Subform:

Task 8: Create an Invoice Report

Stan has provided you with the following sample Invoice. The client requires you to develop a similar invoice for their business.

Task 9: End of Project Presentation to the Client

Dr Zatanna Zatara has asked you to provide a professionally developed business presentation to the client, Stan, outlining the process that was taken in the development of this Database Management System. Create a PowerPoint 2007 to current Presentation and name it '[lastname] [initial] _ [student number] _ [course code] _ [assignment number' (eg. genrichr_0050051005_cis1000_assign1.pptx).

Make sure that your professional developed business presentation is prepared so that it conforms to the course StudyDesk presentation resources. These resources include, but are not limited to, the Practical Appendixes found on the Study Schedule and Module Materials and various videos.

The professional business presentations set of slides should be structured as follows:

Title - outlining the full Business Name, Project Description, Student Name and Student ID.

List of Topics

Presentation Content - the following are the topics the presentation must answer.

Define what a Database Management System is.

Define what a Relational Database is.

Explain why a Database Management System is the appropriate tool for this project.

Explain why this Database Management System was developed as a Relational Database.

Describe what a Database Query is and discuss briefly the five queries that were developed for this project.

Describe what a Database Form is and discuss briefly the two forms that were developed for this project.

Describe what a Database Report is and discuss briefly the report that was developed for this project.

Summary of Presentation

Bibliography.

Attachment:- Information Systems Concepts Assignment Files.rar