مشروع قاعدة بيانات لموقع تقديم مناقصات..

السلام عليكم...

اخواني انا عندي مشروع يتحدث عن موقع يكون تبع الحكومة..ويتم انزال عده مناقصات فيه...

حيث تقوم الشركات بالتقديم عليها..ويتم فرز العروض واختيار الافضل...وارسال ايميل بالموافقة على طلبه..

اقتباس

Local governments usually organize tenders where local companies bid for large scale projects supported and financed by the government. Tenders involve large amounts of money. Since the government supports the projects, on one side the companies find it very prestigious to be part of it, and on the other side, the public is very sensitive about how well the money is used. A multi-disciplinary committee is constituted in order to evaluate the participants.

In the first phase, participants submit general information about the company, their legal and technical system, number of employees, etc. The companies are evaluated based on the following criteria: ISO 9000 certification, number of employees, etc. In the second phase, participants submit information on prices and product quality. The companies are then evaluated based on the following criteria: price, product quality, and technical competence.

The aim of this project is to develop a decision support system that will assist members of the committee in evaluating the participants and making a final recommendation about the company that will carry on the project.

Part I

We present below the main entity types of this database. For each entity type, we provide some of the corresponding attributes. Use this information in order to: (a) Build an Enhanced E-R diagram; (B) Transform the Enhanced E-R diagram to a relational database. Identify the primary key(s) and the foreign key(s) for each relation. Draw the relational integrality constraints; © For each of the relations created, indicate its normal form. If the relation is not in the 3NF, decompose it into 3NF relations.

1. Participant: The main attributes are identification number, name, address, name and telephone number of the contact person, number of employees, compliance with ISO 9000, compliance with 6-sigma process control, etc.

2. Project: The main attributes are project identification number, name, description, requirements, activity, etc.

3. Project Evaluation Committee: The main attributes are social security number, name, address, telephone number, degree, area of specialty, etc.

4. Evaluation Criteria: The main attributes are identification number, name, and weight.

Note that the evaluation criteria are used to identify the competency of a participant to undertake a project. The data collected from the two phases of the evaluation process is recorded in this database. When a participant wins the tender, the following information is recorded: estimated starting date, estimated finish date, actual starting date, actual finish date, estimated costs, actual cost, etc.

Part II

1) Create a function evaluation that returns the weight of a company.

2) If a tender is added in the database, a trigger sends an email to all the participants in this system according to project categories.

3) Create a function that selects the best participant to take the project.

4) Create a trigger that sends an email to companies whose offer was rejected and those whose offer was accepted.

5) Create a function that adds a new tender.

6) Create a function that adds a new company.

7) If a tender is taken, put it into the taken tenders table and delete it from the initial table

انا اشتغلت على بدايته من رسومات وتصاميم..وحابة احد يطلع عليها اذا فيها اي تعديل او اضافات..

يااليت لو احد يقدر يساعدني يبلغني وارسل له الشغل بالخاص لان من الصعب عرضه هنا...خوفا من السرقة او التقليد

ولكم كل الشكر..