Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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,

image text in transcribed
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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Creating A Database In Filemaker Pro Visual QuickProject Guide

Authors: Steven A. Schwartz

1st Edition

0321321219, 978-0321321213

More Books

Students also viewed these Databases questions

Question

1. Where will you recommend that she hold the focus group?

Answered: 1 week ago

Question

3. What might you have done differently

Answered: 1 week ago