Answered step by step
Verified Expert Solution
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)
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
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