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 } ·
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 } ·
Computer Networking: A Top-Down Approach (7th Edition)
7th Edition
ISBN:9780133594140
Author:James Kurose, Keith Ross
Publisher:James Kurose, Keith Ross
Chapter1: Computer Networks And The Internet
Section: Chapter Questions
Problem R1RQ: What is the difference between a host and an end system? List several different types of end...
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
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 3 steps
Recommended textbooks for you
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY