Computer Science Projects

Dog Registration Database Objective Track data for dogs, owners and violations Create an ER diagram Create searches and output using relational algebra Background The Yorkie’s Dominance: We Analyzed Every Dog Registration in New York, New York Times, February 10, 2018. Database Design Your design must track the at least following categories Dog owner information including name, address and email. Dog owners can own many dogs. Dog information including dog name, breed, gender, weight, age, photos and owner. Track current and previous dog owners. A dog can have many photos. Dog owners can receive tickets with violations including dog, owner, violation type, fine, date of violation and current status of violation. One ticket can include many violations. Identify and create the following in your database design Entity Relationship (ER) diagram Relations Degree Primary and foreign keys Domains Relationship between entities Relationship type Attributes Cardi...

Relational Algebra A database records information about athletes competing at the Olympics. An athlete competes for a particular country in one or more events. Events take place at a scheduled day and time in a particular venue. The result (rank) is recorded for all athletes in the final of the event. The medal (gold, silver or bronze) is also recorded for the medal winners in the event. Note that we are not considering team sports or heats in this example – only individuals competing in the finals. The schema for this database is as follows: (Note that primary keys are shown underlined, foreign keys in bold). ATHLETE ( AthleteNo , AthleteName, CountryName) COUNTRY ( CountryName , NumberOfCompetitors) EVENT (EventName, ScheduledStart, VenueName ) VENUE (VenueName, City, Capacity) FINAL ( AthleteNo , EventName , Rank, Medal) Provide relational algebra (NOT SQL) queries to find the following informaList the name and country of all athletes. List the event name and scheduled start time fo...

Relational Algebra A database records information about athletes competing at the Olympics. An athlete competes for a particular country in one or more events. Events take place at a scheduled day and time in a particular venue. The result (rank) is recorded for all athletes in the final of the event. The medal (gold, silver or bronze) is also recorded for the medal winners in the event. Note that we are not considering team sports or heats in this example – only individuals competing in the finals. The schema for this database is as follows: (Note that primary keys are shown underlined, foreign keys in bold). ATHLETE ( AthleteNo , AthleteName, CountryName) COUNTRY ( CountryName , NumberOfCompetitors) EVENT (EventName, ScheduledStart, VenueName ) VENUE (VenueName, City, Capacity) FINAL ( AthleteNo , EventName , Rank, Medal) Provide relational algebra (NOT SQL) queries to find the following informaList the name and country of all athletes. List the event name and scheduled start time fo...