Reference no: EM133567747

Database Systems

Overview

In this assessment, you will apply normalization techniques to evaluate the entities designed in Assessment 1 and ensure that all relations are normalized to at least the third normal form (3NF).

Objectives(s)

This assessment item relates to the unit learning outcomes as in the unit descriptor. This assessment is designed to improve students' skills to analyze organization database requirements, normalize a database and use data manipulation language to manage a database. This assessment covers the following LOs.

1. Derive a physical design from the logical design taking into account application, hardware, operating system, and data communications networks requirements; further use of data manipulation language to query, update, and manage a database

2. Identify functional dependencies, referential integrity, data integrity and security requirements; Further integrate and merge physical design by applying normalization techniques.

3. Design and build a database system using the knowledge acquired in the unit as well as through further research on recent trends to demonstrate competence in various advanced tasks with regard to modelling, designing, and implementing a DBMS including Data warehousing, Data Management, DB Security.

Assessment Criteria

This assessment is designed to assess student's knowledge, skill and application of knowledge and skill in relation to
1. Design guidelines for relational schemas.
2. Database design process.
3. Application of normalization techniques.
4. Building a database.
5. Data manipulation language.

Task 1 (Weighting 20%)

Ensure all tables designed in Assignment 1 satisfies the design guidelines for relational schemas.

• Identify any non-semantic columns in each table and transform tables where the tables should have semantic columns.

• Identify tables which could possibly have any anomalies and remove all anomalies from the tables.

• Identify any columns which may have frequently null values and remove or revised those columns. If nulls are unavoidable, then make sure that they apply in exceptional cases only.

• Identify any possibility of spurious tuples and avoid such relations that contain matching columns that are not primary key and foreign key combination.

Task 2 (Weighting 30%)

Apply normalization technique on all tables designed in Assignment 1.

• Identify any repeating group of columns in each table and transform unnormalized tables into tables that are in 1st Normal Form.

• Identify any partial dependencies in each table and transform 1NF table into tables that are in 2nd Normal Form.

• Identify any transitive dependencies in each table and transform 2NF table into tables that are in 3rd Normal Form.

Task 3 (Weighting 50%)

This task must execute on MS SQL Server and be able to be demonstrated. SQL code required (Use MS SQL Server):
• Write a Create database statement to create a database and also, write a Create Table statement for all tables including integrity constraints.

• INSERT INTO statements for populating the database.

o You must at least enter 5 records for each table.
o Data may need to be inserted in a particular order to comply with the integrity constraints.
• SELECT statement that will list all houses / apartments that have not been rented.

o The details may be included like house id, classification, number of bedrooms, number of washrooms, garden, parking for number of cars, rent per day, etc.
• SELECT statement that will produce the total amount paid per customer.

o The details may be included customer id, registration date, customer name, customer address, customer phone number and total amount paid, etc.

IEEE referencing style.

Business Information Systems - Research Study

Topic: The role of Information Systems in the Data Mining process

Information systems serve as a fundamental framework that enables organizations to effectively undertake the data mining process. Data mining is an essential technique utilized within the framework of information systems to extract valuable insights and patterns from extensive datasets. Information systems serve as the foundational infrastructure, offering the required tools and functionalities to support the complete data mining process, encompassing data storage, preprocessing, analysis, and decision support. By leveraging information systems, data miners are empowered to effectively explore and analyze data, ultimately deriving significant insights that enhance decision-making and drive improved business outcomes.
You should perform a literature survey on the role of Information Systems in the data mining process in order to identify the benefits and challenges. Based on your literature survey, you need to create and submit (1) an abstract (2 pages) in IEEE format and (2) a 5-10 mins video presentation explaining the abstract.

This assessment item relates to the unit learning outcomes as in the unit descriptors. This assessment covers the following LOs.
LO2 Develop an IT Plan that designs, implements and manages the technology supporting these information systems including computing devices, storage and processing (both systems processing and application processing).
LO4 Apply appropriate eCommerce or mCommerce business operations and activities that contribute to effective business productivity.
LO5 Appraise an organization's competitive position by applying standards approaches and analyse activities/issues in recruitment, employment relations and performance management and explore emerging business trends through study of published research work.

Object-Oriented Software Development

Learning outcome 1: Demonstrate understanding of classes, constructors, objects, data types and instantiation; Convert data types using wrapper methods and objects.

Learning outcome 2: Independently analyse customer requirements and design object-oriented programs using scope, inheritance, and other design techniques; Create classes and objects that access variables and modifier keywords. Develop methods using parameters and return values.

Learning outcome 3: Demonstrate adaptability in building control and loop structures in an object-oriented environment; Demonstrate use of user defined data structures and array manipulation.

Tank Circuit Program
Adapt your program in Part A to do the following:

Create a Component Class with variables such as Name, Description, Manufacturer, Cost, Obsolete (Y/N)

Create a Capacitor Class that inherent from the Component Class with Constructors, Accessors/Mutators (getters/setters) as appropriate. e.g. variables E, A, D, C.
Create an Inductor Class that inherent from the Component Class with Constructors, Accessors/Mutators (getters/setters) as appropriate. e.g. variables L.

The types in this program the types of components are as follows:

Name: Capacitors Name: Inductors
Description: Store electrical charges.

Warning: Do not use electrolytic capacitors in tank circuits. Description: Store electrical charges.
Manufacturers: Siemens Manufacturers: Motorola
Cost: $0.50 Cost: $0.25
Obsolete: No Obsolete: No

In a Main driver function:

Loop Creating Capacitors instants (until the user Enters "N") Loop Creating Inductors instants (until the user Enters "N")
Populate an arrayList of Components (e.g. tankCircuit[]) while looping //acts like a bill of materials, all the components in the circuit.
If there are two Capacitors (assume they are connected in parallel) add them together before calculating the resonant frequency.
If there are two Inductors (assume they are connected in series) add them together before calculating.

Calculate the Tank Circuit Resonant Frequency, costs of the overall circuit and output to the screen with the description as shown in the sample run.

a. Explain your Design, Control, Flexibility, Error Control of your code
b. Copy of your code as Appendix (screenshot - includes comments in your code)
c. Screenshot of the output of your code as Appendix (3 times with expected values, 2 times with non-expected values - such as a zero as an input)