Scenario

Campus POLICEMEN issue CITATIONS for various OFFENSES committed by STUDENTS. It is their policy to refer non-student offenders to local City police officers for citations. PENALTIES for offenses can range from warnings to university disciplinary action, to actual fines (which are sent to County Judge for prosecution.)

Design ALL Tables

needed to build a database solution for the scenario described above. Be sure to follow principles of geed design (normalize) as you go. Describe the tables in TEXT format (identify foreign keys in some way that is clearly visible if you don’t like italics): TABLE(PrimaryKey, attribute, attribute)

Assumptions

Make and state assumptions as needed. Be sure your design reflects these assumptions.

Draw the ERD

Go ahead and SHOW foreign keys in your entities on the ERD even though they are not technically supposed to be there. LABEL relationship lines with words, be sure to mark cardinality (min and max on both ends of each line).

Describe the Table Structure

of each table

Show sample data

for three (or more) rows of each table.

Academic Honesty!
It is not our intention to break the school's academic policy. Projects posted are only used as a reference and should not be submitted as is. We are not held liable for any misuse of the solutions. Please see the frequently asked questions page for further questions and inquiries.
Kindly fill out the form. Please provide a valid email address and we'll get back to you in less than 24 hours. We will be sending an invoice through PayPal upon confirmation. We are a non profit organization however we need an amount to keep this organization running, and to be able to complete our research and development.