CISC 3140Quiz4(take home)Overall Objective: Createa databasethat would enable users to track data about squirrels on campus.Groups:Please form groups based on database product.Please present a printed...

1 answer below »
CISC 3140Quiz4(take home)Overall Objective: Createa databasethat would enable users to track data about squirrels on campus.Groups:Please form groups based on database product.Please present a printed copy (1 copy per group) on November 16th,2022of a group report.The reportshould include the following elements:1.Cover page2.List of group members3.Brief description of how your group organizedyourselves for collaboration. For example, whatwas your schedule for meeting for discussion,communication tools used?4.Description of the database product you are usinga.Name of the productb.Versionnumberc.Operating systemsinvolved of group members–include installation instructions for eachoperating systemd.Links to documentation, manual, tutorial, etc.e.Include descriptions on advantages of using this database product to help answer thequestion “why should you use this database for this project?”5.Describe how your data is to be organized in your databasea.Data dictionary–a catalog of data fields (could be single or multiple tables)b.Diagram showing if any collections are linkedThought Prompts:-How would you organize your data into collections/tables/groups? What are theproperties included in each grouping (i.e. fields?)-What does 1 record mean in your database? For example, is a single record a squirrelsighting or a squirrel?6.Give examples of using your database in report form. Common database operations are Create,Read, Update, Delete (CRUD) record(s) so there should be at leastexampleof eachpertable/collection.a.Description of a use caseb.Include your code (or query statement) for that use casec.Include explanations with the codeExample:This database support inserting new squirrel colors, which may be needed when researchersdiscover a new species of squirrels. For example, to add a purple-colored squirrel to thedatabase you must refer to the field color_name from the colors table. The uppercase wordsare required keywords as part of the statement (refer to for documentation on thesyntax), whereas the lower-case words are user defined values.INSERT INTO colors (color_name) VALUES ("purple");Grading will depend on the accuracyand completeness of the report
quiz-4-muj5jux0.docx cisc3140mw2lab3-hm5z4v31.docx text-class-af52hh0i-xla13hyj.docx
Answered 13 days AfterNov 01, 2022

Answer To: CISC 3140Quiz4(take home)Overall Objective: Createa databasethat would enable users to track data...

Banasree answered on Nov 15 2022
52 Votes
SOLUTION.PDF
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here
Have files?