search

lawson2312 / cs425

0 stars 0 forks source link

Create Database #1

Open lawson2312 opened 5 years ago

lawson2312 commented 5 years ago

use H2 as embedded data base https://www.youtube.com/watch?v=UnDd32qRhDI

lawson2312 commented 5 years ago

use H2 as embedded data base https://www.youtube.com/watch?v=UnDd32qRhDI

inside of intelliJ, go to settings, plugins, and search for database navigator and install to add the database to the project

lawson2312 commented 5 years ago

Have the tables created and some dummy data in them, couldnt figure out how to copy it over as as text so i only have the tables as a pdf questionDBdata.pdf

Let me know what you all think about the table and the values

lawson2312 commented 5 years ago

I have the tables created for the login as well, let me know what you guys think of these too loginDBdata.pdf

lawson2312 commented 5 years ago

testing of query statements inside of intellij worked, ran a few of them and they all worked for the dummy data

hcortez1996 commented 5 years ago

I have an outline of the tables for our db. Please take a look. I think your question table and login table need a few more attributes. EER_Bootcamp.pdf bootcamp.txt

lawson2312 commented 5 years ago

databaseCode.txt newly created tables, everything is what we talked about in team meeting yesterday (1/24) the only thing left to do is figure out what the primary and foreign keys are

lawson2312 commented 5 years ago

I have 2 quizzes in the excel sheets and they are in the data base. I ran some queries on the database and they worked out as well. I will put more of the questions in there but i just wanted to put up what i had so far quizQuestions.xlsx

lawson2312 commented 5 years ago

didnt mean to close out the issue

lawson2312 commented 5 years ago

Completed excel sheet with all questions that are being used for bootcamp. The data base is full with all data and i will be running queries on intellij

quizQuestions.xlsx

lawson2312 commented 5 years ago

Completed excel sheet with all questions that are being used for bootcamp. The data base is full with all data and i will be running queries on intellij

quizQuestions.xlsx

Ran some queries and all data was in the database and was able to see all the data for the questions

lawson2312 commented 5 years ago

Also added messages that we can use to put on each quiz for 'great, good, poor, and error' there are 5 messages for each that will all be random as well

messages.xlsx

lawson2312 commented 5 years ago

file for database with all questions added

bootcampDB.txt

lawson2312 commented 5 years ago

bootcampQuestions (2).zip

lawson2312 commented 5 years ago

bootcamp.zip

lawson2312 commented 5 years ago

bootcamp.zip this is the newest version 3/25 9:28