Scribd Logo
Upload

Welcome to Scribd!

  • 16 views

    Alter ADD Index: 'Student' 'Student - Id'

    Uploaded by

    djkaz
    1) A students table was created with student ID as the primary key and indexes were added. 2) A courses table was created with a foreign key linking to the student ID, and indexes were added. Relationships were then defined between the students and courses tables.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as DOCX, PDF, TXT or read online from Scribd

    Alter ADD Index: 'Student' 'Student - Id'

    Uploaded by

    djkaz
    16 views1 page
    1) A students table was created with student ID as the primary key and indexes were added. 2) A courses table was created with a foreign key linking to the student ID, and indexes were added. Relationships were then defined between the students and courses tables.

    Original Description:

    many to many database

    Original Title

    Many to Many

    Copyright

    © Attribution Non-Commercial (BY-NC)

    Available Formats

    DOCX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    1) A students table was created with student ID as the primary key and indexes were added. 2) A courses table was created with a foreign key linking to the student ID, and indexes were added. Relationships were then defined between the students and courses tables.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    16 views1 page

    Alter ADD Index: 'Student' 'Student - Id'

    Uploaded by

    djkaz
    1) A students table was created with student ID as the primary key and indexes were added. 2) A courses table was created with a foreign key linking to the student ID, and indexes were added. Relationships were then defined between the students and courses tables.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    of 1

    Create database newtest 1) Create table students( student_id int(3 NOT NULL AUTO_INCREMENT, student_name VARCHAR(40), student_address VARCHAR

    (100), student_email VARCHAR(40), student_phonenumber int(10), PRIMARY KEY(student_id) ) Dupa adaugarea tabelului se mai adauga ALTER TABLE `student` ADD INDEX ( `student_id` )
    Adaugare cheie primara ALTER TABLE `courses` ADD FOREIGN KEY ( `student_id_fk` ) REFERENCES `newtest`. `courses` (`course_id`) ON DELETE CASCADE ON UPDATE CASCADE ;

    ALTER TABLE `courses` DROP FOREIGN KEY `courses_ibfk_1` , ADD FOREIGN KEY ( `student_id_fk` ) REFERENCES `newtest`.`student` ( `student_id`) ON DELETE CASCADE ON UPDATE CASCADE ;

    2) Create table courses( course_id INT(3) NOT NULL AUTO_INCREMENT, course_name VARCHAR(30) , course_details VARCHAR(200), course_duration VARCHAR(10), student_id_fk INT(3), PRIMARY KEY(course_id) ) Dupa adaugarea tabelului se mai adauga ALTER TABLE `courses` ADD INDEX ( `course_id` )
    Dupa se trece pe structure - > relation view Student_id_fk->new test.courses.course.id->on delete cascade->on update cascade Course -> structure-> relation view

    You might also like