Question
write in java and this the full instructions i have Create a database software application, Scheduling Matrix Database that supports an EFSC Class Scheduling Matrix
write in java and this the full instructions i have
Create a database software application, Scheduling Matrix Database that supports an EFSC Class Scheduling Matrix (refer to Preliminary Computer Programming Matrix). The Scheduling Matrix Database application will populate and display the contents of the database that support the development of an application for the Computer Programming Matrix.
Team C (Campus Offerings Table GUI) Responsibilities
- Develop CampusOfferingsGUI, Figure 1 application to display contents, and perform DML activities (insert, update and delete) on the table using a JTable GUI component. Use the JTable features that provides for editing (i.e. updating the cells within the GUI course and the TableModel to be updated). The Insert button should provide for entering data for all the fields in the table. The Delete button will cause the selected row to be deleted from the TableModel. Both Insert & Delete will cause the JTable to be redisplayed after the changes have been completed. The JavaDB database must also be updated with any changes that have been applied.
- See Note below
Note: TeamB & TeamC should create a class that implements the SchedulingMatrixInterf interface for reading/writing data to the table . The class that implements this interface will simulate the database table interaction by using a text file that has the same fields as the actual table. This will provide a means for the team to develop their application without being slowed and having to wait for TeamA to finish their part of the project.
Tables Design
Required Database Fields
Course_ID, Semester_ID, Course_Description, Credits, Contact_Hours, PalmBay, Melbourne, Cocoa, Titusville, EFSCOnline
Tables
Course { Course ID [PK], Course_Description, Credits, Contact_Hours (default:48)}
CampusOffering { {Course_ID [FK], Semester_ID} [PK], PalmBay , Melbourne, Cocoa, Titusville, EFSCOnline }
Notes:
2. For this project, use all of the courses listed in the Computer Programming A.S. degree (use the college Website to access the degree). Use the information in the Computer Programming Matrix located in the Team Project module to populate the CampusOffering table. Information for the Course table can be found in the Course Objectives located at the link below.
3. The data types for the fields of the database are below.
Field Name | Data Type |
CourseID | Text (e.g. CGS1000) |
SemesterID | Integer (e.g., 201710) |
CourseDescription | Text |
Credits | Integer |
ContactHours | Integer |
PalmBay | Boolean |
Melbourne | Boolean |
Cocoa | Boolean |
Titusville | Boolean |
EFSCOnline | Boolean |
The semester data uses a 2-digit integer value to represent the semester (i.e., 10 for Spring, 20 for Summer, and 40 for Fall). The SemesterID field is a combination of the year and the semester code (represented as SC in the following pattern).
SemesterID Pattern YYYYSC (e.g., 201710 represent the Spring 2017 semester)
The campus field names (e.g., PalmBay) specify whether the course will be offered at the campus during the semester specified by the SemesterID field.
Scheduling Matrix Database Course Table Course ID Description Credits Contact Hours Insert Row Delete Row(s) Campus Offerings Table CourselD SemesterID PB Me Co T ELearning Insert Row Delete Row(s) Exit Figure 1.-Scheduling.MatrixDatabase GUIT Scheduling Matrix Database Course Table Course ID Description Credits Contact Hours Insert Row Delete Row(s) Campus Offerings Table CourselD SemesterID PB Me Co T ELearning Insert Row Delete Row(s) Exit Figure 1.-Scheduling.MatrixDatabase GUITStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started