the dithmentpurpow.of blems lems and Exercises 6-34 dime gh 6-44 snl ces rhe cla

Question

the dithmentpurpow.of blems lems and Exercises 6-34 dime gh 6-44 snl ces rhe class win Esmi num ficarr dre data for an ASSIGNMENT Natioe, ah ntesReartsint, Nurkmalup behave w JarvityaMm fees udent ID ninrger, Primary Fw ultyTD live-nters primary keys Verite-a using SQL baxe decriptuen for each of the yelitkes 01 DOL 4horten, atteneviate, ce change -miAdarerters, prim ary key) usirnes,as needed for yourse. version. Amme data names, a CaireNarre l'i 5 characters) J-following attribute data types ectinnfdotimeter, primary key STUDENT Bludemo, Studenmame) ouALIFIED Facing.Coevio. Dolan di teeee Como 3457 4712-2013 FACULTY FacultyID. FacultyNa SECTION Sect_O&nester.; Carsel0) me Sectorho Sere ter Cana Facube FacubyName 2143 T13 12015 Bonnet 3467 i2015 issd 4830 Calm 4756 REGISTRATION IStudentlD, Sector-Nol COURSE (CourselD, CourseName) SudevilD |SectorNo Course CourseName 271 4 2715 Syst Analys 5490T ISM 3113 Syst Design 2713 ISM 3112 Database ISM 4212 Networking ISM 4930

Explanation / Answer

   CREATE TABLE STUDENT (
   StudentID NUMBER(10) NOT NULL,
   StudentName VARCHAR2(25),
   CONSTRAINT Student_PK PRIMARY KEY(StudentID));

   CREATE TABLE FACULTY(
   FacultyID NUMBER(10) NOT NULL,
   FacultyName VARCHAR2(25),
   CONSTRAINT Faculty_PK PRIMARY KEY(FacultyID));

   CREATE TABLE COURSE(
   CourseID VARCHAR2(8) NOT NULL,
   CourseName VARCHAR2(15),
   CONSTRAINT Course_PK PRIMARY KEY(FacultyID));

   CREATE TABLE QUALIFIED(
   FacultyID NUMBER(10) NOT NULL,
   CourseID VARCHAR2(8) NOT NULL,
   DateQualified DATE,
   CONSTRAINT Qualified_PK PRIMARY KEY(FacultyID,CourseID),
   CONSTRAINT Qualified_FK1 FORIEGN KEY(FacultyID)REFERENCES FACULTY(FacultyID),
   CONSTRAINT Qualified_FK2 FORIEGN KEY(CourseID)REFERENCES COURSE(CourseID));

  
   A solid line represents parent child relationship. A dotted line doesnot.So no need of REFERENCING the parent table COURSE
   CREATE TABLE SECTION(
   SectionNo NUMBER(10) NOT NULL,
   Semester VARCHAR2(7) ,
   CourseID VARCHAR2(8) NOT NULL,
   CONSTRAINT Section_PK PRIMARY KEY(SectionNo));

   CREATE TABLE REGISTRATION(
   StudentID NUMBER(10) NOT NULL,
   SectionNo NUMBER(10) NOT NULL,
   CONSTRAINT Registration_PK PRIMARY KEY(StudentID,SectionNo)
   CONSTRAINT Registration_FK1 FORIEGN KEY(StudentID)REFERENCES STUDENT(StudentID),
   CONSTRAINT Registration_FK2 FORIEGN KEY(SectionNo)REFERENCES SECTION(SectionNo)));

Related Questions

Navigate

• Browse (All)
• Browse T
• Subjects

---

---

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