Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

There is now medicine_YourName table includes the following fields: Field name The data type Description medicine_id int primary key medicine_name varchar(40) not null major_function varchar(1000)

image text in transcribed

There is now "medicine_YourName" table includes the following fields: Field name The data type Description medicine_id int primary key medicine_name varchar(40) not null major_function varchar(1000) manufactor varchar(40) telephone char(11) 1. Create this table in the "test" database. 2. Create a view "V_with_cin_in_the_medicine_name" to query the medicine information with 'cin' in the "medicine_name". 3. Create a stored procedure "Pro_Search_medicine_by_phone", and query the corresponding medicine information through "phone" as the input parameter. 4. Create a before trigger "Tr_Added_medicine_cannot_have_duplicate" to add records to the "medicine" table. If there is no "medicine_name" in the "medicine" table, it will be added normally. Otherwise, it will prompt 'The medicine already exists and cannot be added

Step by Step Solution

There are 3 Steps involved in it

Step: 1

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

Murach's SQL Server 2012 For Developers

Authors: Bryan Syverson, Joel Murach, Mike Murach

1st Edition

1890774693, 9781890774691

More Books

Students also viewed these Databases questions