Develop an initial schema for your product. Read Basics of good database design in Web Development. You might google around for other sources if you like. You need to think clearly about the functionality that your system will support. You also need to think carefully about relationships.
For example, let’s say I have a Student entity and I have a Course entity. Is there exactly one student for every course (1 to 1). Are there many students for any one course (many to 1) or perhaps does one student have many courses (1 to many), or maybe even a combination - one student can have many courses, and one course can have many students - (many to many). Don’t even start worrying about designing your database until you have questions like that clear in your mind!
Using all that background, develop initial schema for your product. Each team member work separately so you can then compare and contrast what you came up with. So this is an individual assignment! Include table names, field or attribute names, and relations or joins. Please use this exact format: Simple Schema Notation Deliverable: Initial schema for your product. As a pdf file generated any way you want. Use the required format!! Include your name and hw number!
Project teams: Even though there are no specific deliverables, you should be working on steps GIT, DOCUMENTATION, PLANSKEL, BUILDSKEL, SHEMASKEL, SCHEMASDV from Project Roadmap. Not just during lab and during your meetings, but on your own. Remember with a team of four (or 3 or 5) students, that’s a lot of horsepower, and so we have high expectations. The sooner you kick into gear the better!