SBM4102 Data and Information Management

SBM4102 Data and Information Management

[ad_1]

Page | 1
Asia Pacific International College Pty Ltd. Trading as Asia Pacific International College
55 Regent Street, Chippendale, Sydney 2008: 02-9318 8111
PRV12007; CRICOS 03048D
Approved: 13/02/2019, Version 1
Unit Code and Title: SBM4102 Data and Information Management
Assessment Overview

Assessment Task Weighting Due Length ULO
Assessment 1: Database
Interrogation		 40% Weeks 2, 4, 6,
8, 10		 N/A ULO-1
ULO-2
ULO-3
ULO-4
ULO-5
ULO-6
ULO-7
Assessment 2: Applied Project -1
(Individual)		 30% Week 7 2000 words ULO-1
ULO-2
ULO-3
Assessment 3: Applied Project –
2 (Group)		 30% Week 11 2000 words ULO-1
ULO-2
ULO-3
ULO-4
ULO-5
ULO-6
ULO-7

SBM4102 Assessment Brief
Page | 2
Asia Pacific International College Pty Ltd. Trading as Asia Pacific International College
55 Regent Street, Chippendale, Sydney 2008: 02-9318 8111
PRV12007; CRICOS 03048D
Approved: 13/02/2019, Version 1
Assessment 1: Database Interrogation

Due date: Weeks 2, 4, 6, 8, 10
Group/individual: Individual
Word count / Time provided: N/A
Weighting: 40%
Unit Learning Outcomes: ULO-1, ULO-2, ULO-3, ULO-4, ULO-5, ULO-6, ULO-7

Assessment Details:
Database Interrogation are practical exercises that assess students’ ability to apply theoretical
learning to practical database questions. This assessment will improve student’s ability to design
databases and write SQL queries.
Students will not be assessed on work that the tutor has not seen them produce in class so that
attendance is required as part of this assessment. Students are required to submit the work that
they have completed during the lab session. The details of the lab work and requirements are
provided on the online learning system.
Marking Information: The assessments will be marked out of 100 and will be weighted 40% of the
total unit mark.
Page | 3
Asia Pacific International College Pty Ltd. Trading as Asia Pacific International College
55 Regent Street, Chippendale, Sydney 2008: 02-9318 8111
PRV12007; CRICOS 03048D
Approved: 13/02/2019, Version 1
Assessment 2: Applied Project-1

Due date: Week 7
Group/individual: Individual
Word count / Time provided: 2000 words
Weighting: 30%
Unit Learning Outcomes: ULO-1, ULO-2, ULO-3
Course Learning Outcomes: [CLO1], [CLO2], [CLO3], [CLO7], [CLO9]

Assessment Details:
The Blue Mountains Financial Services company provides financial services (banking, advisory, tax
consulting, auditing, insurance, wealth management etc.) to customers.
The company has contracted an outsourcing IT company to develop an Information System.
The System database should satisfy the following business rules:
• The company wants to keep employees and customers in the database under one entity
Person. Each Person has at least one BankAccount. The Person attributes are: pID, pName,
pAddress. The BankAccount attributes are: baID, baName, baType, baBalance.
• Each Person belongs to a category: Seller, Customer or Representative. Customer can also
be Representative, i.e. he/she can provide services to customers.
• Seller can be one of the categories: category 1 or category 2.
• Customer can be one of two categories: private or corporate.
• Representative can be employed as casual or on a contract.
• Seller/Representative provide Services.
• Seller/Representative can have more than one Customer.
• Seller/Representative signs an Agreement with a Customer.
• Agreement contains at least one of the Services provided by the company.
• Agreement can be one of two types: a contract or an order.
• Seller/Representative issues Invoice to Customer for services
• Each Invoice contains Invoice Items.
• Each Invoice Item is one of the Services.
Your assignment consists of two parts.
Part 1. Conceptual Model
• Identify Entities
• Identify entity supertypes and subtypes and their types, inheritance, and discriminators.
• Describe relationships between entities and their cardinalities
• Identify entity primary keys
• Draw a Conceptual Model Entity-Relationship diagram
Part 2. Logical Model
• Describe data attributes and their types for each entity
• Identify foreign keys for each entity
Page | 4
Asia Pacific International College Pty Ltd. Trading as Asia Pacific International College
55 Regent Street, Chippendale, Sydney 2008: 02-9318 8111
PRV12007; CRICOS 03048D
Approved: 13/02/2019, Version 1
• if there are any one-to-one relationships then describe them
• Redesign the Conceptual model removing many-to-many relationships (if any)
• Draw a Logical Model diagram
Marking Information: The assessments will be marked out of 100 and will be weighted 30% of the
total unit mark.
Page | 5
Asia Pacific International College Pty Ltd. Trading as Asia Pacific International College
55 Regent Street, Chippendale, Sydney 2008: 02-9318 8111
PRV12007; CRICOS 03048D
Approved: 13/02/2019, Version 1

