Help Me Plz

[qurawer]

هذا هو السؤال مال الاسايمنت فارجو المساعدة في ايجاد الاجابة باسرع وقت ممكن واكون من الشاكرين

Prepare a student dues system on the basis of following assumptions.
1. There are five courses offered by an university at different rate of tuition fee
CID Course_Name Total Semester Total fee
MBA Master of Business Administration 6 800
BE Bachelor of Engineering 8 1200
BSCIT Bachelor of Science in Info. Tech 6 500
BCOMEC Bachelor of E-Commerce 6 600
BBA Bachelor of Business Administration 6 600

2. Student - master information are #ROLL1, Name, Batch (values between 2000 to year of current date), Course, CPR, Sex, Telephone (assumed single valued)
3. Other information against ROLL as primary key
#ROLL, Total_Charges, Total Receipts, Net_Dues
4.. Other transaction tables
A. Charges_table to record all the charges against a student with fields
#SRL, ROLL, Semester, Amount with appropriate referential integrity with course
B. Receipt_Schema = (#Receipt_no, Receipt_date, Roll, Amount)
-------------------------------------------------------------------------------------------------------------------
1. Create all the tables with proper referential integrity and data validation rules.
2. a) Change an attribute name & type.
Add new attribute for testing, delete the attribute.
c) Again change the attribute (that you have changed) to its previous status.
3. Insert data in tables.
4. Update data for ascertaining total dues and total payment and net dues.
5. Display all student-dues as per the following format where course is BSCIT and “BAS” is somewhere in a student name.
Roll, Name, Course, Batch, Tot_Charges, Tot_Receipt, Dues, Fine (which is 5% on dues)
6. Delete a student charge which was wrongly inserted into charges table against
SRL 5
7. Update all student name and Add “MR” before name if sex is “M”, otherwise add “MS “before name.
8. Practice the concept of full outer join, left outer join, set difference, union using these tables.
9. Write down all the SQLs (you have used to do the entire task) in a file.
10. Analyze the design; find out the required modification in the design to, make the database more informative.