Question
This project consists of completing a different group of tasks using a database created by you. The minimum requirements for the database design are: Insert
This project consists of completing a different group of tasks using a database created by you. The minimum requirements for the database design are:
Insert at least three tables into your database.
implement at least three columns per table, be creative when it comes to the data types of your variables.
In addition, insert 7 records per table.
Define a primary key for each table and make use of the foreign key concept in a query.
Once you have finished with the database design, please follow the instructions listed below:
1- Add a constraint to a column in any of the tables. (Example: add constraint minimum_date check(Transaction_date >='01.01.2019')...) 1.1- Test the constraint by inserting a new record that violates it. 2- Run at least three queries: 2.1- One query should involve at least three different tables. 2.2- In at least one of them, Join operators must be used. 2.3- In at least one of the queries you should use the HAVING clause. 3- Update a column based on a condition that needs to be met using the where clause. 4- Retrieve data with a query directly into a variable. The variables must be initially declared. The final query must return the minimum and maximum values through the variables previously declared. . 5- You must create a procedure that returns full details of one of the tables of your choosing based on a given condition using the WHERE clause.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Database Design Constraint To test this constraint ...Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started