dbgrigsby / mos-eisley-cantina

Mos Eisley Cantina Restaurant Website

Hi there 👋

• 🔭 I’m currently working at Yelp,
• 💬 Ask me about Jenkins, Kubernetes, GitHub, Vim and Developer Productivity
• 📫 How to reach me: Send me an invite request on Linkedin
• 😄 Pronouns: He/Him
• ⚡ Fun fact: GitHub Profile pages are a thing

mos-eisley-cantina's Issues

Slides

Our slides to present are due in under 3 weeks. (April 24). We need to choose what to have on them and put it together.

Input sanitization for queries on website

Should be implemented in server.jsp, but dropdown boxes in index.jsp will solve some of the problems and make queries easier for users.

Combine query files and verify foreign key constraints

Mostly copy pasting, but having it all in one SQL file will verify everything meshes together.

Normalize database

We should determine if we can manage 3NF or BCNF, to prevent update anomalies and the like.

Documentation PDF

Required by instructions PDF:

• a. Application background,
• b. Data description, including all constraints that need to be enforced,
• c. An (updated) ER diagram design of your database,
• d. A list of functional dependencies derived from the semantics of your data, 
• e. The schema of your database, satisfying 3NF (if not BCNF),
• f. Example queries supported by your system,
• g. Implementation: OS, DBMS, programming language,
• h. The role and contributions of each team member (make sure that the contributions of each
• team member is doable without the implementation contributions of other members),
• i. A short presentation/demo in the last a few classes,
• j. What you have learned from this project—over and above from what is covered in the course.