Marking Criteria Not
satisfactory
(0-49%) of
the criterion
mark)		 Satisfactory
(50-64%) of the
criterion mark		 Good
(65-74%) of the
criterion mark		 Very Good
(75-84%) of the
criterion mark		 Excellent
(85-100%) of
the criterion
mark
Demonstrate an
understanding and
describing the
Conceptual Model
design processes
(20%)		 Inadequate
understanding
and describing
Conceptual
Model design
process		 Basic knowledge
only of
understanding
and describing
Conceptual Model
design process		 Exhibits breadth
and depth of
understanding
and describing
Conceptual Model
design process		 Exhibits accurate
and detailed
breadth and
depth of
understanding
and describing
Conceptual Model
design process		 Displays
exceptional
understanding of
concepts and their
practical
application in
Conceptual Model
design process
Demonstrate an
understanding and
describing the
Logical Model
design processes
(20%)		 Inadequate
understanding
and describing
Logical Model
design process		 Basic knowledge
only of
understanding
and describing
Conceptual Model
design process		 Exhibits breadth
and depth of
understanding
and describing
Conceptual Model
design process		 Exhibits accurate
and detailed
breadth and
depth of
understanding
and describing
Conceptual Model
design process		 Displays
exceptional
understanding of
concepts and their
practical
application in
Conceptual Model
design process
Demonstrate
understanding and
skills of creating the
Conceptual Model
diagram (30%)		 Inadequate
understanding
and skills of
creating the
Conceptual
Model diagram		 Basic
understanding
and skills of
creating the
Conceptual Model
diagram		 Exhibits breadth
and depth of
understanding
and skills of
creating the
Conceptual Model
diagram		 Exhibits accurate
and detailed
breadth and
depth of
understanding
and skills of
creating the
Conceptual Model
diagram		 Displays
exceptional
understanding and
skills of creating
the Conceptual
Model diagram
Demonstrate
understanding and
skills of creating the
Logical model
diagram (30%)		 Inadequate
understanding
and skills of
creating the
Logical Model
diagram		 Basic
understanding
and skills of
creating the
Logical Model
diagram		 Exhibits breadth
and depth of
understanding
and skills of
creating the
Logical Model
diagram		 Exhibits accurate
and detailed
breadth and
depth of
understanding
and skills of
creating the
Logical Model
diagram		 Displays
exceptional
understanding and
skills of creating
the Logical Model
diagram

Page | 6
Asia Pacific International College Pty Ltd. Trading as Asia Pacific International College
55 Regent Street, Chippendale, Sydney 2008: 02-9318 8111
PRV12007; CRICOS 03048D
Approved: 13/02/2019, Version 1
Assessment 3: Applied Project-2

Due date: Week 11
Group/individual: Group
Word count / Time provided: 2000 words
Weighting: 30%
Unit Learning Outcomes: ULO-1, ULO-2, ULO-3, ULO-4, ULO-5, ULO-6, ULO-7
Course Learning Outcomes: [CLO1], [CLO2], [CLO3], [CLO7], [CLO9]

The Trade Master company sells various tools. It has sales offices and warehouses all over Australia.
The company developed a data warehouse to store information about sales, customers and
products. These data are stored in the AppliedProject2 Access file provided for you.
The database consists of 6 tables:
• CompanyDim – with the sales office address, state and email
• ProductDim – product information
• WarehouseDim – warehouse locations
• CustomerDim – information about customers
• DateDim – sales dates
• SaleFacts – information about sales
Please notice that all data (customers, sales, dates, warehouses and products) are randomly
generated. Table and field names are self-explanatory.
The Global Trading company wants to retrieve information from the database for reporting and data
analysis.
You must do the following tasks
1. In the MS Word document:
a. Analyse and describe the tables.
b. Describe dimension and fact tables. (You need to remember that the database
tables are organised into a fact and dimension tables, and this structure is called a
database star schema).
c. Identify and describe primary and foreign keys.
d. Draw the database diagram.
e. Copy from the database all queries to the Word document and explain them.
2. In the MS Access database, you need to write, save and run the following SQL queries:
a. Create all primary and foreign keys.
b. Insert a new customer. Devise your own data for this record.
c. Create a new sale fact related to the new customer. You can choose any existing
product, warehouse, date and sales office.
d. Display all customer names, their addresses and states.
e. Display all customer names from NSW.
f. Display the total amount of all company sales in 2018.
Page | 7
Asia Pacific International College Pty Ltd. Trading as Asia Pacific International College
55 Regent Street, Chippendale, Sydney 2008: 02-9318 8111
PRV12007; CRICOS 03048D
Approved: 13/02/2019, Version 1
g. Display total amount of sales for each customer separately.
h. Display total amount of sales for each product and state separately, i.e. the output
should contain 3 columns: product, state and total amount for this product and
state.
i. Display products sold from warehouses located in QLD.
j. For each sale, display a customer name and a purchase date.
k. Display a total number of sales (NOT AMOUNT!) for each customer.
l. For each sales office (branch), display: branchKey, branch state, a customer name (a
customer purchased in this office), a product name purchased by this customer, and
a month number of the purchase.
Your submission should consist of the following documents:
• MS Word document containing answers to the Task 1
• MS Access file with stored SQL queries from Task 2
Marking Criteria and Rubric: The assessment will be marked out of 100 and will be weighted 30%
of the total unit mark.
Page | 8
Asia Pacific International College Pty Ltd. Trading as Asia Pacific International College
55 Regent Street, Chippendale, Sydney 2008: 02-9318 8111
PRV12007; CRICOS 03048D
Approved: 13/02/2019, Version 1

