School database. Create a database for managing students, faculty, and courses f

Question

School database. Create a database for managing students, faculty,
and courses for a Computer Systems Technology department of a school.
Assume all students and faculty are a part of this department. (In
other words, you do not need to keep track of details like major or
department affiliation.) The Student table should have studentId,
firstName, mi, lastName, and email. The Faculty should have the same
fields. There should also be a table for courses, enrolment (matching
students to courses and final grades), and course assignment
(matching faculty to courses). Use MySQL for the database. The username should be “school” and the password should be “java”.Using NetBeans, create a GUI interface for interacting with thedatabase. The interface should allow users to add, query, edit, or remove any table in the database.

//here is the similar program

package schooldatabaseexample;

import java.beans.PropertyChangeListener;
import java.beans.PropertyChangeSupport;
import java.io.Serializable;
import javax.persistence.Basic;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.Id;
import javax.persistence.NamedQueries;
import javax.persistence.NamedQuery;
import javax.persistence.Table;
import javax.persistence.Transient;


@Entity
@Table(name = "Student", catalog = "school", schema = "")
@NamedQueries({
@NamedQuery(name = "Student.findAll", query = "SELECT s FROM Student s"),
@NamedQuery(name = "Student.findByIdStudent", query = "SELECT s FROM Student s WHERE s.idStudent = :idStudent"),
@NamedQuery(name = "Student.findByFirstName", query = "SELECT s FROM Student s WHERE s.firstName = :firstName"),
@NamedQuery(name = "Student.findByMi", query = "SELECT s FROM Student s WHERE s.mi = :mi"),
@NamedQuery(name = "Student.findByLastName", query = "SELECT s FROM Student s WHERE s.lastName = :lastName"),
@NamedQuery(name = "Student.findByEmail", query = "SELECT s FROM Student s WHERE s.email = :email")})
public class Student implements Serializable {
@Transient
private PropertyChangeSupport changeSupport = new PropertyChangeSupport(this);
private static final long serialVersionUID = 1L;
@Id
@Basic(optional = false)
@Column(name = "idStudent")
private Integer idStudent;
@Basic(optional = false)
@Column(name = "firstName")
private String firstName;
@Column(name = "mi")
private Character mi;
@Basic(optional = false)
@Column(name = "lastName")
private String lastName;
@Basic(optional = false)
@Column(name = "email")
private String email;

public Student() {
}

public Student(Integer idStudent) {
this.idStudent = idStudent;
}

public Student(Integer idStudent, String firstName, String lastName, String email) {
this.idStudent = idStudent;
this.firstName = firstName;
this.lastName = lastName;
this.email = email;
}

public Integer getIdStudent() {
return idStudent;
}

public void setIdStudent(Integer idStudent) {
Integer oldIdStudent = this.idStudent;
this.idStudent = idStudent;
changeSupport.firePropertyChange("idStudent", oldIdStudent, idStudent);
}

public String getFirstName() {
return firstName;
}

public void setFirstName(String firstName) {
String oldFirstName = this.firstName;
this.firstName = firstName;
changeSupport.firePropertyChange("firstName", oldFirstName, firstName);
}

public Character getMi() {
return mi;
}

public void setMi(Character mi) {
Character oldMi = this.mi;
this.mi = mi;
changeSupport.firePropertyChange("mi", oldMi, mi);
}

public String getLastName() {
return lastName;
}

public void setLastName(String lastName) {
String oldLastName = this.lastName;
this.lastName = lastName;
changeSupport.firePropertyChange("lastName", oldLastName, lastName);
}

public String getEmail() {
return email;
}

public void setEmail(String email) {
String oldEmail = this.email;
this.email = email;
changeSupport.firePropertyChange("email", oldEmail, email);
}

@Override
public int hashCode() {
int hash = 0;
hash += (idStudent != null ? idStudent.hashCode() : 0);
return hash;
}

@Override
public boolean equals(Object object) {
// TODO: Warning - this method won't work in the case the id fields are not set
if (!(object instanceof Student)) {
return false;
}
Student other = (Student) object;
if ((this.idStudent == null && other.idStudent != null) || (this.idStudent != null && !this.idStudent.equals(other.idStudent))) {
return false;
}
return true;
}

@Override
public String toString() {
return "schooldatabaseexample.Student[ idStudent=" + idStudent + " ]";
}

public void addPropertyChangeListener(PropertyChangeListener listener) {
changeSupport.addPropertyChangeListener(listener);
}

public void removePropertyChangeListener(PropertyChangeListener listener) {
changeSupport.removePropertyChangeListener(listener);
}

}


2nd part


import org.jdesktop.application.Application;
import org.jdesktop.application.SingleFrameApplication;


public class SchoolDatabaseExampleApp extends SingleFrameApplication {


@Override protected void startup() {
show(new SchoolDatabaseExampleView(this));
}

@Override protected void configureWindow(java.awt.Window root) {
}


public static SchoolDatabaseExampleApp getApplication() {
return Application.getInstance(SchoolDatabaseExampleApp.class);
}


public static void main(String[] args) {
launch(SchoolDatabaseExampleApp.class, args);
}
}

Explanation / Answer

Hi I have done the solution for this in my notebook. But the solution is too big , I cannot type it here because very less time is remaining.. So please rate me Lifesaver and I'll share the answer with you through email or cramster inbox. I don't do this generally, but I have no other option here because there's very less time left... you need not worry as I have the solution ready

Related Questions

Navigate

• Browse (All)
• Browse S
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.