Homework Help is Here – Start Your Trial Now!
Engineering
Computer Science
There is a local soccer league in Lennoxville, with 4 teams (named Jaguars, Lions, Tigers and Gazelles) Girls aged 10-14 can sign up to join the league, later they are assigned to teams. Each team has a head coach, who is assisted by some other adults. Note that assistants may help more than one team. One game can be played per day on the single field that is available, at Atto-Beaver park. A schedule will be set up, the two teams that play on a day will be designated “home” who get to wear colourful jerseys (shirts), while the other will be "visitor" and wear white jerseys. After a game is played, each team will have 1 added to its number of wins, losses or ties, depending upon the outcome of the game. The attributes for each entity are: Players: name, address, phone, birthdate Teams: name, wins, losses, ties -- counts initially 0 Coaches: name, phone, year_joined The E-R diagram follows: Head coach Players assigned Teams Coaches assists visitor home home_points game visitor_points date Design the relational schema, indicating primary and foreign keys, and any referential integrity or other constraints you believe are necessary. For instance, a team cannot play itself! Also give the Relation Algebra for queries 1. and 2. below. Again, there are problems for plain text files: Greek characters for л use PROJ, for σ use SEL, for use JOIN, for τ use SORT To represent tree structure use (parentheses), or use to form the tree Example PROJ (code, title, credits) JOIN (name=prof) SEL (prof='Jensen') COURSE PROF

There is a local soccer league in Lennoxville, with 4 teams (named Jaguars, Lions, Tigers and Gazelles) Girls aged 10-14 can sign up to join the league, later they are assigned to teams. Each team has a head coach, who is assisted by some other adults. Note that assistants may help more than one team. One game can be played per day on the single field that is available, at Atto-Beaver park. A schedule will be set up, the two teams that play on a day will be designated “home” who get to wear colourful jerseys (shirts), while the other will be "visitor" and wear white jerseys. After a game is played, each team will have 1 added to its number of wins, losses or ties, depending upon the outcome of the game. The attributes for each entity are: Players: name, address, phone, birthdate Teams: name, wins, losses, ties -- counts initially 0 Coaches: name, phone, year_joined The E-R diagram follows: Head coach Players assigned Teams Coaches assists visitor home home_points game visitor_points date Design the relational schema, indicating primary and foreign keys, and any referential integrity or other constraints you believe are necessary. For instance, a team cannot play itself! Also give the Relation Algebra for queries 1. and 2. below. Again, there are problems for plain text files: Greek characters for л use PROJ, for σ use SEL, for use JOIN, for τ use SORT To represent tree structure use (parentheses), or use to form the tree Example PROJ (code, title, credits) JOIN (name=prof) SEL (prof='Jensen') COURSE PROF

Database System Concepts
Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
See similar textbooks
icon
Related questions
Question
There is a local soccer league in Lennoxville, with 4 teams (named Jaguars, Lions, Tigers and Gazelles) Girls aged 10-14 can sign up to join the league, later they are assigned to teams. Each team has a head coach, who is assisted by some other adults. Note that assistants may help more than one team. One game can be played per day on the single field that is available, at Atto-Beaver park. A schedule will be set up, the two teams that play on a day will be designated “home” who get to wear colourful jerseys (shirts), while the other will be "visitor" and wear white jerseys. After a game is played, each team will have 1 added to its number of wins, losses or ties, depending upon the outcome of the game. The attributes for each entity are: Players: name, address, phone, birthdate Teams: name, wins, losses, ties -- counts initially 0 Coaches: name, phone, year_joined The E-R diagram follows: Head coach Players assigned Teams Coaches assists visitor home home_points game visitor_points date Design the relational schema, indicating primary and foreign keys, and any referential integrity or other constraints you believe are necessary. For instance, a team cannot play itself! Also give the Relation Algebra for queries 1. and 2. below. Again, there are problems for plain text files: Greek characters for л use PROJ, for σ use SEL, for use JOIN, for τ use SORT To represent tree structure use (parentheses), or use to form the tree Example PROJ (code, title, credits) JOIN (name=prof) SEL (prof='Jensen') COURSE PROF
Transcribed Image Text:There is a local soccer league in Lennoxville, with 4 teams (named Jaguars, Lions, Tigers and Gazelles) Girls aged 10-14 can sign up to join the league, later they are assigned to teams. Each team has a head coach, who is assisted by some other adults. Note that assistants may help more than one team. One game can be played per day on the single field that is available, at Atto-Beaver park. A schedule will be set up, the two teams that play on a day will be designated “home” who get to wear colourful jerseys (shirts), while the other will be "visitor" and wear white jerseys. After a game is played, each team will have 1 added to its number of wins, losses or ties, depending upon the outcome of the game. The attributes for each entity are: Players: name, address, phone, birthdate Teams: name, wins, losses, ties -- counts initially 0 Coaches: name, phone, year_joined The E-R diagram follows: Head coach Players assigned Teams Coaches assists visitor home home_points game visitor_points date Design the relational schema, indicating primary and foreign keys, and any referential integrity or other constraints you believe are necessary. For instance, a team cannot play itself! Also give the Relation Algebra for queries 1. and 2. below. Again, there are problems for plain text files: Greek characters for л use PROJ, for σ use SEL, for use JOIN, for τ use SORT To represent tree structure use (parentheses), or use to form the tree Example PROJ (code, title, credits) JOIN (name=prof) SEL (prof='Jensen') COURSE PROF
AI-Generated Solution
AI-generated content may present inaccurate or offensive content that does not represent bartleby’s views.
steps

Unlock instant AI solutions

Tap the button
to generate a solution

SEE SOLUTION
Similar questions
Recommended textbooks for you
Database System Concepts
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education
SEE MORE TEXTBOOKS