Learning Goal: I’m working on a databases writing question and need an explanati

Learning Goal: I’m working on a databases writing question and need an explanation and answer to help me learn.A summer camp is using an Oracle database to manage its campers, activities, and which campers are
registered for which activities. Each camper is identified by their unique cid. Each camper will have a
name, an age, and a zip code corresponding to their home address. For each activity the camp offers, it
is identified by a unique aid. It also has a name, a price which is the cost to a camper to register for the
activity, and a capacity for the maximum number of campers allowed to participate in the activity. The
registration table stores which campers have registered for which activities. You are allowed flexibility
on the exact attribute types you use for your schema, given they reasonably match the specification
below (e.g. in terms of number types, string types). Include the schema definition in your submission in
a file called schema.sql. Campers(cid: integer, name: string, age: integer, zipcode: integer) Activities(aid: integer, name: string, price: real, capacity: integer)
Registration(cid: integer, aid: integer)
Requirements: as per requirement   |   .doc file

Leave a Reply

Your email address will not be published.