CODEWITHSUNDEEP
databasedatabase-designrelational-databasedatabase-schema
user3624832
user3624832

Reputation: 89

database design and structure for university study plan

i want to create a tabel for study plan for each major where students can see the study plan and mark the courses that he finished . How is the structure will be ? i thought of this but its simple and not covering all the details .I need more table illustrating but how ? 

  CREATE TABLE Studyplan(
     StudyplanID INTEGER(25) PRIMARY KEY,
     unicourses VARCHAR(25) ,
     majorcourses VARCHAR(25),
     electivecourses VARCHAR(25),
     Year INTEGER(200)

);

Upvotes: 0

Views: 894

Answers (1)

TommCatt
TommCatt

Reputation: 5636

As this might be homework, I won't create the tables, but here are some pointers.

  • With the StudyPlanID key, you are essentially saying that a particular study plan consists of one unicourse (whatever that is), one major course and one elective. Might a study plan consist of several of each type of course?
  • Are these courses (uni, major, elective) listed in separate tables or all in one comprehensive Courses table? (After all, a particular course may be a "major" course for some majors and an elective for others.) Also, suppose a simple study plan consists of one uni, one elective and two major courses. That would require two entries, each with the same uni and elective data repeated. For these reasons, wouldn't it be better to have just one course reference per tuple, with a flag showing if it is uni, elective or major?

Well, I had a couple more listed, but this should be enough to keep you going for awhile. You can post other questions as you progress.

Upvotes: 1

Related Questions