Assignment submission for DBMS course
Requirements:
- There should be minimum 3 Tables in the Design
- As far as possible keep the design simple
- Every table should have a Primary Key
- There should be at least one Foreign Key constraint
- You should represent at least one Relationship (i.e 1:1, 1:n, n:1,n:m)
- The Table names and attribute names should make sense and should be relevant to the given problem
Requirements:
- Showcase one Many-Many relation.
- Represent Composite key and Weak Entity in your Database
- Show Violation of Primary Key, Unique Not Null and default key constraints through insertion.
- One Derived attribute should be added to the Database design
- Insert tuples into the table and see how foreign key constraint works if you try to insert into dependent table first.
Requirements:
- Show how to Create and Drop Database
- Show all the Databases are in the system
- Create Table for your Database
- Show how select can be used for Creating table
- Drop table
- Show how to check the schema of the tables
- Show all the tables from the database (This is not done in class, I want you to explore. This is a very simple query and I think you should be able to do to it.)
- Insert 5 to 10 rows in each of the tables of your Database
- Show usage of Simple Select Statement
- Select Statement using Relational and Logical operators.
- One simple Subquery using select
Requirements:
Illustration of the following using Select Query
- Order by Clause
- Group by and having
- Aggregate functions
- Logical operators especially with LIKE
- At least 4 Nested queries specific to your Database, out of which at least 2 should have multiple subquery.
Requirements:
Illustration of different types of Joins. Make use of all the tables in the Database. Don’t get
stuck on to one or two table. The Queries should cover all the tables.
- INNER JOIN - 3 queries
- LEFT OUTER JOIN – 3 Queries
- RIGHT OUTER JOINS – 3 QUERIES
- Make use of different types of operators and clauses within all the queries.