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