Question: Overview: Write a program to query a database, and generate a list of student information from that database. The data is in the university database,

 Overview: Write a program to query a database, and generate a

Overview: Write a program to query a database, and generate a list of student information from that database. The data is in the "university" database, and the connect string for it is: Sdbc - nysqli,connect ("130.18.87.8,"student, "password", "university") The database is described on page 3.6 of the course packet. The output table should include a TACK HUOHE list of all student names (first and last) department name for their major. Department Cearses Taken OSHUA LE ERNEST WRIGHT The department name is held in the departmentBETTY MORRIS table ANTHONY ADAMS Accovering OSHUA LEE Finally, count the number of courses the studentJACK HEGHES has taken. (You'll have to use a second query, ED from the courses_taken table to do this) Business Indormation Syunms VICTOR YOUNG SANDRA HARRIS BRENDA JONES ANTHONY ADAMS Business Indormation Syweus Systems6 Business Information Systes CSS: Give the table some borders Busmess Information Systm Hints: I strongly recommend working on this one piece at a time. You can get the student names working first with a single table query. .Then expand it to a two-table query to add in the department name. Then finally a second query on courses_taken for the student counts. You can use a SQL function in this part, or do a manual count of results using PHP

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!