Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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.image text in transcribed

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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Making Databases Work The Pragmatic Wisdom Of Michael Stonebraker

Authors: Michael L. Brodie

1st Edition

1947487167, 978-1947487161

More Books

Students also viewed these Databases questions

Question

How many Tables Will Base HCMSs typically have? Why?

Answered: 1 week ago

Question

What is the process of normalization?

Answered: 1 week ago