Examine the database established during activity

Assignment Help Database Management System

Reference no: EM133823586

Database Fundamentals

Assessment:

Introduction
For this assignment, you will need to construct a database, execute CRUD operations within the SQL database, and engage in a discussion concerning data security concerns.

Activity 1: SQL Queries (Case Study):
Activity 1 is the continuation for the assessment 1. Victorian Hospital is very pleased with your report and has approved the report. Based on the ER diagram created in assessment 1, you are to create the database.
Write SQL queries to create the table. Select suitable data types for each attribute and identify appropriate primary and foreign keys as needed.
Write SQL queries to insert some data into each table (At least 10 records).
Write the SQL queries for the tables created
Create 5 SQL queries.
Create a View.
Complexity of the query.
You are required to use a database tool to run the query. Screenshots of the query and result should be included in the report.

Activity 2: Database Administration
Examine the database established during Activity 1 and deliberate on the various forms of user access permissions necessary to uphold the database's integrity and safeguard its security. Additionally, explore the potential security concerns that could emerge if user inputs aren't adequately validated before being utilized as queries within the database. Support your analysis with relevant instances drawn from a case study. Get Assistance Now!!

Tools Required
For this assessment, you are expected to use from the following tools for the database:
Postgresql

MS SQL Server
DBreaver
Microsoft Data Studio
Azure Data Studio Additional Tools This is for the advanced user.

The format structure for the report You are required to follow the following structure for this assessment. Below is the description for the report: • Introduction
Task 1
Task 2
Conclusion
Submission Guidelines
You need to answer all the questions, use appropriate diagrams where required and submit them in one report (.docx/pdf) file.
Your report needs to follow the naming convention below:
"Assignment 3_X_YY.docx" where X is your name and Y is your student ID.
The assignment is to be submitted via the Assignment 3 submission link in LMS.

Reference no: EM133823586

Questions Cloud

Survive in environment case select strategy : There are two types of life strategies used by organism to survive in the environment case select strategy and our select strategy

Is employee burnout and employee engagement impacted : Is employee burnout and employee engagement impacted by a leader who does not appear interested or involved?

Analysts job outcomes addressed in this activity : Assignment: Business Processes and the Analyst's Job Outcomes addressed in this activity

Concerning the cost overruns on artwork : Horst walks into the Tuesday meeting and is immediately confronted by Javier concerning the cost overruns on artwork.

Examine the database established during activity : Examine the database established during Activity and deliberate on the various forms of user access permissions necessary to uphold the database's integrity

Create a relational schema and demonstrate the 3nf : Create a relational schema and demonstrate the Third Normal Form (3NF) for the database and table design you had created in your first assignment

New procedure for production line : You have just selected eight of your employees to sit on a team to propose a new procedure for the production line,

Five critical success factors : What are the top five critical success factors that the company has to consider as it initiates the project?

Write specification from entity relationship diagram : Compose the operational guidelines for the Entity-Relationship Diagram in activity 1. Exclude attribute descriptions and focus on specifying all cardinalities

User Account

All Pages