1. CourseId ---- String 2. CourseName ---- String 3. TeacherName ---- String 4. college ---- String 5. number Of Student ---- int } o Student-Course Table \ this table contain a foreign key for both table “ Student and Course ” and contain data about the student who takes some courses or a courses that have number of Student { studentID --- int , foreign key from Student Table courseID --- int , foreign key from Course Table } · The Program should connect to the database and do the following operation : o Add Student o Delete Student o Update Student o View All Students in Table View o Register Student To Course \ this operation should add a new row in the Student-Course Table that means a specified student has participate in a specified c
1. CourseId ---- String 2. CourseName ---- String 3. TeacherName ---- String 4. college ---- String 5. number Of Student ---- int } o Student-Course Table \ this table contain a foreign key for both table “ Student and Course ” and contain data about the student who takes some courses or a courses that have number of Student { studentID --- int , foreign key from Student Table courseID --- int , foreign key from Course Table } · The Program should connect to the database and do the following operation : o Add Student o Delete Student o Update Student o View All Students in Table View o Register Student To Course \ this operation should add a new row in the Student-Course Table that means a specified student has participate in a specified c
Chapter5: Data Manipulation And Transaction Control
Section: Chapter Questions
Problem 10MC
Related questions
Question
· Make an Application called “ Student Management System ” that connect with database called university , the database contain 3 Tables
o Student Table \ this Table contain all Data About Student in University {
1. Id --- int , primarykey
2. Name --- String
3. Gpa --- Double
4. College --- IT
5. Age --- int
}
o Course Table \ this Table contain all Data About Courses in University {
1. CourseId ---- String
2. CourseName ---- String
3. TeacherName ---- String
4. college ---- String
5. number Of Student ---- int
}
o Student-Course Table \ this table contain a foreign key for both table “ Student and Course ” and contain data about the student who takes some courses or a courses that have number of Student {
studentID --- int , foreign key from Student Table
courseID --- int , foreign key from Course Table
}
· The Program should connect to the database and do the following operation :
o Add Student
o Delete Student
o Update Student
o View All Students in Table View
o Register Student To Course \ this operation should add a new row in the Student-Course Table that means a specified student has participate in a specified course
o Show Course Students \ this Operation should show all Student who has participated in specified Course in Table View
Note : Use Scene Builder to Create the Design the Application , and Use Stylesheets to give the application a good Feeling
Notes:
· This Assignment Should be Submitted Before at saturday 5/ 6 / 2021 at 11:55 PM.
· Cheating in this Assignment, will make you get a big Zero Mark.
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps with 2 images
Knowledge Booster
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.Recommended textbooks for you
Programming with Microsoft Visual Basic 2017
Computer Science
ISBN:
9781337102124
Author:
Diane Zak
Publisher:
Cengage Learning
Programming with Microsoft Visual Basic 2017
Computer Science
ISBN:
9781337102124
Author:
Diane Zak
Publisher:
Cengage Learning