Reference no: EM131286508 , Length:
Context:
The aim of this assessment is to assess the student's ability to solve business problems using database design tool and software. It also aims to enable students to think about the impacts of using IT in Businesses and communicate key issues through a written report.
Many companies depend on the accurate recording, updating and tracking of their data on a minute-to-minute basis. Employees access this data using databases. An understanding of this technology allows business professionals to be able to perform their work effectively.
GAAM'S DATABASE REQUIREMENTS:
1. GAAM needs a new database designed and implemented given the information provided above.
2. They also need the following forms created:
a. Customer Information Form
b. Sales Representative Form
c. Order Form
d. Product Information Form
3. The following are some of the queries that should be answered by the database:
a. List of all products they are selling (product id, product name, category)
b. List of all the customers (customer no. and customer name) who lives in the state of Victoria (VIC).
c. List of all sales representatives with commission rate greater than 5%.
d. List of all customers (customer no. and customer name) and their sales representatives name.
e. List of all sales representatives no., sales rep name, product no., product name ordered during the month of May.
4. Priority reports that are needed are the following:
a. List of products (Product, id, product name, category, product price and quantity on hand)
b. List of all customers (customer no., customer name, address) with balances greater than 5000
c. List of sales representatives (sales rep no., sales rep name) and their commission. Report should show in order (from highest to lowest) the sales rep commission.
Instructions:
Students are expected to develop a database given the same organisational brief used in assessments 1-3. Students need to design and implement the database using LibreOffice Base. Additional information is provided below and some tasks will be done during the week you are expected to implement a practical activity.
The following are the list of requirements:
- Explain why is the organisation needs to use a database.
- Create anE-R Diagrams using Diagram Editor
- Convert the E-R diagrams to tables and convert to Third Normal Form
- Create database tables using LibreOffice Base
- Create queries and forms using LibreOffice Base and SQL
- Identify IT controls needed and ethical, privacy and security issues the organisation might encounter when using databases.
Criteria
- Need for the implementation of the database
- E-R Diagram
- Normalised Database Tables
- Queries
- Forms and Reports
- IT Controls, Ethical, Privacy and Security Issues
|
Derive transient two-dimensional finite-difference equation
: Derive the transient, two-dimensional finite-difference equation for the temperature at nodal point 0 located on the boundary between two different materials.
|
|
Describe how the message is executed
: Describe how the message is executed. Discuss what is good and bad about the ad. Do you think the ad will be effective? Why or why not?
|
|
Flexible budget be based upon
: Prior to the start of 2013. Proctor inc. estimated budgeted salesat 225000 units. beginning of 2013 there were 8000 inits in beginning finished goods. During 2013 215000 units were sold. how many units should proctors 2013 flexible budget be based up..
|
|
Calculate the grps for each media
: Calculate the GRPs for each media buy based on the information given.- Calculate the CPM for each media buy.- Tell why you would select the four.
|
|
Create database tables using libreoffice base
: Create database tables using LibreOffice Base - Create queries and forms using LibreOffice Base and SQL and - Identify IT controls needed and ethical, privacy and security issues the organisation might encounter when using databases.
|
|
Prepare summary budget for march
: Prepare a summary budget for March. Cash Balance March 1st is 3000. Sales in March estimated to be 50000. Sales collected over two month period 65% in March & 35% in February with sales of 60000 in Feb. Inventory purchase in March 20000. Cash disburs..
|
|
Find the temperature distribution in the wall
: Using the implicit, finite-difference method with a time increment of 1 h, find the temperature distribution in the wall 5, 10, 50, and 100 h after introduction of the flue gases.
|
|
Are consumers being deceived when a firm pays
: Firms are increasing their use of search engine marketing in which they pay search engines such as Google and Bing for priority position listings.
|
|
Completion of assigned goals and objectives
: What leadership skills are required to ensure that all group/team members contribute to the completion of assigned goals and objectives?
|