Write sql queries to insert some data into each table

Assignment Help Database Management System

Reference no: EM133853183

Database Fundamentals

Assessment Item

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.

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

SQL Server workbench
Postgresql
MS SQL Server
DBreaver
Microsoft Data Studio

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

Reference no: EM133853183

Questions Cloud

Stages of psychosocial development : In what order would Ahmad place the stages of psychosocial development as determined in Freud's psychoanalytical model of personality development?

Which statement made by client indicate further teaching : The nurse is caring for a client who requires droplet precautions. Which statement made by the client would indicate further teaching is required?

Which situations appropriate for using alcohol-base hand rub : After teaching an in-service presentation about hand hygiene and the use of soap. Which situation(s) as appropriate for using an alcohol-based hand rub?

How would techniques in a real-life situation from company : Explain how you would use the following techniques in a real-life situation from your company or a company of your choosing: benchmarking, data mining.

Write sql queries to insert some data into each table : Write SQL queries to create the table. Select suitable data types for each attribute and identify appropriate primary and foreign keys as needed

Explain core concepts related to corporate valuation : Explain core concepts related to corporate valuation and governance and to identify strategies for conducting business with personal and professional integrity.

Demonstrate the third normal form : You will need to implement the normalization process on unstructured tables provided - Create a relational schema and demonstrate the Third Normal Form

What is registration that a licensee-in-charge needs to hold : Officer in Effective Control (OIEC) / Principal Agent a. What is the minimum licence or registration that a licensee-in-charge needs to hold?

Databases integrity and safeguard its security : Examine the database established during Activity 1 and deliberate on the various forms of user access permissions necessary to uphold the database

User Account

All Pages