Assignment 2 Assignment 1 Database Management System (DBMS) & Decision Support System (DSS) Description Marks out of Wtg(%) Due date Assignment 1 100.00 20.00 3rd January 2018 IMPORTANT INFORMATION...

hello, can you help me with this assignment?


Assignment 2 Assignment 1 Database Management System (DBMS) & Decision Support System (DSS) Description Marks out of Wtg(%) Due date Assignment 1 100.00 20.00 3rd January 2018 IMPORTANT INFORMATION Academic Integrity · 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. Assignments that do not adhere to this requirement will be deemed as being the result of collusion or plagiarism. This may lead to severe academic penalties as outlined in USQ Policy Library: Academic Integrity Policy and Procedure. It is your own responsibility to ensure the integrity of your work. Refer to the USQ Policy Library for more details: · Academic Integrity Policy · Academic Integrity Procedure Course Expectations · 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, the course discussion forums, appendices and practical related videos, as well as exploring and experimenting on your own. · It is important to make sure you have backups of all assignments you create. This is especially true if you store documents on a flash (thumb) drive. Flash drives can become corrupted or lost very easily. There are many options available (Dropbox, or Google Drive) and USQ students already have access to Google Drive via uConnect - UDrive. Another good idea is to Email your assignment file to yourself every-time you finish working on it, that way you have multiple copies of your progress in case you need to revert to a previous stage or are looking for a piece of information you have mistakenly deleted. Please note that lost or corrupted assignment files is not grounds for an extension. Late submission policy · USQ’s Assessment – Assignment (Late Submission) and Compassionate and Compelling Circumstances procedures relate to Extensions and Late Assignments. They can be found under the following links: · Assessment – Assignment (Late Submission) Procedure · Assessment of Compassionate and Compelling Circumstances Procedures · An Assignment submitted after the due date without an approved extension of time will be penalised. The penalty for late submission is a reduction by five percent (5%) of the maximum mark applicable for the assignment, for each University Business Day or part Business Day that the assignment is late. An assignment submitted more than ten (10) University Business Days after the due date will have a mark of zero recorded for that Assignment. Referencing requirements · References are required and the Harvard AGPS standard of referencing must be used, including in-text referencing. Ensure that your essay is fully referenced, including any references to the text book. Your essay should include a List of References using the Harvard ACPS standards. A useful link on referencing is from USQ’s Library site: · Any direct and paraphrased quotes must be referenced using Harvard AGPS style and listed in the List of References. Do not repeat verbatim large portions of information from other sources such as the text or video – you must put the ideas/information in your own words. Only use small direct quotes where possible. ASSIGNMENT 1 REQUIREMENTS Learning Objectives Applicable course objective: · apply information systems concepts to identify and resolve problems within a business context · apply information systems skills to develop practical solutions within a business context · communicate information systems concepts to both technical and non-technical audiences within a business context. Applicable graduate qualities and skills gained from this assessment instrument: · Problem Solving · Communications Preamble Dr Dan Tooine retired in 2012 after a long career in Pyschology. To keep busy and to fulfil a lifelong dream, Dr Tooine started a Memorabilia mail order business, specialising in Star Wars related products called the “Kashyyyk Collectables” and began selling various types of imported Star Wars merchandise such as statues, iPhone skins, giftware, pop vinyls, mugs, clothing and other assorted Superhero paraphernalia to customers via mail order around Australia. These types of merchandise have become very popular, especially since the Disney’s massive re-start of the movie franchise have brought the phenomenon back into the public’s attention with such movies as Star Wars: Episode 7 – The Force Awakens (2016); Star Wars: Rogue One (2017); and Star Wars: Episode 8 – The Last Jedi (2018). Dr Tooine’s business has experienced a rapid growth in their mail orders. When Dr Tooine first retired, the business bought a personal computer to help manage the books and finances. Kashyyyk Collectables is located at Shop 19, 13 Ares Avenue, Toowoomba (about 100 km west of Brisbane). Their ABN is 126 279 410. Dr Tooine can be contacted via phone on (07) 4632 1856; fax on (07) 4632 1943; or email on [email protected]. Dr Tooine is extremely impressed with our computing firm “Skywalker Technologies” and the business has contracted our firm to assist them in setting up their various computer-based information systems. Part A: The first computer-based information system that Dr Tooine is interested in is a Database Management System (DBMS) utilising Microsoft Access (any version from Access 2007 to current). The DBMS will 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 Tooine 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. Part B: The next computer-based information system that the business is interested in is a Decision Support System (DSS) utilising Microsoft Excel (any version from Excel 2007 to current). The DSS will analyse sales trends for the business to determine future courses of action for the business. Dr Tooine would like the information in the Database Management System (DBMS) (Assignment 1) imported into Microsoft Excel (any version from Excel 2007 to current) so that the information can be summarised as a report and some future analysis of sales trends performed. The suppliers used by the business, source items from either Montenegro (ME) or Belize (BZ). They allow the business to select from either of these two regions on an ad hoc basic depending on the most favourable exchange rate at the time. Dr Tooine has noted that a number of the business’s competitors are providing a discount to customers who place large orders. The business would like to see what affect adopting a similar policy would have on the business. The business has also noted a growing number of online businesses are starting to provide free freight delivery as a way of encouraging more online business; the business would like to run a number of scenarios based on potential Mark-up and Freight options to ascertain the best combination for the business if they were to adopt this policy too. Part C: Dr Tooine also has a number of questions relating to the two computer-based information systems in Part A & Part B that he would like you to answer, prepare an Essay to answer these questions he has listed. All phases in this project must be developed with professionalism and user-friendliness in mind. http://starwars.ea.com/starwars/battlefront/news/start-of-your-star-wars-adventure, DiscoverSG, 2017 Is The Year Of Star Wars. Assignment 1: Part A (Database Management System) Your firm’s Systems Analyst has developed a database structure that has been determined to be suitable to create a database to store Dr Tooine’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), Type, Description, Size, Freight Weight (Kg), Supplier ID, In Stock, On Order, Cost Price (ME)[footnoteRef:1], Cost Price (BZ)[footnoteRef:2]. [1: ME is the country code for Montenegro (their currency is the Euro)] [2: BZ is the country code for Belize (their currency is the Dollar)] 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 Tooine has provided to us a partial list of the business’s customers, stock items, and suppliers and a partial list of her postal orders for the third quarter 2017 (Jul – Sept) to use as test data in four comma delimited text files which can be found on your firm’s Intranet (CIS5100 Study Desk). Mrs Skellig Michael, 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 an Invoice Report 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_cis5100_assign1.accdb). Import the four sets of data from your firm’s Intranet (CIS5100 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