Implement the database design (create tables) that you have created in question 1 using a RDBMS with proper integrity constraints. Enter about 8- 10 meaningful records in each of your table.
To implement the database design created in question 1 using an RDBMS, the first step is to define the schema with proper integrity constraints. For example, let’s assume the database design involves a system for managing a student course registration system. Below is the SQL code to create the tables and insert meaningful records.
### 1. Creating the "Students" table:
```sql
CREATE TABLE Students (
StudentID INT PRIMARY KEY,
Name VARCHAR(100) NOT NULL,
DateOfBirth DATE,
Gender VARCHAR(10),
Email VARCHAR(100) UNIQUE,
________ __________ ______ _____ ___ _______ _____ _______ ________ __________.
__________ __________ ____ _______ _________ __________ ________ _____ _________ ____ _____.
_______ ____ ___ ________ ___ __________ _____.
_________ ______ ______ _______ ______ ______ _________ ___ _________ _______.
_____ ____ ____ ______ __________ ___ ____ ______.
______ ________ _________ __________ ____ ____ ___ _____ _________ ________ ________ _______.
______ ________ ________ ________ ______ ______.
____ _________ _________ ________ ___ _____ _______ __________.
______ _________ _________ ___ __________ ________ ________.
__________ _________ _______ ___ _______ _______ _____.
____ __________ ___ ________ ______ ______ __________ _____ ____ _______ _______ _____.
_____ ____ ________ ______ ______ _______ __________ ________.
_____ ___ ________ ________ ________.
_________ _________ _____ _________ _____ __________ ____ ________ ____ _________.
_______ ________ ____ _________ _________ _____ __________ ___ ______ ___ ______.
_________ ________ ____ __________ ___ ______ ___ ______ ___ ______.
___ ________ ______ ____ ___ _________.
_________ ____ _______ ______ ____ _________ _________ _____.
_____ ______ ________ ___ ________ ________ _____ __________ ____.
_______ ________ ___ ______ _____ ________ _______ _________ ______ __________.
________ _________ ______ _______ _____ _____ _______ ________ __________.
_______ ______ ______ __________ ________ _________ __________ __________ __________ ____ ____.
__________ _______ ________ ________ ______.
____ ____ _______ ___ ____ _______.
_____ __________ ________ _________ __________ _________ ____ _____.
_____ ______ ________ ___ ______ ________ __________ ____ _________ _________ _________.
_____ __________ ____ __________ __________ _____ _____ ______ __________ __________ __________ _____.
_____ ________ _________ ______ ____.
_____ _________ ___ _____ _____ ________.
__________ __________ _____ _________ _______ ___.
______ _______ ___ ____ ________ ________ ____ _________ ______ ___.
__________ _______ _________ _____ _______ __________ _______.
_________ _________ __________ _______ _______ ___ ______ _______ _____ _______.
________ ________ ______ __________ _______.
__________ ______ _________ _______ _____ _______ _________ ______.
_____ ______ __________ _______ ________ _____ ________.
__________ _____ ____ __________ ____ _______ ____ __________.
________ _______ ________ ___ __________ ________.
_____ __________ ___ ____ ___ _______ ______ ___ __________.
_____ ______ ________ _______ ______ ____ ___ _________ _____ ___ _________ _________.
________ _________ ____ ___ _____ ___ _________ ________ ____ _________.
___ ______ ________ _________ ______ _______ __________ _________.
________ _______ _______ _______ ______ ___ _______.
_______ _______ ______ ____ __________ ________ ___ ___ _________ ________ _____ ______.
______ ___ _____ __________ _______ ___ ___ _________ ____ _______ ___.
____ _________ __________ _____ ______ ____.
_______ _______ ______ _____ _______.
Get Full Answer on WhatsApp