Computers and Technology, 30.03.2021 16:00 only1123

1. Your case is on the US Long-Distance Running Association. A competitive long-distance runner may run many races during the year. Each race has multiple runners and is identified by the combination of a name (ex: Peach tree Road Race), a length (ex: 5km, 10km, 21km, 42km), and a date. For each race that occurs, there is a need to capture the time and position of all of the runners. A runner may only be part of one running club. Whereas each runner is permanently identified by a unique number provided by the ALDRA, a club is identified by a name (ex: The Atlanta Track Club), and has a phone number and a date of foundation.
Create the ERD for the case above using MySQL workbench. YOu must include all entities, attributes, data types and relationships. The relationships must be expressed in crows feet notation (at least for maximum cardinality). Once you have completed the ERD save your workbench project file (mwb file ONLY) and upload it to the D2L midterm exam (part 2) as an attachment.
2. For the US Long-Distance Running Association case above, you must generate the DDL file. This file must contain create table statements for all of the tables in your ERD. It should include all columns, data types, nullable constraints, primary key and foreign key constraints. YOu can use MySQL workbench in forward engineering mode to generate these scripts, or you will have to create the DDL commands and save them in a text file. When you have completed the DDL and saved the file.
3. For the US Long-Distance Running Association case above, you must generate the DML file. This file must contain 3 INSERT statements for each of the entity/tables found in your ERD. If you used the forward engineering mode of MySQL workbench, you should have all of the tables located in your MySQL database. If so, you can enter the 3 rows in the database editor and save them. After savintg, export the 3 INSERT statements to a DML file. You must repeat this process for all of your tables - consolidating them into a single DML file. If you did not use forward engineering, you will have to type in the 3 INSERT statements for each table into a text file. When you have completed the DML and saved the file.

Answers: 2

Show answers

Other questions on the subject: Computers and Technology

Computers and Technology, 22.06.2019 07:50, OnlyaBurden

In this lab, you complete a prewritten c++ program for a carpenter who creates personalized house signs. the program is supposed to compute the price of any sign a customer orders, based on the following facts: the charge for all signs is a minimum of $35.00. the first five letters or numbers are included in the minimum charge; there is a $4 charge for each additional character. if the sign is made of oak, add $20.00. no charge is added for pine. black or white characters are included in the minimum charge; there is an additional $15 charge for gold-leaf lettering. instructions ensure the file named housesign. cppis open in the code editor. you need to declare variables for the following, and initialize them where specified: a variable for the cost of the sign initialized to 0.00 (charge). a variable for the number of characters initialized to 8 (numchars). a variable for the color of the characters initialized to "gold" (color). a variable for the wood type initialized to "oak" (woodtype). write the rest of the program using assignment statements and ifstatements as appropriate. the output statements are written for you. execute the program by clicking the run button. your output should be: the charge for this sign is $82. this is the code, // housesign. cpp - this program calculates prices for custom made signs. #include #include using namespace std; int main() { // this is the work done in the housekeeping() function // declare and initialize variables here // charge for this sign // color of characters in sign // number of characters in sign // type of wood // this is the work done in the detailloop() function // write assignment and if statements here // this is the work done in the endofjob() function // output charge for this sign cout < < "the charge for this sign is $" < < charge < < endl; return(0); }

Answers: 1

continue

Computers and Technology, 22.06.2019 13:00, Cookie320

Write a program which asks you to enter a name in the form of first middle initial last. so you might enter for example samuel p. clemens. use getline to read in the string because it contains spaces. also, apparently the shift key on your keyboard doesn’t work, because you enter it all lower case. pass the string to a function which uses .find to locate the letters which need to be upper case and use toupper to convert those characters to uppercase. the revised string should then be returned to main in the form last, first mi where it will be displayed.

Answers: 1

continue

Computers and Technology, 23.06.2019 16:30, rileysndr1782

Monica and her team have implemented is successfully in an organization. what factor leads to successful is implementation? good between different departments in an organization leads to successful is implementation.

Answers: 1

continue

Computers and Technology, 23.06.2019 20:30, kaylee2828

Column a of irma’s spreadsheet contains titles for each row, but her document is too big and will be printed three pages across. she wants to be sure that every page will be understood. what can irma do to with this problem?

Answers: 3

continue

You know the right answer?

1. Your case is on the US Long-Distance Running Association. A competitive long-distance runner may...