Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Hey, I need help . For each of the following constraints give a one-sentence explanation of what the constraint implies, and why it is required.

Hey, I need help . For each of the following constraints give a one-sentence explanation of what the constraint implies, and why it is required. The relations are given below image text in transcribedimage text in transcribed

Given the relations below: relations Collection(CID, date, SID) Tuples here represent entire collections from a field trip, where CID is the collection ID, date is the starting date of the field trip, and SID is the staff ID of the collector Collected(CID, AN) A tuple here represents the fact that collection CID includes artifact number AN. A single collec- tion usually contains multiple artifacts, and a single artifact may be aggregated from more than one collection Artifact(AN, species, type, location, SID) Tuples here represent single artifact collected in the field. AN is the artifact number, species is the scientific species name, type is one of tissue, image, model, or live, location is where it was collected, and SID is the staff number of the technician who maintains this artifact. Publish ed(AN, journal, date) A tuple here represents the fact that artifact AN was mentioned in scholarly publication journal with publication date date. Staff(SID, name, email, rank, date) These tuples represent a member of the institute's scientific staff. SID is the staff ID, name is their full name, email is their profession al email, rank is one of technician, student, pre-tenure, or tenured, and date is the date when they attained that rank. COL(family) A singleton tuple here means that family is a scientific zoological family name that appears in the Catalogue of Life Genus(genus, family) A tuple here means that genus is in family family. Species(species, genus) A tuple here means that species is in genus genus For each of the following constraints give a one sentence explanation of what the constraint implies, and why it is required Tispecies(Artifact) - Tspecies(Species) = 0. Trank(Staff) {'technician', 'student', 'pre-tenure', 'tenure'). Tfamily (Genus) family (COL) = 0. Tigenus (Species) Tigenus (Genus). TCID(Collected) = TCID(Collection), TAN(Artifact) = TAN(Collected). Tsip(Collection) Tsip(Staff). Tsip Arti fact) C TSID(Staff). Ttype (Artifact) {'tissue','image', modell, live} TAN(Published) STAN(Artifact)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database Design For Mere Mortals

Authors: Michael J Hernandez

4th Edition

978-0136788041

More Books

Students also viewed these Databases questions