School database. Create a database for managing students, faculty, and courses f

Question

School database. Create a database for managing students, faculty,
and courses for a Computer Systems Technology department of a school.
Assume all students and faculty are a part of this department. (In
other words, you do not need to keep track of details like major or
department affiliation.) The Student table should have studentId,
firstName, mi, lastName, and email. The Faculty should have the same
fields. There should also be a table for courses, enrolment (matching
students to courses and final grades), and course assignment
(matching faculty to courses).
Use MySQL for the database. The username should be “school” and the
password should be “java”.
Using NetBeans, create a GUI interface for interacting with the
database. The interface should allow users to add, query, edit, or
remove any table in the database. There will be an example GUI
posted on BlackBoard to give you an idea of how it should function. instead of hard-coding the username and password,

Explanation / Answer

#include #include #include #include #include #include #include #include #include /* STRUCTURE DEFINITIONS */ struct address /* STRUCTURE FOR ADDRESS */ { char hno[30]; char area[30]; char city[30]; char stat[30]; }; struct agn /* STRUCTURE FOR AGENT DETAILS */ { int code; char nam[80]; int age; address addagn; int polsld; //no. of policies sold float sal; //salary char categ[50]; //category }agnt[15]; struct cust /* STRUCTURE FOR CUSTOMER DETAILS */ { char nam[80]; int age; address addcust; char polbt[20]; //name of policy bought float sal; //salary int code; float polamt; int polterm; char mod_pay; float sa_pt_pa; //SA per thousand per annum float prem; //premium }custm[15]; struct fback /* STRUCTURE FOR FEEDBACK FORM */ { int age; char gndr; //gender char occp[20]; //occupation float inc; //income char a[12]; //ratings }fbk; struct poldet /* STRUCTURE FOR POLICY T&C */ { char nam[20]; int minagemat; int maxagemat; int maxmatage; int minpolt; int maxpolt; float minsumass; char maxsumass[10]; char modeall[25]; float acci_ben; float CI; int femliv; char agepro[40]; char nonmed_gen[5]; char nonmed_spe[5]; char termrideroptn[4]; char crtcalilnesridr[4]; float sa_pt_patrm1_ag1;//SA per thousand per annum float sa_pt_patrm1_ag2; float sa_pt_patrm2_ag1; float sa_pt_patrm2_ag2; }; /* STORING POLICY DETAILS */ poldet endow={"ENDOWMENT POLICY",12,65,75,5,55,50000.00,"No Limit","All",1.00, 7.26,2,"Birth Certificate / Board Certificate","Yes","Yes", "Yes","Yes",72.00,73.35,35.80,40.00}; poldet monbak={"MONEY BACK POLICY",13,50,70,20,55,50000.00,"No Limit","All", 2.00,6.57,2,"Birth Certificate / Board Certificate","Yes","Yes", "Yes","Yes",65.35,53.45,71.85,61.55}; poldet jeevkish={"JEEVAN KISHORE",0,12,45,15,35,50000.00,"40 Lacs","All",1.50, 6.52,2,"Birth Certificate / Board Certificate","N.A.","N.A.", "No","No",49.15,29.25,49.15,29.25}; poldet jeevannd={"JEEVAN ANAND",18,65,75,5,57,100000.00,"No Limit", "All Except Single",1.5,6.45,2,"Birth Certificate / Board Certificate", "Yes","Yes","No","Yes",50.95,39.05,155.75,86.25}; poldet jeevsurbh={"JEEVAN SURABHI",14,50,70,15,25,50000.00,"No Limit","All", 1.00,6.11,2,"Birth Certificate / Board Certificate","Yes", "Yes","No","No",108.80,91.30,123.00,112.80}; /* FUNCTION PROTOTYPING */ /* FUNCTION FOR DISPLAYING MAIN MENU */ void welcome();//display welcome page void mainmen();//display main menu /* CUSTOMER FUNCTIONS */ void cusmen();//display customer menu void newpol();//display new policies void tnccus(poldet pol);//display details of policies void newcus(poldet pol);//new customer data input float premcalc(cust custm,poldet pol);//premium calculation void oldcus();//display old customer's previous policy details void feed();//display feedback form char feedval();//input & test the ratings of feedback form /* AGENT FUNCTIONS */ void agnmen();//display agent menu void newagn();//new agent data input void oldagn();//old agent details void tncagn();//display terms & conditions for agents /* MAIN FUNCTION */ void main() { cout.setf(ios::fixed); cout.setf(ios::showpoint); cout<

Related Questions

Navigate

• Browse (All)
• Browse S
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.