The writer is very fast, professional and responded to the review request fast also. Thank you.
Presentation/PPT
27/08/2022
Assignment #1 Creating a Database
Purpose: To demonstrate the ability to define and propose a database design.
Problem:
CSUF offers students the opportunity to participate in intramural sports. Although the university participates competitively in various sports, hundreds of students are part of an intramural team(s). Since the intramural sports are separate from the collegiate competitive sports, the Intramural Department wishes to maintain and manage their activities effectively and efficiently. As part of the program, various sports including basketball, softball, tennis, football, soccer, swimming and others are offered. Students are allowed to play more than one sport during their time at CSUF. Each sport has its coordinator that is in charge of scheduling game times, location/field, and referees. The department will assign players to teams and assign a coach. Coaches are usually university and community members that volunteer their time. The department also offers sports equipment that teams can check out and use for practices and games. It is important for the department to have all of its equipment accounted for prior to and following each scheduled game.The Intramural Department is responsible for documenting which sports were offered, details of teams and their participants, coaches information, and sports schedules for each semester. Because you are a student assistant working for the department and has demonstrated a level of understanding of databases, you have been asked to propose a new database that will manage the departmental activities and produce the required reports.
Instructions:
Create the necessary tables and define the database structure. Using any application (e.g., word processor or spreadsheet application), identify and “sketch” the tablesthat will be needed for this case. Create the tables with appropriate fields and “list” five sample recordsor dummy records. *Note: Don’t forget to include a primary key in each table. Provide a brief description that explains the table’s theme. The description can be done in one sentenceor two. Place the description above each table. Create a model using any drawing tools/applications that illustrate the proposed database design. Drawlines representing the connection between the tables in the database. Identify at least two reports the database should be able to produce. Provide sample reports for eachscenario with dummy data. Create a document that merges all of the above into one file. Convert into a pdf file and submit thecomplete plan.*Special Note: A minimum of four tables needs to be considered, but there is a potential of 6-7 tables for this database design.
Show more
The writer is very fast, professional and responded to the review request fast also. Thank you.
Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.
You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.
Read moreEach paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.
Read moreThanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.
Read moreYour email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.
Read moreBy sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.
Read more