Critically examine the importance of data privacy

Assignment Help Database Management System

Reference no: EM133802189

Assessment: Database Design, Implementation, and Presentation

Your task Students will develop a database using SQL on a DBMS. This assignment has two parts:
Presentations in week 6. Students will present an overview of the database design they created and describe the database they developed by applying a series of SQL commands.

Students will submit a report in week 6. The report will discuss different approaches to tuning the database performance and potential security risks along with the required countermeasures.

LO 1. Model data for various business scenarios.
LO 2. Design and construct relational databases using an industry standard language such as SQL.
LO 3. Perform search/retrieval and data manipulation processes using an industry standard language such as SQL.
LO 4. Critically examine the importance of data privacy, security, and ethical considerations in data modelling and database design.

TASK 1: DDL
Your main task for this assignment is to build a database using the conceptual model you developed for Assignment 3. You should carefully read the 3NF schema you designed in Assignment 3 and ensure you understand the relationships between tables and the various data requirements. Check the feedback you received for Assignment 3, update the schema as necessary, and include the revised 3NF schema.
Next, using the revised 3NF schema, proceed to create the corresponding database tables. Use SQL on SQLite to create these tables and

relationships. Ensure that each table is correctly structured according to the schema, with appropriate primary and foreign keys defined to maintain the integrity of the relationships.
Syntax for Create table command:

CREATE TABLE table_name (
column1 datatype, column2 datatype, column3 datatype,
....
);

TASK 2: INSERT
Populate your tables with at least 5 sample data records to test the database functionality. Use INSERT INTO statements to populate tables
Syntax :
INSERT INTO table_name (column1, column2, column3, ...) VALUES (value1, value2, value3, ...);

TASK 3: DML
Once the database is populated, it will be used to carry out specified DML commands and make specified changes to the database structure via SQL. Design your test data so that you get output for the SQL queries you will use to answer the following questions.

Write SQL queries to

Kingston City Council (SKCC) would like to determine the total number of members registered under each club. The list should include Club_ID and the total number of members registered for each club, Order the list in increasing order of the club ID. Get Personalised Assignment help Now!
SKCC is now planning to award prizes to all members who participated in competitions in the year 2023. The data analyst at SKCC would like to prepare a list with Member_name, Club_ID, Contact_no, Competition_ID, and the competition date of all competitions in 2023.

TASK 4: Presentation - WEEK 6
The presentation will involve an overview of the database design and applying a series of SQL commands over the DBMS.

TASK 5: Report -WEEK 6
The report will

Provide Answers to All Questions in TASK 1 - TASK 3:
Ensure that each question in TASK 1 through TASK 3 is thoroughly addressed. This includes detailed explanations, supporting data, and necessary SQL queries used to derive the answers. Each response should be clear, concise, and directly related to the question posed.

Discuss Database Performance Tuning Approaches and Security Measures:
Database Performance Tuning Approaches:
Outline various strategies for optimizing the performance of the database. This may include indexing strategies, partitioning of large etc.

Discuss how each approach can improve database performance, providing examples or case studies where applicable.

Evaluate the pros and cons of each approach, considering factors such as ease of implementation, cost, and impact on performance.
Potential Security Risks and Required Countermeasures:
Identify potential security risks associated with the databases
For each identified risk, propose specific countermeasures. These might include implementing robust authentication and authorization
..etc.
Discuss the importance of these security measures in maintaining the integrity, confidentiality, and availability of the database.

By covering these areas in detail, the report will not only address the specific questions posed in TASK 1 to TASK 3 but also provide a comprehensive overview of how to enhance database performance and security.

Reference no: EM133802189

Questions Cloud

What would be a good sermon on standing on promises of god : What would be a good sermon on Standing on the Promises of God?

What is significance of spirit in world-hearers of word : What is the significance of the titles of these books by Rahner: "Spirit in the World", "Hearers of the Word"?

Explain how the study was carried out : Explain how the study was carried out. Provide measures that could assess the variables that should be affected by your intervention.

How do these verses relate to what macbeth is doing in act : How do these verses relate to what Macbeth is doing in the Act?

Critically examine the importance of data privacy : Critically examine the importance of data privacy, security, and ethical considerations in data modelling and database design

What client or family members tell you about the client sign : What the client or family members tell you about the client's signs and symptoms and the reason for seeking healthcare.

Review all the various definitions of nursing presented : NUR 232- Review all the various definitions of nursing presented in your Learning Resources, especially the ANA, the CNA, and the various nursing theory.

Who is the one major educational philosopher : Who is the one major educational philosopher that you believe might not have been needed? What would be the implications if this philosopher had not been born?

Identify the family strengths as well as nadias strengths : Identify the family strengths as well as Nadia's strengths. Identify some strategies to support the child using Response to Intervention.

User Account

All Pages