(solved) HS2021 Database Design and Use Individual Assignment


In this assignment you will use the given case study (Case Study: City Jail) to design a database. You need to analyse the case study to identify database requirements and design a complete E-R Diagram in 3NF form. You will create tables using SQL in Oracle 12c based on your E-R Diagram. Case Study: City Jail Your company receives the following memo. MEMO To: Database Consultant From:City Jail Information Director Subject:Establishing a Crime-Tracking Database System It was a pleasure meeting with you last week. I look forward to working with your company create a much needed crime-tracking system. As you requested, our project group has outlined the crime-tracking data needs we anticipate. Our goal is to simplify