Marking Criteria Not
satisfactory
(0-49%) of
the criterion
mark)		 Satisfactory
(50-64%) of the
criterion mark		 Good
(65-74%) of the
criterion mark		 Very Good
(75-84%) of the
criterion mark		 Excellent
(85-100%) of
the criterion
mark
Demonstrate
understanding of
database design and
ability to draw
database diagrams
(20%)		 Inadequate
understanding
of database
design and
database
diagrams.		 Basic knowledge
only of
understanding
and of database
design and
database
diagrams.		 Exhibits breadth
and depth of
understanding of
database design
and database
diagrams.		 Exhibits accurate
and detailed
breadth and
depth of
understanding of
database design
and database
diagrams.		 Displays
exceptional
understanding of
database design
and database
diagrams.
Demonstrate
understanding of
database primary
and foreign keys,
and database
referential integrity.
(10%)		 Inadequate
understanding
of database
primary and
foreign keys,
and database
referential
integrity.		 Basic knowledge
only of
understanding of
database primary
and foreign keys,
and database
referential
integrity.		 Exhibits breadth
and depth of
understanding of
database primary
and foreign keys,
and database
referential
integrity.		 Exhibits accurate
and detailed
breadth and
depth of
understanding of
database primary
and foreign keys,
and database
referential
integrity.		 Displays
exceptional
understanding of
database primary
and foreign keys,
and database
referential
integrity.
Demonstrate an
understanding and
ability to write and
run simple SQL DDL
and DML queries
(20%)		 Inadequate
understanding
and ability to
write and run
simple SQL DDL
and DML
queries		 Basic knowledge
only of
understanding
and ability to
write and run
simple SQL DDL
and DML queries		 Exhibits breadth
and depth of
understanding
and ability to
write and run
simple SQL DDL
and DML queries		 Exhibits accurate
and detailed
breadth and
depth of and
ability to write
and run simple
SQL DDL and DML
queries		 Displays
exceptional
understanding and
ability to write and
run simple SQL
DDL and DML
queries
Demonstrate
understanding and
skills of writing
advanced SQL
queries, including
table joins, MS
Access functions and
aliases (50%)		 Inadequate
understanding
and skills of
writing
advanced SQL
queries,
including table
joins, MS
Access
functions and
aliases.		 Basic
understanding
and skills of
writing advanced
SQL queries,
including table
joins, MS Access
functions and
aliases.		 Exhibits breadth
and depth of
understanding
and skills of
writing advanced
SQL queries,
including table
joins, MS Access
functions and
aliases.		 Exhibits accurate
and detailed
breadth and
depth of
understanding
and skills of
writing advanced
SQL queries,
including table
joins, MS Access
functions and
aliases.		 Displays
exceptional
understanding and
skills of writing
advanced SQL
queries, including
table joins, MS
Access functions
and .aliases

[Button id=”1″]

[ad_2]

Source link

"96% of our customers have reported a 90% and above score. You might want to place an order with us."

Essay Writing Service
Affordable prices

You might be focused on looking for a cheap essay writing service instead of searching for the perfect combination of quality and affordable rates. You need to be aware that a cheap essay does not mean a good essay, as qualified authors estimate their knowledge realistically. At the same time, it is all about balance. We are proud to offer rates among the best on the market and believe every student must have access to effective writing assistance for a cost that he or she finds affordable.

Caring support 24/7

If you need a cheap paper writing service, note that we combine affordable rates with excellent customer support. Our experienced support managers professionally resolve issues that might appear during your collaboration with our service. Apply to them with questions about orders, rates, payments, and more. Contact our managers via our website or email.

Non-plagiarized papers

“Please, write my paper, making it 100% unique.” We understand how vital it is for students to be sure their paper is original and written from scratch. To us, the reputation of a reliable service that offers non-plagiarized texts is vital. We stop collaborating with authors who get caught in plagiarism to avoid confusion. Besides, our customers’ satisfaction rate says it all.

Home

About Us

Professional Writing Services

Contact Custom Essay Writers

Register as a freelance writer

Order Custom Essay

Sign Up

Login

Facebook Twitter Youtube Instagram

© 2022 Homeworkcrew.com provides writing and research services for limited use only. All the materials from our website should be used with proper references and in accordance with Terms & Conditions.

Scroll to Top