ücretli ödev yapacak :)

Online Summer Training Tracking System:

In this web database application project, you will design and implement the database and the web pages of an Online Summer Training Tracking System for a particular department ( e.g. CMPE). The system should provide the following functionalities:

In this system, the committee members have two types of roles: chair and member. Each committee member should log in the system with his or her password.

All committee members have the ability to do such kind of operations:

Add firm information such as name of firm, working are, contact information, address and so on.
Update information of a particular firm
Delete a particular firm
Add summer training record for a particular student
Summer training type, start date, end of the training.
List summer training operations
By filtering the fields that will be displayed.
By filtering the records such as
Summer training information of the students whose id is between X and Y
Summer training information of the students whose training is between xxxx and yyyy.
Display all summer training information belongs to a particular student (only one student's information)
List the students that have completed all required her/his summer training.
Student id & name & surname
List the students that have not completed summer training yet.
Student id & name & surname

Explaination-1: The user can choose which fields will be shown. For example, the user can choose which fields will be displayed on the screen. In particular, she may want to see only see the students' id and their total completed summer training duration.

Explaination-2: The user can specify an interval for student id or year. For example, the user can display training information of the students whose student id is between 1999699004 and 2000699147. Another option is to be able to display the information whose summer training is done in a specified year for example 2004.


After this part, there is no need for an interface; as a result, the following information is entered system by manually. In other words, the following information can be entered system directly.
o Summer training committee member information such as title, name, surname, status (admin, member), and so on.
o Students' information such as student id, name, surname, semester and so on into the system
o Summer training type such as "hardware", "software", etc for the department and required time duration for this type. Assume that this web application is for computer engineering department. In this project, we assume that each student should complete some kind of training for a particular time. For instance, a student should complete 20 days in hardware training and should complete 40 for software.


NOTE: In this implementation, if there exists any constraints, the database management system should guarantee that the constraints are satisfied. It is not enough to satisfy these constraints via web application controls.



The project consists of two phases. In the first phase you will design and implement the database for this application. You can use a DBMS system of your choice such as MS SQL Server 2000, MS SQL 2005 and MySql, to implement the database. In the second phase you will design and implement the Web application. For the Web application, you can choose one of the technologies such as ASP, ASP. Net or JSP. The specifications of the two phases are as follows:
DB design and implementation phase:
Find out the information requirements of the Online Library System.
Determine the constraints and domains. Determine the entities and relations.
Identify the properties of the entities and their domains.
Determine the identifier of each entity (i.e., find the primary key).
Draw the Entity-Relationship (E-R) diagram
Decide what the base relations are.
Draw the Functional Dependency diagrams.
Make sure your relations are in 4NF.
Decide what the referential integrity constraints are (identify foreign keys).
Decide which deletion integrity rules to use (restrict, set to NULL, or cascade).
Identify user views.
Considering frequent access, come up with a physical database schema.
Create the database on a DBMS.
Specify DDL statements in SQL (internal, external, conceptual level).
Specify the queries (needed for the transactions you determined in step 1) using SQL.
Write SQL insertion, deletion, modification and select statements (DML statements).
Present your work in the DB design report. Submit the hard copy of your report.
Submit the script (*.sql if you use MS SQL Server) of the database you have implemented in a CD/diskette.
Web application design and implementation phase:
A simple web interface is adequate.
You are recommended to use the following technologies:
Java (JSP, and JDBC) + Apache Tomcat Server (for JSP)
Visual Studio .NET ( ASP .NET )
ASP


konusu yukarıdadır okuma nezaketi görmedim kusura bakmayın kuzenimin ikinci ödevi birincisini halletik çok şükür. Yapmak istiyen pm atabilir. Bütçe 50 YTL

İyi Çalışmalar

vakit biraz geçmiş sanırım.....

dökümantasyon hariç programlama kısmını yapabilirdim ancak süresi dolmuştur tahminimce....

o kadar yazı yazıyor ama basit bişeye benziyor. türkçesini yazarsanız kesin yardımcı olacak biri çıkacaktır.

Yazı çok uzun kısaca ne istediğini söylersen yardımcı olabilirim belki.