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

  1. 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.
  2. 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.write in java and this the full instructions i have Create a

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 GUIT

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!