Database: File: prisonDB.sql

Create database PrisonDB;

Use PrisonDB;

Create Table Prison (

prisonerID int auto_increment not null,

lastName varchar(25),

firstName varchar(25),

photo varchar(25),

birthDate date,

height decimal,

hair varchar(15),

eyes varchar(15),

placeOfBirth varchar(15),

sentence varchar(255),

dateOfConviction date,

dateToBeLiberated date,

unique(prisonerID)

);

insert into Prison

values (null, 'Manson', 'Charles', 'cmanson.jpg', '1934-11-12', 5.7, 'black', 'black', 'USA',

'Commuted to life imprisonment without the possibility of parole', '1951-10-01', null);

Select * from Prison;

Image of database:

To write a program that implements the following Advanced Programming concepts: 1. Data encapsulation 2. Instantiate classes 3. Inheritance 4. Graphical User Interface concepts 5. Database Project Name: Prison The program will have the following private attributes: 1. Prisoner's id 2. Prisoner's name 3. Prisoner's last name 4. photo (picture name saved in directory) 5. birth date 6. height (feet inches) 7. hair 8. eyes 9. where born 10. sentence 11. date of conviction 12. date to be liberated The program will have the following menu and menu items: 1. File - Add prisoner - Modify prisoner - Search for a prisoner - Display prisoners list - Exit 2. Help - Help Contents - About Items menu description: - Add prisoner - will add a new prisoner - Modify prisoner-modify an existent prisoner - Search for a prisoner - search should be made by prisoner's id then display all information of the prisoner and must display the photo as well. - Display List of prisoner - will display a table with all the prisoners which will liberated after a date. - Help contents - will display the help of your program. - About - will display an about window displaying each of your member team names. Create database PrisonDB; Use PrisonDB; Create Table Prison ( prisonerID int auto_increment not null, lastName varchar(25), firstName varchar(25), photo varchar (25), birthDate date, height decimal, hair varchar (15), eyes varchar(15), placeofBirth varchar (15), sentence varchar (255), dateofConviction date, dateToBeLiberated date, unique (prisonerID) ); insert into Prison values (null, 'Manson', 'Charles', 'Cmanson.jpg', '1934-11-12', 5.7, 'black', 'black', 'USA', 'Commuted to life imprisonment without the possibility of parole', '1951-10-01', null); Select * from Prison; To write a program that implements the following Advanced Programming concepts: 1. Data encapsulation 2. Instantiate classes 3. Inheritance 4. Graphical User Interface concepts 5. Database Project Name: Prison The program will have the following private attributes: 1. Prisoner's id 2. Prisoner's name 3. Prisoner's last name 4. photo (picture name saved in directory) 5. birth date 6. height (feet inches) 7. hair 8. eyes 9. where born 10. sentence 11. date of conviction 12. date to be liberated The program will have the following menu and menu items: 1. File - Add prisoner - Modify prisoner - Search for a prisoner - Display prisoners list - Exit 2. Help - Help Contents - About Items menu description: - Add prisoner - will add a new prisoner - Modify prisoner-modify an existent prisoner - Search for a prisoner - search should be made by prisoner's id then display all information of the prisoner and must display the photo as well. - Display List of prisoner - will display a table with all the prisoners which will liberated after a date. - Help contents - will display the help of your program. - About - will display an about window displaying each of your member team names. Create database PrisonDB; Use PrisonDB; Create Table Prison ( prisonerID int auto_increment not null, lastName varchar(25), firstName varchar(25), photo varchar (25), birthDate date, height decimal, hair varchar (15), eyes varchar(15), placeofBirth varchar (15), sentence varchar (255), dateofConviction date, dateToBeLiberated date, unique (prisonerID) ); insert into Prison values (null, 'Manson', 'Charles', 'Cmanson.jpg', '1934-11-12', 5.7, 'black', 'black', 'USA', 'Commuted to life imprisonment without the possibility of parole', '1951-10-01', null); Select * from Prison