Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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 ... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Management Accounting Information for Decision-Making and Strategy Execution

Authors: Anthony A. Atkinson, Robert S. Kaplan, Ella Mae Matsumura, S. Mark Young

6th Edition

137024975, 978-0137024971

More Books

Students also viewed these Databases questions