GTUC was established many years ago with one campus to provide technology education in order to supply skilled labaur for the growing Tech industry in Ghana and the sub region. The university has grown over the years and now has four campuses across the country. Student enrallment has also increased from a modest 200 to 5000 currently. GTUC is currently facing a huge data management challenge and needs a system that will effectively store the data and guarantee its integrity and availability GTUC keep informátion of students, including their Identification Numbers, Full names, Addresses, Fee Balance, Phone Numbers, Marks, etc., that enables the university track their financial standing, the courses they have completed and the grades obtained for each course. At the end of each semester, we will calculate the Grade Point Average of each student. Question One a. Create a class for the student in case one, using Identification Number and Full Name as the members of the Class. b. All students take two (2) courses (Advanced VB and Java) per semester and obtained marks for each course. Create a property procedure to write values into and read values from cach Mark member. Be mindful to implements all necessary validations. c. Create a data adapter object called daMyAdapter that will use myComOb to retrieve the data from the Student table and deposit it in a table called studtable which is contained in a dataset called myDatase

Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
icon
Related questions
Question

GTUC was established many years ago with one campus to provide technology education in order to supply skilled labaur for the growing Tech industry in Ghana and the sub region. The university has grown over the years and now has four campuses across the country. Student enrallment has also increased from a modest 200 to 5000 currently. GTUC is currently facing a huge data management challenge and needs a system that will effectively store the data and guarantee its integrity and availability GTUC keep informátion of students, including their Identification Numbers, Full names, Addresses, Fee Balance, Phone Numbers, Marks, etc., that enables the university track their financial standing, the courses they have completed and the grades obtained for each course. At the end of each semester, we will calculate the Grade Point Average of each student.

Question One
a. Create a class for the student in case one, using Identification Number and Full Name as the members of the Class.
b. All students take two (2) courses (Advanced VB and Java) per semester and obtained marks for each course. Create a property procedure to write values into and read values from cach Mark member. Be mindful to implements all necessary validations.

c. Create a data adapter object called daMyAdapter that will use myComOb to retrieve the data from the Student table and deposit it in a table called studtable which is contained in a dataset called myDataset.

Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 2 images

Blurred answer
Knowledge Booster
Concurrency control
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Database System Concepts
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education