Simple DataBase

[AnGeL_555]

A Database needs to be developed that keeps track of supervisions of senior projects for computer science department.



The Data requirments are :



1) For each student store student ID, the name and the address.

Student ID's are unique. An adress consists of street, town and post code.



2) For each lecture store the name, staff ID and ofiice number. Staff ID's are unique.



3) Each student has exactly one supervisor. A staff member may supervise a number of students.



4) The date supervision began also needs to be stored.



5) For each research topic store topic ID, the title and a short description. Topic ID's are unique.



6) Each student can be supervised in only one research topic. Store topic ID, the title and a short description. Topic ID's are unique.



Well, wut to be done, plus developing the database, a simple form through which i can manipulate data...

like adding projects,students,projects, deleting any of these...etc..

plz help because oracle is not working on my pc i dont know y :(

[Ejaz]

You need to first identify the entities that are involved and then there attributes in which you are interested. As you have seen Student, Lecture, Supervisor etc are the entities and then comes the attributes (like there names, ID etc). This will form your table strucuture. Next to that, you need to make relationship between them. This will give you the database design.

For starting, take a look at Entity-relationship model (http://en.wikipedia.org/wiki/Entity-relationship_model).

About oracle, sorry to say its hard to comment with this description that why isn't it working :(