Report

The project is mainly about the challenges that students has to face for each subject that cause students did not reach the goal. This paper will explain the relationship in details of the ERD that will attach to this documents.

· Student Entity has the Student_ID as primary key without foreign key. It also has 3 relationship with the Sources Entity, Grade Entity and Courses Entity. Grade Entity has the primary key is Student_ID and foreign key is Course_ID. Sources Entity only has primary key is Book_ID.

· Student can receives one, two or many grades and the relationship is mandatory. Grades has optional 1:1 relationship with the Student.

· Student can use one, two or many sources and the relationship is optional(1:M)

· Student also has the mandatory relationship with Course Entity as 1:M, student can have zero, one or many courses. The course can be taken by zero, one or many students (1:M).

· Challenges Entity is the Supertype( Parent Entity) and also has 7 child entities that describe the challenges that student might have by each subjects. The primary key and foreign key are Course_ID.

· Courses Entity is also a Supertype( Parent Entity)has primary key as Course_ID and foreign key as Grade_Type. The other 7 child entities from the Courses Entity which is the 7 different main subjects that medical students has to study in the first 2 years of Basic Science. The foreign key are the same in all subject are Course_ID and Student_ID.

· Anatomy/Embryo has primary key as Body_Area

· Chemistry/genetic has primary key as Target_gene

· Pathology has primary key as Diagnosis

· Pharmacology has primary key as Mechanism of action

· Physiology has primary key as Hormones_Pathway

· Microbiology has primary key as Species_Types

· Social Science has primary key as Doctor/Patient Relationship

· Each of the Courses’ child entity will associate with Challenges’ child entity. Each subject challenge has zero, one or many challenge as mandatory. Each of the subject might have zero, one or many challenges as optional relationship.

· Each of the Challenges_Subject entities show the challenges that students have in each subject without primary key in the attributes. Because the challenge of one subject might repeat in other challenges subject so there will be no unique to have primary key in this case( like Time_management or high volume of content). All the child entities have the same foreign key is Time_Management.

· The Challeneges Entity has primary as Time_Managment and foreign key as Course_ID and Student_ID

· Business rules:

· Student cannot enroll for more than 2 courses per semester

· Student cannot fail more than 1 course per semester.

· Student can use zero, one or more sources during the semester to help for understanding the topic.

Assumption and Consideration:

There are more challenges that students might face but only use the most common challenges in this project. In addition, there is a problem about the price different in the sources which I did not include in this ERD model because I am not sure if that is important or it consider as challenge in this project.

The primary key and foreign key are king of repeat in some of the entities which might cause confusing for people who read the ER diagram.