Write sql queries to create the table

Assignment Help Database Management System

Reference no: EM133822141

Database Fundamentals

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. Book Our Writers Now!

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:
Postgresql

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

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: EM133822141

Questions Cloud

Example of an article that has been useful and applicable : Describe your experience with reading research articles - Share an example of an article that has been useful and applicable to your practice

What are two significant ways that modern russian approach : What was key similarity between fascist and Soviet communist? What are two significant way that modern Russian approach to happiness differ from that of West?

How dei benefits any healthcare workforce sector of choice : Develop a 10 to 12 pages PowerPoint presentation on how DEI benefits any healthcare workforce sector of your choice.

What considerations might you need to contemplate : What considerations might you need to contemplate when choosing the intensity an activity for an adolescent counseling or therapy group?

Write sql queries to create the table : Construct a database, execute CRUD operations within the SQL database, and engage in a discussion concerning data security concerns

Explain advantages for each specific data collection source : Explain the advantages and disadvantages for each specific data collection source by using examples and citing cases from the resource link provided above.

Implement the normalization process on unstructured tables : Implement the normalization process on unstructured tables - Create a relational schema and demonstrate the First Normal Form (1NF), Second Normal Form (2NF)

Compute the ending inventory and cogs at september thirty : Compute the ending inventory and COGS at September 30 on each of the following on periodic bases. Explain the above with numerical examples.

What is the etiology of the selected sti : What is the pathophysiology of one STI? What is the etiology of the selected STI? What are the clinical manifestations of the selected STI?

User Account

All Pages