Scenario : 2


Create the Following Tables with suitable Primary keys , Foregin keys and identify the order of tables ?


Dept Table                     : id, name
Course Table                 : id, name, dept, other_info
Teacher Table                : id, fname, lname, phone
Section Table                 : id, course, teacher_id, capacity
Student Table                : id, fname, lname, dob, phone
Student_section Table   :         id, studid, sectionid

Dept Table:
  • id (Primary Key)
  • name
Teacher Table:
  • id (Primary Key)
  • fname
  • lname
  • phone
Course Table:
  • id (Primary Key)
  • name
  • dept (Foreign Key referencing Dept Table)
  • other_info
Section Table:
  • id (Primary Key)
  • course (Foreign Key referencing Course Table)
  • teacher_id (Foreign Key referencing Teacher Table)
  • capacity
Student Table:
  • id (Primary Key)
  • fname
  • lname
  • dob
  • phone
Student_section Table:
  • id (Primary Key)
  • studid (Foreign Key referencing Student Table)
  • sectionid (Foreign Key referencing Section Table)
The order of the tables considers the dependencies between them:
  • Dept Table     :   No other table depends on it, so it comes first.
  • Teacher Table :   No other table depends on it.
  • Course Table   :   Depends on Dept Table as well as Teacher Table.
  • Section Table   :   Depends on Course Table and Teacher Table.
  • Student Table   :   No other table depends on it.
  • Student_section Table: Depends on both Student Table and Section Table. 

Comments

Post a Comment

Popular posts from this blog

Installing MySQL and MySQL Workbench

Step 1: Download MySQL Installer: Visit the official MySQL website: https://dev.mysql.com/downloads/installer/ Scroll down and find the "MySQL Installer for Windows" section. Click on the "Download" button for the "MySQL Installer for Windows" version. This installer includes both the MySQL server and MySQL Workbench. Step 2: Run the MySQL Installer:       1.Once the installer is downloaded, locate the downloaded file and double-click to run it.       2.If prompted by User Account Control, click "Yes" to allow the installer to make changes to your            device. Step 3: MySQL Installer Setup: The installer will launch. Click "Next" to proceed. Choose the "Developer Default" setup type. This option will install MySQL Server, MySQL Workbench, and other useful tools for development. Click "Next." Step 4: MySQL Server Configuration: 1.The installer will ask you to configure the MySQL Server. You can choose the defau...
Read more

Java Program to Check Palindrome Number

c lass PalindromeNumber {   public static void main(String[] args )   {         int num = 755, reversedNum = 0, remainder ;         // store the number to originalNum     int originalNum = num ;         // get the reverse of originalNum     // store it in variable     while ( num != 0) {       remainder = num % 10;       reversedNum = reversedNum * 10 + remainder ;       num /= 10;     }         // check if reversedNum and originalNum are equal     if ( originalNum == reversedNum ) {       System. out .println( originalNum + " is Palindrome." );     }     else {       System....
Read more

Scenario : 1

Create the Following Tables with suitable Primary keys , Foregin keys and identify the order of tables ? Movie Table : movieid, movie_name, rating, duration, seatno, timeslotid Theatre Table : theatreid, seatno, moviename, movieid, staffid, timeslotid Timeslot Table : timeslotid, moviename, movieid, staffid, theatreid Booking Table : bookingid, bookingdate, bookingseat, booking_timeslot, staffid Ticket Table : ticketid, movieid, staffid, theatreid, bookingid Staff Table : staffid, fullname, mobile, email, dob Solution : Staff Table: staffid (Primary Key) fullname mobile email dob Timeslot Table: timeslotid (Primary Key) moviename movieid (Foreign Key referencing Movie Table) staffid (Foreign Key referencing Staff Table) theatreid (Foreign Key referencing Theatre Table) Movie Table: movieid (Primary Key) movie_name rating duration seatno timeslotid (Foreign Key referencing Timeslot Table) Theatre Table: theatreid (Primary Key) s...
Read more