Database Work

Create the E/R model of the database you are going to build. The more variety the better grade. (All kinds of relationships, associative entities, weak entities, multivalued attributes).

Scan the diagram in a file or build the diagram in word or other text processing program.(ER file)

Create the database model in another file and keep it. (Database model file) .... (responding to comment. here you can create a Relational model)

Normalize all the tables to the Boyce-Codd Normal form and explain the process (Normalization file).

requirement

Prison Management Database

Warden

Guard

Cook

Doctor

Janitor

Inmate

Visitor

Cell

Kitchen

Canteen

Office

Armory

Staff Room

Visitation Room

Infirmary

One warden oversees one or more guards

One warden oversees one or more cooks

One warden oversees one or more doctors

One warden oversees one or more janitors

One warden maintains records of one or more inmates

One warden maintains records of zero or more visitors

One warden has one office

One guard can search zero or more inmates

One guard can escort zero or one inmate to a cell

One guard can escort zero or one inmate to a visitation room

One guard can escort zero or one inmate to an infirmary

One guard can escort zero or more visitors to a visitation room

One guard can search zero or more visitors

One guard can search zero or more cells

One or more guards can monitor one canteen

One or more guards can utilize gear from one armory

Zero or more guards can use one staff room

One or more guards can monitor one visitation room

One or more cooks can work in one kitchen

One or more cooks can clean one canteen

One or more doctors can treat zero or more inmates

One or more doctors can work in one infirmary

One janitor can clean zero or more cells

One or more janitors can clean one or more kitchens

One or more janitors can clean one or more canteens

One janitor can clean one or more offices

One janitor can clean one or more armories

One inmate can live in one cell

One inmate can eat in one canteen

One or more visitors can visit one inmate in one visitation room