Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Write the SQL commands for the following details: Design the Relational Schema for a plant nursery in your area. Your design should consist of

Write the SQL commands for the following details: Design the Relational Schema for a plant nursery in your

Write the SQL commands for the following details: Design the Relational Schema for a plant nursery in your area. Your design should consist of at least two relations (tables). Perform the following on the relations: a) Create three tables having at least 5 attribute names (5 columns) 3 different data types with appropriate sizes. Identify the primary keys of all the relations. Identify the foreign key for the two relations. Identify at least one check constraint on any one table. Note: It is mandatory to attach your student id with the table names and column names. (28 marks) (6 marks) b) Insert at least 2 meaningful records in any of the two tables. c) Create a join on any two tables that should extract data based on two conditions from both tables. Display the output also. (8 marks) d) Implement the grouping of results for any one of the tables using aggregate functions with a condition on the grouping result set. Display the output also. (8 marks) Note: The output is mandatory to be given with all the above tasks. It is mandatory to give the comments with the SQL command to explain why it is being used. Marks will be deducted for not providing the output or not explaining the code as comments. Only screenshots of the code will not be accepted. Similarity issues arising out of this not being followed, will be dealt as per the MEC policy.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

Creating a relational schema and performing the requested tasks in SQL involves multiple steps Below Ill provide an example of how to create a schema ... 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

Database management systems

Authors: Raghu Ramakrishan, Johannes Gehrke, Scott Selikoff

3rd edition

72465638, 978-0072465631

More Books

Students also viewed these Computer Network questions

Question

List the characteristics of a good listener.

Answered: 1 week ago

Question

Explain all drawbacks of the application procedure.

Answered: 1 week ago

Question

Determine Leading or Lagging Power Factor in Python.

Answered: 1 week ago