You have two choices to make a database.
- a database that will contain all sem6 students and their group belonging and in which projects they work.
- a very simple database that contains links to the documents you are producing in your project.
Database 1
The scenario is that your group is one of many project groups within a company (the 6th semester). You are designing the database and shall create a common access to it so company employees easily can get information on ongoing projects and who is working on different projects.
You can also download the Access database sem6_project_db to your own machine.
|
List all (employees) students,
[call file "all_students.asp" in your directory cxx on the datyabase machine].
(on localhost),
|
|
|
Find persons with certain first and second names , (on localhost), (or names containing specific strings) and list the group and project belongings. (Source code), (Localhost Source code). [call file "s7_g2.asp" in your directory cxx on the datyabase machine]. |
List Groups,
(on localhost),
belonging to
Groups (and the Persons in the group)
[call file "sem6_groups.asp" in your directory cxx on the datyabase machine].
|
Database 2
This database will store the adresses to your documents produced in the project. You can search the documents on name or part of name and get a ordered list back. (In this case we only have one table. The database can be extended with for exampel a person table and a table that connects documents and persons who created the document).
Call the the drawing database here
You shall download (FTP) your database (.mbd) to your directory on the database machine (exchange xx above with group number).
http://130.225.55.42/stud_asp_example/sem6_2002/c2xx/c2xx.asp
[Here you find the source code of the c2xx.asp]
Se also this short instruction.