Call/WhatsApp/Text: +44 20 3289 5183

Question: Design and Develop the database that will store the topical data (i.e. the 8-track cartridges) and the user accounts and answers.

04 Dec 2022,5:46 AM

1. For an introduction to the project, please see the following presentation.

https://docs.google.com/presentation/d/1t59Kci0Cpt5ldvbaTQPz8DU8tn9D_uhXPHpTtS3zqB0/

2. Project details:

Design and Develop the database that will store the topical data (i.e. the 8-track cartridges) and the user accounts and answers. The new 2XL should allow users to log in and create user accounts, teams, store and compare their scores and even add their own 'topics' to the the database.

Users should be able to create teams to work together, one user can have many teams, and one team can have many users. At the same time, one team can participate in many topics.

You should be able to add new topics and corresponding correct and incorrect answers easily.

The database should be able to keep track of the dates of when users take tests, how long they have been working on questions, and be able to ask for "hints" to questions.

The Mego corporation would like to monetize the system and has asked that you think about and design into the database ways to keep track of accounts in case they begin charging for certain items.

Your (along or with a partner) will be responsible for:

Logical diagram of database;
Creating the database;
Creating a design/wireframe of the interface that will be seen and used by the players (we'll look at wireframing in Lesson 14);
One table should have some sample data to demonstrate how the table works;
A short paper (no more than 2 pages) or presentation describing the project and how the database supports the features of your 2XL application;
You will hand in the following items:

Diagram of Database as a PDF or Image, done in 
https://www.diagrams.net/ or similar software;
"Wireframe" of the web application* (we'll go over this in lesson 13/14).
Exported SQL file (we will cover how you do this in lesson 13/14);
A short paper (no more than 2 pages) or presentation (powerpoint, google slides, Prezi) describing the project and how the database supports the features of your 2XL application;


4. How to submit the final project:

Please read carefully, there are two steps to submit the final project:

Upload the presentation/paper to a forum called "Final Project Submissions" by Dec 14th 11:59 p.m.
Upload all materials to this assignment area. The materials include the presentation/paper, the database diagram, and the exported SQL file.
Be creative - design a 2XL that you're proud of!

Expert answer

 

This Question Hasn’t Been Answered Yet! Do You Want an Accurate, Detailed, and Original Model Answer for This Question?

 

Ask an expert

Stuck Looking For A Model Original Answer To This Or Any Other
Question?


Related Questions

What Clients Say About Us

WhatsApp us