Develop and document a small database system

Assignment Help Database Management System
Reference no: EM133119123

ICT412 Solution Design

Assignment Portfolio

Course aim

To introduce students to the process involved in designing solutions to meet business requirements and the relationship between business and information systems that support the business.

Purpose
Learners will gain an understanding of Role of internet and social media in modern business, Information system theory, Information system analysis and creating database management solution for business

Learning Outcome 1: Use Information Systems Analysis techniques and tools and apply User Experience principles to analyse and document business information systems

Learning Outcome 2: Review user requirements and use interface design principle to develop and document a small database system to provide a solution for an organisation.

Learning Outcome 3: Evaluate the suitability of computer applications and select, justify and communicate a solution that meets the evaluation criteria

1. Apply essential knowledge and concepts of business analysis, database, and user experience to provide a foundation for supporting organisational information systems requirements.
2. Contribute to user interface design using essential knowledge and concepts of web design.
3. Apply essential knowledge and concepts of software development to provide a foundation for developing applications.
4. Apply project management and planning tools to meet the requirements of specified briefs and provide a foundation for IT Profession.
5. Apply appropriate professional, ethical and legal principles and practice to comply with legal and organisational requirements and provide a foundation for the IT profession
6. Communicate Clearly and professionally to maintain relationships and achieve objectives in a range of contexts within the IT Industry.

Assessment

Scenario
Alpha Sales Limited is growing Electronic retail company in Auckland. Company is currently operating its store in all Westfield malls. Demand for its product has grown over the period and decentralized POS system has affected its operational processes.

Company has contacted Advance Information System Solutions Limited to manage this issue and propose the system that centralise their information and ensure effective and efficient operation all over Auckland. The major agenda of going ahead with this proposal is to enhance profitability by 15% as well as lower shrinkage and effective inventory management.

You are appointed as a System Analyst by Advance Information System Solutions Limited. You are pointed on your first assessment with Alpha Sales Limited.

To complete this assignment, you need to complete following tasks

Task 1
You are required to analyse and evaluate Two database management systems against set criteria for Alpha Sales Limited and recommend one that best suit to Alpha Sales Limited Needs.

Your set criteria must include following seven (7) evaluating criteria's. Cost, hardware requirements, software requirements, reliability, ease of use, training requirements, and user support.

Task 2. Database Plan
By using Information System Theories and Analysis prepare a Project Management Plan for proposed database system to Alpha Sales Limited.

You Plan should include but not limit to

Task 3: Creating Database and Test

Based on your proposed plan create database to meet the needs of your client. Your Database Management System must include following

• Tables - Create minimum three tables example: Customer, Order and Product. Every table should have a primary key and foreign keys. Each should have minimum five (5) entities.
• Forms - Design minimum three (3) forms with company logo and different colours.
• Queries - Create minimum three queries of the organisation to use.
• Report - Generate a detailed report with company logo.
• Testing: Once you have created the database, you must test the database to verify that it meets both the design you have created and the organisation's requirements
• Others Special requirements are
• Apply security on the database e.g., password and copyright.
• Your database needs to look professional i.e., clear headings

Task 4: Create a simple end-user document for the database. 

End-User Documentation

Name of database table:

 

Purpose of the database:

 

Created by:

 

Date created:

 

File location:

 

Steps:

Attachment:- Solution Design.rar

Reference no: EM133119123

Questions Cloud

Operations of mutual funds and insurance companies : Your response should indicate that you understand the risks and the operations of mutual funds and insurance companies. You should also be sure to support your
Pros and cons of possessing self-monitoring personality : Discuss the pros and cons of possessing this self-monitoring personality factor. Identify how the performance of employee can be improved and properly assesed
Economic characteristics and competitive dynamics : Identify the economic characteristics and competitive dynamics in the industry that TJX competes in. Chose one of the three methods discussed in Chapter 1 (Port
What is the standard deviation : You plan on selling the bond in one year and believe that the required yield next year will have the following probability distribution:
Develop and document a small database system : Designing solutions to meet business requirements and the relationship between business and information systems that support the business
What is the book value of deloits''s equipment at december : Deloits's equipment averages 3.5 years at December 31, 2019. What's the book value of Deloits's equipment at December 31, 2019
How vital is it to understand the importance of time : How does the time value of money affect your everyday life, and how vital is it to understand the importance of time?
Collective bargaining : How does an arbitrator determine that a company had just cause for taking a disciplinary action?
What the amount of interest that refract should capitalize : The company's fiscal year-end is December 31. What's the amount of interest that Refract should capitalize in 2017, using the specific interest method

Reviews

Write a Review

Database Management System Questions & Answers

  Knowledge and data warehousing

Design a dimensional model for analysing Purchases for Adventure Works Cycles and implement it as cubes using SQL Server Analysis Services. The AdventureWorks OLTP sample database is the data source for you BI analysis.

  Design a database schema

Design a Database schema

  Entity-relationship diagram

Create an entity-relationship diagram and design accompanying table layout using sound relational modeling practices and concepts.

  Implement a database of courses and students for a school

Implement a database of courses and students for a school.

  Prepare the e-r diagram for the movie database

Energy in the home, personal energy use and home energy efficiency and Efficient use of ‘waste' heat and renewable heat sources

  Design relation schemas for the entire database

Design relation schemas for the entire database.

  Prepare the relational schema for database

Prepare the relational schema for database

  Data modeling and normalization

Data Modeling and Normalization

  Use cases perform a requirements analysis for the case study

Use Cases Perform a requirements analysis for the Case Study

  Knowledge and data warehousing

Knowledge and Data Warehousing

  Stack and queue data structure

Identify and explain the differences between a stack and a queue data structure

  Practice on topic of normalization

Practice on topic of Normalization

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