Work

Statement of work

Overview:

This project will oversee the design and creation of the database use to track and store information about passing/failing students in four years of medical school at each subjects. It will serve as the data store that enables schools to browse the information to see the process of students in each subjects: Anatomy/Embryo, Histology, Pathology, Pharmacology, Microbiology, Genetics, Biochemistry, Physiology and Social Science. This database helps the schools to see if there are any challenges at each subjects that cause the students do not reach the passing score and able to create a new pathway to increasing the amount of students pass the subjects.

Executive Summary:

The database will create a full picture to see how students perform in each subject and how the knowledge delivery to the students. The database will also help the professors/school see where the student stand in the subject that there may be something that they can help or change to increase the number of student successful in the subject. Students will be able to use unlimited many different sources to study, unlimited sources for Question banks. The database should be designed in a way that allows for the easy addition of new search criteria, and maintenance the school to improve the number of students passing the subject. From the database, professors/schools will be a better picture to see the challenges that students might face that effect to the performances.

Project Scope:

This database system is designed to store performance information of students in each subject of medical school. This creation can show the full picture if anything might effect to the performances which school can help to improve or fix the problems. In scope work will include documenting the project requirements, modeling the database in entity-relationship form. Creation of DML scripts to stimulate the interaction between databases, challenges in each subjects, and pathways to improve.

· The number of students do not reach the passing score in each subject

· The challenges that those students have during their studying

· The sources they use to study(books, questions bank, lecture PowerPoint)

· The pathway to help students improve their performances

Database Benefits, Goals, Expectation:

Upon the completion of the project, the database shall contains all the important information( challenges) that students face in each subject. This also helps students change the way of approaching the subjects, and professors/schools to have a better way to deliver the information to the students. Deliverables include this statement of work document, an entity-relationship diagram defining the structure of the database, DDL scripts for creating the database, example DML and SQL scripts that demonstrate proper usage of the database and a final report on the project as a whole.

Project Hardware and Software Tools:

· ER-Assistant, running on Mac

· Microsoft office, running on Mac

· Oracle Database by using Virtual Desktop Access(VDA)

· Google Chrome

· DDL and DML

For this project, after create the ERD I will use the Data Definition Language to create the database structure and define the information. The initial database tables will include the number of pass/fail students in each subject, the challenge students face in each subjects, the sources they use during studying, the recommends from professors. I will also use the Data Manipulation Language (DML) to inserts rows of information regarding the students information and ways to improve their performances.