St Pete Reintegrate  is a halfway house for prison inmates who are…

ColonelGalaxyPigeon29 St Pete Reintegrate  is a halfway house for prison inmates who are…St Pete Reintegrate is a halfway house for prison inmates who are within a year of completing their prison sentences.  St Pete Reintegrate is dedicating to helping inmates reintegrate into society to cut down on the recidivism rate.  It does this by providing counselling and educational services.  It wants to build a database to keep track of how well its clients successfully reintegrate.St Pete Reintegrate wants to record for each of its clients their name, gender, age, and the date in which they entered the half-way house.St Pete Reintegrate want to capture information about the criminal records of their clients.  A criminal record consists of a unique crime ID, the type of crime committed, the date the crime was committed, the date on which the client was sentenced for the crime, and the length of the sentence.  Clients have at least one criminal record, but can have many.  Each criminal record must be associated with a unique client.St Pete Reintegrate offers a number of courses, each of which has a title, and a duration.  A client can complete many courses, and a course can be completed by many clients.  For each course completion, St Pete Reintegrate wants to record the date on which the client completed the course, the grade they received in the course, and how well the client behaved in the course.  St Pete Reintegrate has developed a numerical score that is uses to record how well a client behaved in a course.St Pete Reintegrate also offers different counseling services, each of which has an area of focus, such as conflict resolution, substance abuse, and so on.  Clients can use as many counseling services as they wish but they must use at least one.  Also, counseling services can be offered to many clients.  If a client uses a particular counseling service, St Pete Reintegrate wants to record how many hours the client used the counseling service.St Pete Reintegrate also helps its clients apply for jobs, and it therefore maintains a list of job openings that it receives from local companies.  For each job opening, St Pete Reintegrate wants to keep track of the job title, the name of the company offering the job, and the hourly wage.  If a client applies for a job, St Pete Reintegrate wants to record the application date, and whether the client’s application was successful.  Multiple clients may apply for the same job, but St Pete Reintegrate keeps a a record of all job openings, even if no client has applied (yet).To help clients successfully complete their programs with St Pete Reintegrate, it also assigns mentors to clients, typically clients that are closer to completing their program with St Pete Reintegrate.  Each client can be assigned at most one mentor, but a client may mentor any number of other clients, including none. Turn ERD into a set of logical tables.  Where required, normalize the tables to 3NF.  Turn the normalized tables into a physical design in the form of set of CREATE TABLE SQL statements.  Submit a word document with both the logical and physical designs to the assignment box below.BusinessBusiness – Other