Study with the several resources on Docsity
Earn points by helping other students or get them with a premium plan
Prepare for your exams
Study with the several resources on Docsity
Earn points to download
Earn points by helping other students or get them with a premium plan
Entity Relationship Diagram, Notational Note, ERD, ER Diagrams, Company Schema, Structural Constraints, Role Names, Supply Relationship, Binary Relationship, Weak Entity, Relational Database Schema, Epidemiological Database, Reactivity Test, N-ary Relationship, LAMP Projects, Tips for LAMP Projects
Typology: Study Guides, Projects, Research
1 / 14
This page cannot be seen from the preview
Don't miss anything!
Cardinality Ratio Notation “Each entity of S can berelated to any number ofentities of T. An entity of Tcan be related to 1 (or zero)entities of S.”
Participation Notation “Each entity is S participatesin the relation either zero ofone times”
patient
name
b_date
sex
isolate
infection
date
severity
drugs Gene
sequence
Reactivity
test
Test result
Title:
Roster for
/roster.php
Description:
Display roster of players for a single team
Inputs:
teamID - the ID of the team whose roster is to be shown
HTML overview:
the primary content of the page is a table
containing first name, last name, position and # of games playedfor each player on team. First and last name are links to stats.php.
Include navigation links at top of page
SQL statements: 1)
select statement on
teams
table to retrieve full name of tea
Select statement on event and player tables to retrieve info on allplayers that played for that team.
