Example:-1
1.Player(Player_id, Name,Birth_Date,Game_Name)
Create table Assign_Player (Player_id int primary key, Name varchar(10),
Birth_Date
varchar(10), Game_Name varchar(10));
2.Student(Roll_No, Name, Class, Percentage, Birth_Date)
Create table Assign_Student (Roll_No int primary key, Name varchar(10),
Class int, Percentage
int, Birth_Date varchar(10));
3.Project(Project_id, Project_Name, Project_Description, Status)
Create table Assign_Project (Project_id int primary key, Project_Name
varchar(10),
Project_Description varchar(10), Status varchar(10));
4.Donor(Donor_No, Donor_Name, Blood_Group, Last_Name)
Create table Assign_Donor (Donor_No int primary key, Donor_Name
varchar(10), Blood_Group
varchar(10), Last_Date varchar(10));
5.Property (Property_id, Property_Description, Area, Rate, Agri_Status)
Create table Assign_Property (Property_id int primary key,
Property_Description varchar(10),
Area varchar(10), Rate int, Agri_Status varchar(10));
6.Actor(Actor_id, Movie_Name, Birth_Date)
Create table Assign_Actor (Actor_id int primary key, Movie_Name
varchar(10), Birth_Date
varchar(10));
7.Movie (Movie_id, Movie_Name, Release_Year)
Create table Assign_Movie (Movie_id int primary key, Movie_Name
varchar(10), Release_Year
int);
8.Hospital (Hospital_id, Hospital_Name, Hospital_City)
Create table Assign_Hospital (Hospital_id int primary key, Hospital_Name
varchar(10),
Hospital_City varchar(10));
9.Employee (E_No, E_Name, Joining_Date, Company_Name, Salary,Designation)
Create table Assign_Employee (E_No int primary key, E_Name varchar(10),
Joining_Date
varchar(10), Company_Name varchar(10), Salary int, Designation
varchar(10));
10.College (College_Code, College_Name, Address, Establish_Year)
Create table Assign_College (College_Code int primary key, College_Name
varchar(10), Address varchar(10), Establish_Year int);
11.Doctor (D_No, D_Name, Specialization, Qualification)
Create table Assign_Doctor (D_No int primary key, D_Name varchar(10), Specialization
varchar(10), Qualification varchar(10));
12.Class_Room (CRoom_No, Location, Capacity)
Create table Assign_Class_Room (CRoom_No int primary key, Location
varchar(10), Capacity int);
