Mailings Review View Help Tell me what you AaßbCcDAaBbCcDe Subtitle Subtle Em Pa

Question

Mailings Review View Help Tell me what you AaßbCcDAaBbCcDe Subtitle Subtle Em Paragraph Create in SQL statement COLLEGE DEGREE college id school name INT degree name NT FK major id DEPARTMENT PK departmentid ?NT college,jc FK FK major id INT INT major id major prefo GRADUATION REQUIREMENT major, desciption VARCHAR(20) INT INT FK ourse id CHAR(B) FK requirement type id INT INT credt hour CHAR(8) VARCHAR(45) INT VARCHAR(45) INT course_id credt hours PK major ld requirementtype INT component credt hours credit hours selected INT PK.FK course id INT

Explanation / Answer

As per your requirement the below one is solution please follow it

The tables are given below:

COLLEGE:

CREATE TABLE COLLEGE(
    college_id int,
school_name varchar(100);
    PRIMARY KEY (college_id )
);

DEPARTMENT:

CREATE TABLE DEPARTMENT(
    department_id int,
    department_name varchar(45),
PRIMARY KEY (department_id ),
    CONSTRAINT FK_college_id FOREIGN KEY (college_id )
    REFERENCES COLLEGE(college_id )
);

DEGREE:

CREATE TABLE DEPARTMENT(
    degree_id int,
    degree_name varchar(70),
PRIMARY KEY (degree_id),
    CONSTRAINT FK_college_id FOREIGN KEY (college_id )
    REFERENCES COLLEGE(college_id )

CONSTRAINT FK_department_id   FOREIGN KEY (department_id )

    REFERENCES DEPARTMENT(department_id )
);

CONCENTRATION:

CREATE TABLE CONCENTRATION(
concentration_id int,
  concentration_description varchar(70),
PRIMARY KEY (concentration_id ),
    CONSTRAINT FK_degree_id FOREIGN KEY (degree_id)
    REFERENCES DEGREE(degree_id )

CONSTRAINT FK_major_id FOREIGN KEY (major_id)

    REFERENCES DEPARTMENT(major_id)
);

Related Questions

Navigate

• Browse (All)
• Browse M
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.