Take Test: P2 Assignment
Take Test: P2 Assignment
Top of Form
Test InformationDescription Instructions This page contains the instructions for the database you need to model for your project.
General Instructions
You will receive a unique random database specification. You must follow these instructions for your received database specification.
You must create a database design in MySQL Workbench and create a professional report presenting your design. Based on your provided specification (different for each student) you must create a simple database design.
This is a CLOSED BOOK assignment, and you are not allowed to use any external information to solve it. Be sure that you use the URL that was assigned to you. Solving a different version of the assignment will result in a grade of zero for this assignment and may result in honor committee referral.
You must continue the design you received in Part 1. Be sure you correct part 1 based on the comments received. The grade for part 2 is global.
Database Model Conventions
You must follow these conventions when you perform your homework. Failing to follow the conventions will be penalized per each mistake and may also constitute evidence of cheating.
Entity names: singular nouns (or noun phrase) written in CAPITAL LETTERS, using _ instead of space, must end with a two letter sufix with your first name and last name initials (e.g. if your name is John Doe, an entity name will be PERSON_JD)
Attribute names: singular nouns (or noun phrase) written in CAPITAL LETTERS, using _ instead of space, must end with a two-letter sufix with your first name and last name initials (e.g. if your name is John Doe, an attribute name will be FIRST_NAME_JD)
Relationship names: third person verbs (or verb phrase) written in lower case letters, using spaces. Do not use "has" or other generic names. Use a name that clarifies the meaning (even if contains entity names)
Additional conventions might be specified by your instructor (e.g. prefix the attribute names with the entity name or abbreviation)
Report Overview (PDF)
Your report must contain the following sections, which are described below:
Cover Page
Conceptual Design
Entities Analysis
Relationship Analysis
Entity Relationship Diagram
Cover Page
The report must start with a professionally designed cover page including all the following information:
Your name
Your course and section
A suggestive title for your report
A short original description of the database (at least two sentences)
Relevant graphics or picture (must be a suggestive picture for the content of your report)
Conceptual Analysis
Before you start a detailed analysis you must figure out which are the main elements in your design
Identify the main entities involved
Identify the main relationship involved.
Identify the relationship type and explain how you obtained it
For many to many relationships identify the bridge, and the two other relationships needed.
Entities Analysis
You must identify and analyze the entities identified including the bridges:
Entity name
Entity description (a short paragraph)
An attribute table, with one row for each attribute and with the following columns:
Attribute name
Attribute domain and size, e.g. CHAR(10), INT, VARCHAR(30)
Simple/Composite (without explanations)
Single/Multi Value (without explanations)
Required/Optional (without explanations)
Unique/Duplicated (without explanations)
The selected primary key and its type (simple/composite/surrogate).
Any foreign key specifying the referenced primary key and entity.
Relationship Analysis
Relationship name: PARENT_ENTITY relationship name CHILD_ENTITY (the name is a verb or verb phrase 3rd singular)
Relationship type with explanation
Relationship strength with explanation
Entities participation in the relationship with explanations
Any special cardinality as needed, or state there is no special cardinality.
Foreign key used for representation.
Entity Relationship Diagram
After you finished the entity analysis you must draw the ERD in MySQL Workbench and include in your report the following screenshot(s):
A signed screenshot(s) with the ERD for this entity done in MySQL Workbench (to sign a screenshot you write your name in a text object visible in the screenshot; crop the image to show only the ERD and the text object)
What to submit
You must submit the following files:
A PDF file containing the report for your database (as described above)
A MWB file containing the database model done in MySQL Workbench
Submission instructions:
You must use assignment submission item on Blackboard to submit your assignment.
You must name the files: P2_lastname_firstname.pdf and P2_lastname_firstname.mwb
You must not have the files open in a program when you submit them, because they might not be submitted correctly.
Double check the files before submission. You are not allowed to resubmit your assignment. Do not ask for resubmission because cannot be granted. Allowing one student to resubmit will imply to allow all the students to resubmit from all the sections (in order to be fair). This cannot be handled.
ZERO GRADE:
You will receive a grade of zero in ANY of the following situations:
The report was done based on instructions from a previous semester.
The report was done based on specifications from a previous semester.
Your ERD screenshot(s) are not signed, or signed correctly (a textbox added in MySQL Workbench with your name)
The names of your entity do not follow the name prefix/suffix rule described above.
The names of your attributes do not follow the name prefix/suffix rule described above.
Multiple Attempts Not allowed. This test can only be taken once.
Force Completion This test can be saved and resumed later.
Your answers are saved automatically.
Question Completion Status:
QUESTION 1
Include the MWB file for the project (here graded for submission and consistency with the report). The correctness is graded in the report.
Attach File
0.5 points
QUESTION 2
Requirements Specification
This page contains additional requirements specifications for the database you need to model for your project.
Happy Learning (this is a fictional scenario)
The kindergarten allows the parents (caretakers) to select daily the menu for lunch. There are over 35 possible items to be included in the lunch menu. For a lunch item we keep an up to 4 characters code, its name (up to 27 characters), and the number of calories (an integer).
A parent (caretaker) can make for each of his/her children a lunch order everyday. All orders made are stored. If no order is made in a day the last order made will be provided. An order consists of maximum 5 items. Same item cannot be ordered multiple times in the same order. The order stores the caretaker who made the order.
Include the PDF report file here.
Attach File
Bottom of Form
S1 SQL Implementation Assignment
INSTRUCTIONS
Instructions
S1 Single Table Database - Assignments
Assignment S1-1 Instructions
This assignment teaches you how to implement a single table database, starting with a specification.
General Instructions
You received a unique random database specification. You must follow these instructions for your received database specification. Video examples are not following this version of the assignment.
You must perform the following tasks. The provided specification is different for each student. You must create the ERD design and implement the database for the specification you received.
This is a CLOSED BOOK assignment, and you are not allowed to use any external information to solve it. Be sure that you use the question that was assigned to you. Solving a different version of the assignment will result in a grade of zero for this assignment and may result in honor committee referral.
ZERO GRADE:
You will receive a grade of zero in ANY of the following situations:
Not following the instructions from this semester (e.g. following instructions aspects from previous semesters, e.g. the format of your report)
Not following your specifications (2-3 elements in your design are not based on this semester requirements but they follow previous semesters requirements or other versions of questions from this semester)
Your ERD screenshot(s) are not signed, or are not signed correctly (a textbox added in MySQL Workbench with your name)
The names of your entity do not follow the name prefix/suffix rule described below.
The names of your attributes do not follow the name prefix/suffix rule described below.
The code has very similar parts with another student's submission.
Database Model Conventions
You must follow these conventions when you perform your homework. Failing to follow the conventions will be penalized per each mistake and may also constitute evidence of cheating.
Entity names: singular nouns (or noun phrase) written in CAPITAL LETTERS, using _ instead of space, must end with a two letter sufix with your first name and last name initials (e.g. if your name is John Doe, an entity name will be PERSON_JD)
Attribute names: singular nouns (or noun phrase) written in CAPITAL LETTERS, using _ instead of space, must end with a two-letter sufix with your first name and last name initials (e.g. if your name is John Doe, an attribute name will be FIRST_NAME_JD)
Relationship names: third person verbs (or verb phrase) written in lower case letters, using spaces. Do not use "has" or other generic names. Use a name that clarifies the meaning (even if contains entity names)
Additional conventions might be specified by your instructor (e.g. prefix the attribute names with the entity name or abbreviation)
Your report must contain the following:
Assignment:S1
Name:YOUR NAME
Section:YOUR COURSE AND SECTION
Task 1 - ERD Model
Based on the specification received create a ERD in MySQL Workbench.
Sign the ERD by writing your name in a text object.
Take a picture of your ERD.
Include in the report file the following:
A heading: Task 1 - ERD Model
The signed screenshot (image) of the ERD
Task 2 - Create database
Start writing the SQL script in MySQL Workbench to perform the following operations:
Include a comment: Task 2 Create database by ... (your name)
If there is a database with the provided name, delete that database.
Add a database with that name.
Mark the created database as the default database for the following operations.
Show all the databases, find the created one in the list
Execute and debug the script in MySQL Workbench until runs without error and performs the above operations.
Include in the report file the following:
A heading: Task 2 - Create database
A screenshot (image) of the source code for this task only (crop the image if necessary) - top of the screen
A screenshot (image) of the results for the performed operations - bottom of the screen
Task 3 - Create table
Continue writing the SQL script in MySQL Workbench, adding the following operations:
Include a comment: Task 3 - Create table by ... (your name)
List all the tables in the database (no table expected).
Create a table with the required specification.
List all the tables in the database (again - the new table must appear).
Show the structure of the created table.
Execute and debug the script in MySQL Workbench until runs without error and performs the above operations.
Include in the report file the following:
A heading: Task 3 - Create table
A screenshot (image) of the source code for this task only (crop the image if necessary) - top of the screen
A screenshot (image) of the results for the performed operations - bottom of the screen
Three screenshots with the generated tables by the above commands, included in the order of the commands- middle of the screen in different tabs
Task 4 - Add data
Continue writing the SQL script in MySQL Workbench, adding the following operations:
Include a comment: Task 4 - Add data by ... (your name)
Show all the data in your table (no data expected).
Add 5 rows of data, start with the provided data items in the order they are provided, and imagine new data for the other ones
Show all the data in your table (five rows expected).
Execute and debug the script in MySQL Workbench until runs without error and performs the above operations.
Include in the report file the following:
A heading: Task 4 - Add data
A screenshot (image) of the source code for this task only (crop the image if necessary) - top of the screen
A screenshot (image) of the results for the performed operations - bottom of the screen
Two screenshots with the generated tables by the above commands, included in the order of the commands - middle of the screen in different tabs
Task 5 - Query the data
Continue writing the SQL script in MySQL Workbench, adding the following operations:
Include a comment: Task 5 - Query the data by ... (your name)
Perform the 2 queries from your specification.
Execute and debug the script in MySQL Workbench until runs without error and performs the above operations.
Include in the report file the following:
A heading: Task 5 - Query the data
A screenshot (image) of the source code for this task only (crop the image if necessary) - top of the screen
A screenshot (image) of the results for the performed operations - bottom of the screen
Two screenshots with the generated tables by the above commands, included in the order of the commands - middle of the screen in different tabs
s
What to submit
You must submit the following files:
A PDF file containing the report for your assignment.
A MWB file containing the database model done in MySQL Workbench
A SQL text file containing the script to create and query the database for your assignment.
Submission instructions:
You must use assignment submission item on Blackboard to submit your assignment.
You must name the files:
S1_A1_lastname_firstname.pdf - for the report
S1_A1_lastname_firstname.mwb - for the source MySQL Workbench of your ERD
S1_A1_lastname_firstname.sql - for the script
You must not have the files open in a program when you submit them, because they might not be submitted correctly.
Double check the files before submission. You are not allowed to resubmit your assignment. Do not ask for resubmission because cannot be granted. Allowing one student to resubmit will imply to allow all the students to resubmit from all the sections (in order to be fair). This cannot be handled.
S3 SQL Implementation Assignment
Top of Form
Test InformationDescription Instructions This assignment teaches you how to implement a small database and ask simple queries, starting with a specification.
General Instructions
You will receive a unique random database specification. You must follow these instructions for your received database specification.
You must perform the following tasks. The provided specification is different for each student. You must create the ERD the design and implement the database for the specification you received.
This is a CLOSED BOOK assignment, and you are not allowed to use any external information to solve it. Be sure that you use the URL that was assigned to you. Solving a different version of the assignment will result in a grade of zero for this assignment and may result in honor committee referral.
ZERO GRADE:
You will receive a grade of zero in ANY of the following situations:
Not following the instructions from this semester (e.g. following instructions aspects from previous semesters, e.g. the format of your report)
Not following your specifications (2-3 elements in your design are not based on this semester requirements but they follow previous semesters requirements or other versions of questions from this semester)
Not submitting the files in the correct place (each file must be submitted to the corresponding question)
Your ERD screenshot(s) are not signed, or are not signed correctly (a textbox added in MySQL Workbench with your name)
The names of your entity do not follow the name prefix/suffix rule described below.
The names of your attributes do not follow the name prefix/suffix rule described below.
The code has very similar parts with another student's submission.
Database Model Conventions
You must follow these conventions when you perform your homework. Failing to follow the conventions will be penalized per each mistake and may also constitute evidence of cheating.
Entity names: singular nouns (or noun phrase) written in CAPITAL LETTERS, using _ instead of space, must end with a two letter sufix with your first name and last name initials (e.g. if your name is John Doe, an entity name will be PERSON_JD)
Attribute names: singular nouns (or noun phrase) written in CAPITAL LETTERS, using _ instead of space, must end with a two-letter sufix with your first name and last name initials (e.g. if your name is John Doe, an attribute name will be FIRST_NAME_JD)
Relationship names: third person verbs (or verb phrase) written in lower case letters, using spaces. Do not use "has" or other generic names. Use a name that clarifies the meaning (even if contains entity names)
Additional conventions might be specified by your instructor (e.g. prefix the attribute names with the entity name or abbreviation)
Your report must contain the following:
Assignment:S3
Name:YOUR NAME
Section:YOUR COURSE AND SECTION
Task 1 - ERD Model
Based on the specification received create a ERD in MySQL Workbench.
Sign the ERD by writing your name in a text object.
Take a picture of your ERD.
Include in the report file the following:
A heading: Task 1 - ERD Model
The signed screenshot (image) of the ERD
Task 2 - Create database
Start writing the SQL script in MySQL Workbench to perform the following operations:
Include a comment: Task 2 Create database by ... (your name)
If there is a database with the provided name, delete that database.
Add a database with that name.
Mark the created database as the default database for the following operations.
Show all the databases, find the created one in the list
Execute and debug the script in MySQL Workbench until runs without error and performs the above operations.
Include in the report file the following:
A heading: Task 2 - Create database
A screenshot (image) of the source code for this task only (crop the image if necessary) - top of the screen
A screenshot (image) of the results for the performed operations - bottom of the screen
Task 3 - Create tables
Continue writing the SQL script in MySQL Workbench, adding the following operations:
Include a comment: Task 3 - Create tables by ... (your name)
List all the tables in the database (no table expected).
Create the tables with the required specification.
List all the tables in the database (again - the new table must appear).
Show the structure of the created tables.
Execute and debug the script in MySQL Workbench until runs without error and performs the above operations.
Include in the report file the following:
A heading: Task 3 - Create tables
A screenshot (image) of the source code for this task only (crop the image if necessary) - top of the screen
A screenshot (image) of the results for the performed operations - bottom of the screen
Screenshots with the generated tables by the above commands, included in the order of the commands- middle of the screen in different tabs
Task 4 - Add data
Continue writing the SQL script in MySQL Workbench, adding the following operations:
Include a comment: Task 4 - Add data by ... (your name)
Show all the data in your tables (no data expected).
Add at least 5 rows of data in each of the tables, start with the provided data items in the order they are provided, and imagine new data for the other ones. Be sure you follow the constraints in your problem.
Show all the data in your tables (at least five rows expected in each table).
Execute and debug the script in MySQL Workbench until runs without error and performs the above operations.
Include in the report file the following:
A heading: Task 4 - Add data
A screenshot (image) of the source code for this task only (crop the image if necessary) - top of the screen
A screenshot (image) of the results for the performed operations - bottom of the screen
Screenshots with the generated tables by the above commands, included in the order of the commands - middle of the screen in different tabs
Task 5 - Query the data
Continue writing the SQL script in MySQL Workbench, adding the following operations:
Include a comment: Task 5 - Query the data by ... (your name)
Perform the queries from your specification.
Execute and debug the script in MySQL Workbench until runs without error and performs the above operations.
Include in the report file the following:
A heading: Task 5 - Query the data
A screenshot (image) of the source code for this task only (crop the image if necessary) - top of the screen
A screenshot (image) of the results for the performed operations - bottom of the screen
Screenshots with the generated tables by the above commands, included in the order of the commands - middle of the screen in different tabs
What to submit
You must submit the following files:
A PDF file containing the report for your assignment.
A MWB file containing the database model done in MySQL Workbench
A SQL text file containing the script to create and query the database for your assignment.
Submission instructions:
You must use assignment submission item on Blackboard to submit your assignment.
You must name the files:
S3_A1_lastname_firstname.pdf - for the report
S3_A1_lastname_firstname.mwb - for the source MySQL Workbench of your ERD
S3_A1_lastname_firstname.sql - for the script
You must not have the files open in a program when you submit them, because they might not be submitted correctly.
Double check the files before submission. You are not allowed to resubmit your assignment. Do not ask for resubmission because cannot be granted. Allowing one student to resubmit will imply to allow all the students to resubmit from all the sections (in order to be fair). This cannot be handled.
Multiple Attempts Not allowed. This test can only be taken once.
Force Completion This test can be saved and resumed later.
Your answers are saved automatically.
Question Completion Status:
QUESTION 1
Requirements Specification (this is a fictional scenario)
A young soccer league wants to manage its registrations.
The league function based on seasons, like FALL 2020. For each season there is a registration starting date and ending date and also a season starting date and ending date. The league may want to compare FALL seasons in different years. The seasons are FALL, SPRING, WINTER and SUMMER.
In each season, the league has several divisions organized based on age (e.g. U14), players sex (e.g. boys, girls) and rank (e.g. 1, 2). For a division we will keep a unique contact email (of maximum 35 characters) and phone (with the format (999) 9999999) for the teams to report results.
The league has many clubs. For a club we will keep the name of the club (e.g. Patriots) (of maximum 24 characters), a contact email (of maximum 35 characters) and a phone number (with the format (999) 9999999). All clubs have an abbreviation of maximum 5 characters. Clubs have distinct abbreviations.
A club has many teams, and a team belongs to a single club. Teams are organized based on players birth year (e.g. 2007) and players sex (e.g. boys, girls) and they have a unique name within the club (e.g. BLUE) of maximum 20 characters. All teams have an email and phone contact stored in a similar way with the club contact information.
Each season (e.g. FALL 2020 or SPRING 2019), a registered team is assigned to a given division, that may change in rank based on the results obtained in the previous season. The league wants to keep the history of the membership (registration) over time.
When a new season is created, there are no divisions. Then the divisions in the season are created. After that the teams are registered in the corresponding division. When a new club is added there are no teams. Then the teams are added one by one. Your design must support this iterative process.
Data Constraints for Task 4
The fourth season defined is Winter 2019. For the fourth and fifth seasons defined have at least two divisions in each, and each having teams registered in them. Have a season with no division defined. Have at least two divisions under 11 or older and two younger.
The fourth club is named "Lions". For the fourth and fifth clubs defined have at least two teams in each. Have a club with no teams defined.
For the fourth and fifth divisions defined have at least two teams in each. Have a division with no teams registered.
The fourth team defined is named "Violet". The fourth and fifth teams defined are registered to at least two divisions each. There is a team not registered to any division.
Database Questions for Task 5
List alphabetically all the names (with the header name) and the sex of the players (with the header player) for the teams that are enrolled in the "Winter 2019" season (you do not know the ID).
List all the divisions with the season and season ending date (using headers without initials), ordered by season, in which the teams named "Violet" played.
For the club named Lions, list all the teams (names) and their divisions (age, players, rank) in Winter 2019.
For all the divisions in Winter 2019 that are under 10 or younger, list the teams names, clubs names and the year of birth for the players using nice headers.
Attach the PDF report as the answer to this question.
Attach File
0.6 points
QUESTION 2
Include the design file (MWB) here.
Attach File
0.2 points
QUESTION 3
Include the SQL script file as the answer to this question (graded for consistency and execution)
Attach File
Bottom of Form
S5 SQL Implementation Assignment
Top of Form
Test InformationDescription Instructions This assignment teaches you how to implement a more complex database and ask queries containing groups, starting with a specification.
You must continue the database received in S3 and S4.
General Instructions
You will receive a unique random database specification. You must follow these instructions for your received database specification.
You must perform the following tasks. The provided specification is different for each student. You must create the ERD the design and implement the database for the specification you received.
This is a CLOSED BOOK assignment, and you are not allowed to use any external information to solve it. Be sure that you use the URL that was assigned to you. Solving a different version of the assignment will result in a grade of zero for this assignment and may result in honor committee referral.
Database Model Conventions
You must follow these conventions when you perform your homework. Failing to follow the conventions will be penalized per each mistake and may also constitute evidence of cheating.
Entity names: singular nouns (or noun phrase) written in CAPITAL LETTERS, using _ instead of space, must start with a two letter sufix with your first name and last name initials (e.g. if your name is John Doe, an entity name will be PERSON_JD)
Attribute names: singular nouns (or noun phrase) written in CAPITAL LETTERS, using _ instead of space, must start with a two-letter sufix with your first name and last name initials (e.g. if your name is John Doe, an attribute name will be FIRST_NAME_JD)
Relationship names: third person verbs (or verb phrase) written in lower case letters, using spaces. Do not use "has" or other generic names. Use a name that clarifies the meaning (even if contains entity names)
Additional conventions might be specified by your instructor (e.g. prefix the attribute names with the entity name or abbreviation)
Your report must contain the following:
Assignment:S5
Name:YOUR NAME
Section:YOUR COURSE AND SECTION
Task 1 - ERD Model
Based on the specification received improve the ERD from S3 and S4 in MySQL Workbench.
Sign the ERD by writing your name in a text object.
Take a picture of your ERD.
Include in the report file the following:
A heading: Task 1 - ERD Model
The signed screenshot (image) of the ERD
Task 2 - Create database
Start writing the SQL script in MySQL Workbench to perform the following operations:
Include a comment: Task 2 Create database by ... (your name)
If there is a database with the provided name, delete that database.
Add a database with that name.
Mark the created database as the default database for the following operations.
Show all the databases, find the created one in the list
Execute and debug the script in MySQL Workbench until runs without error and performs the above operations.
Include in the report file the following:
A heading: Task 2 - Create database
A screenshot (image) of the source code for this task only (crop the image if necessary) - top of the screen
A screenshot (image) of the results for the performed operations - bottom of the screen
Task 3 - Create tables
Continue writing the SQL script in MySQL Workbench, adding the following operations:
Include a comment: Task 3 - Create tables by ... (your name)
List all the tables in the database (no table expected).
Create the tables with the required specification. Add to the tables in S3 and S4 any new table required by S5
List all the tables in the database (again - the new table must appear).
Show the structure of the created tables.
Execute and debug the script in MySQL Workbench until runs without error and performs the above operations.
Include in the report file the following:
A heading: Task 3 - Create tables
A screenshot (image) of the source code for this task only (crop the image if necessary) - top of the screen
A screenshot (image) of the results for the performed operations - bottom of the screen - for tables in S5 only.
Screenshots with the generated tables by the above commands, included in the order of the commands- middle of the screen in different tabs - for S4 only.
Task 4 - Add data
Continue writing the SQL script in MySQL Workbench, adding the following operations:
Include a comment: Task 4 - Add data by ... (your name)
Show all the data in your tables (no data expected).
Add at least 5 rows of data in each of the tables, start with the provided data items in the order they are provided, and imagine new data for the other ones. Add to the data for S3 and S4 tables from the previous submisssion, data for S5 tables.
Show all the data in your table (at least five rows expected in each table).
Execute and debug the script in MySQL Workbench until runs without error and performs the above operations.
Include in the report file the following:
A heading: Task 4 - Add data
A screenshot (image) of the source code for this task only (crop the image if necessary) - top of the screen
A screenshot (image) of the results for the performed operations - bottom of the screen - only for S4 tables
Screenshots with the generated tables by the above commands, included in the order of the commands - middle of the screen in different tabs - only for S4 tables
Task 5 - Query the data
Continue writing the SQL script in MySQL Workbench, adding the following operations:
Include a comment: Task 5 - Query the data by ... (your name)
Perform the queries from your S5 specification. Do not include the queries for S3 and S4.
Execute and debug the script in MySQL Workbench until runs without error and performs the above operations.
Include in the report file the following:
A heading: Task 5 - Query the data
A screenshot (image) of the source code for this task only (crop the image if necessary) - top of the screen
A screenshot (image) of the results for the performed operations - bottom of the screen
Screenshots with the generated tables by the above commands, included in the order of the commands - middle of the screen in different tabs
What to submit
You must submit the following files:
A PDF file containing the report for your assignment.
A MWB file containing the database model done in MySQL Workbench
A SQL text file containing the script to create and query the database for your assignment.
Submission instructions:
You must use assignment submission item on Blackboard to submit your assignment.
You must name the files:
S5_A1_lastname_firstname.pdf - for the report
S5_A1_lastname_firstname.mwb - for the source MySQL Workbench of your ERD
S5_A1_lastname_firstname.sql - for the script
You must not have the files open in a program when you submit them, because they might not be submitted correctly.
Double check the files before submission. You are not allowed to resubmit your assignment. Do not ask for resubmission because cannot be granted. Allowing one student to resubmit will imply to allow all the students to resubmit from all the sections (in order to be fair). This cannot be handled.
ZERO GRADE:
You will receive a grade of zero in ANY of the following situations:
The report was done based on instructions from a previous semester.
Your ERD screenshot(s) are not signed, or are not signed correctly (a textbox added in MySQL Workbench with your name)
The names of your entity do not follow the name prefix/suffix rule described below.
The names of your attributes do not follow the name prefix/suffix rule described below.
The code has very similar parts with another student's submission.
You are not continuing your S3 homework but a diferent specification.
Multiple Attempts Not allowed. This test can only be taken once.
Force Completion This test can be saved and resumed later.
Your answers are saved automatically.
Question Completion Status:
QUESTION 1
Requirements Specification (this is a fictional scenario)
Continue your S3 and S4 assignment for a young soccer league with the following specification. Do not include the previous queries from Task 5.
A team will play some of the other teams in the same division once per season. For a scheduled game we will keep a unique 8-digit number, the date, time and zipcode-5.
Database Questions for Step 4
Define a current season with the same year as the current year and the same semester as the current semester (fall, spring, summer).
Be sure you have at least 2 divisions in the current season, they must have at least 3 teams each, and they must play one game to each other in the current season.
Database Questions for Step 5
For each zipcode (in ascending order) compute the number of games.
For each club (in alphabetic order) compute the total number of players.
For each division in the current season compute the total number of players.
For each coach (in alphabetic order) compute the total numbers of teams.
Attach the PDF report as the answer to this question.
Attach File
0.6 points
QUESTION 2
Include the design file (MWB) here.
Attach File
0.2 points
QUESTION 3
Include the SQL script file as the answer to this question (graded for consistency and execution)
Attach File
0.2 points
Bottom of Form
