A hard copy of the project report that includes the following items. Turn this i

Question

A hard copy of the project report that includes the following items. Turn this in on the same day of the final examination. 1. A cover page listing the team member information (the names and last 4 digit of campus ID) and the account that has the project implementation. Since there are three members each with a different account, your team needs only to upload the project implementation into one account; 2. The ER diagram of your design; 3. The corresponding relational model with primary keys and foreign keys clearly spec- ified (cf. Fig. 9.2 on page 291); 4. The source code of the project, including the DDL you used to create the tables and the SQL you used to implement the queries 5. The interfaces you developed in screenshots 6. Sample run of the system in screenshots, including inputs and output. The project should be uploaded in one of the accounts that are given to you on the department server. Only projects that are completed and tested on the server will receive full credits. If the implementation can not be tested you will receive at most 80% of the credits.

Explanation / Answer

Database relations are created as follows:

PROFESSOR

CREATE TABLE PROFESSOR(

SSN VARCHAR2(10) PRIMARY KEY CHECK(SSN LIKE 'S%'),

NAME VARCHAR2(20) NOT NULL,

SALARY NUMBER(10),

COLLEGE_DEGREES VARCHAR2(40),

SEX VARCHAR2(10),

TITLE VARCHAR2(10),

STREET VARCHAR2(10),

CITY VARCHAR2(10),

STATE VARCHAR2(10),

AREA_CODE NUMBER(5).

SEVEN_DIGIT_NO NUMBER(7)

);

DEPARTMENT

CREATE TABLE DEPARTMENT(

DNO VARCHAR2(10) PRIMARY KEY,

NAME VARCHAR2(10),

TELEPHONE NUMBER(10),

LOCATION VARCHAR2(10),

SSN VARCHAR2(10) REFERENCES PROFESSOR(SSN),

);

COURSE

CREATE TABLE COURSE(

CNO VARCHAR2(10) PRIMARY KEY,

TITLE VARCHAR2(10),

TEXTBOOK VARCHAR2(10),

UNITS NUMBER(4),

PREREQUISITE_COURSES VARCHAR2(10),

DNO VARCHAR2(10) REFERENCES DEPARTMENT(DNO),

);

SECTIONS

CREATE TABLE SECTIONS(

SNO VARCHAR2(10) PRIMARY KEY,

CLASS_ROOM VARCHAR2(10),

MEETING_DAYS

BEG_TIME TIME,

END_TIME TIME,

NO_OF_UNITS NUMBER(4),

SSN VARCHAR2(10) REFERENCES PROFESSOR(SSN),

CNO VARCHAR2(10) REFERENCES COURSE(CNO)

);

STUDENTS

CREATE TABLE STUDENTS(

CWID VARCHAR2(10) PRIMARY KEY,

FNAME VARCHAR2(10),

LNAME VARCHAR2(10),

ADDRESS VARCHAR2(10),

TELEPHONE_NO NUMBER(10)

);

ENROLLMENT

CREATE TABLE ENROLLMENT(

STUDENT VARCHAR2(10) PRIMARY KEY,

COURSE_SECTION VARCHAR2(10),

GRADE VARCHAR2(10),

);

MAJOR/MINOR

CREATE TABLE MAJOR/MINOR(

CWID VARCHAR2(10) REFERENCES STUDENTS(CWID),

DNO VARCHAR2(10) REFERENCES DEPARTMENT(DNO),

);

ENROLLED

CREATE TABLE ENROLLED(

CWID VARCHAR2(10) REFERENCES STUDENTS(CWID),

STUDENT VARCHAR2(10) REFERENCES ENROLLMENT(STUDENT)

);

Database entries:

STUDENTS

DEPARTMENT

PROFESSOR

COURSE

SECTIONS

ENROLLEMENT

MAJOR/MINOR

ENROLLED

Conclusion:

In this way, we have given in the above format.

Underlined column names represent the primary keys.

Interface for professor means, we can ask information from the professor through field names of the relation Professor.

Similarly,

We can collect the required information from the students through students table and related tables.

CWID FNAME LNAME ADDRESS TELEPHONE_NO CW1 JOHN P NEW YORK 9898989898 CW2 JOS K NEW YORK 9696969696 CW3 JAMES T NEW YORK 9595959595 CW4 JOLLY M NEW YORK 9797979797 CW5 JIM U NEW YORK 9393939393 CW6 JOHNY V NEW YORK 9292929292 CW7 JEN W NEW YORK 9191919191 CW8 JESSY X NEW YORK 9090909090

Related Questions

Navigate

• Browse (All)
• Browse A
• Subjects

---

---

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