We are kicking off the Nano Twitter project. You are working on a team. In this initial step we set the stage for the work. There will be a series of assignments like this one that will lead you to the final deliverables.
Each step in this outline has a name which I use to refer to it elsewhere in this course. The work is divided up generally into a series of intermediate deliverables. .
This is all team work. The team members are responsible for dividing up the work, making sure that everyone is included and that everyone has an understanding of what’s in the directory.
Create your PRIVATE nanotwitter
github repo and send the link to Pito and the TAs. Clone it to all team members computers. Create the standard files, license.txt, readme.md, version.rb. Google to find typical contents of those files.
Design relational database schema (i.e. one for the most of the app) after thinking about all the needed functionality, as there is some flexibility. Decide what tables you will have, what the attributes (columns) are for each table, what the primary and foreign keys are, and what the associations are (i.e. one to many, many to one, many to many.) Use this tool: DB Diagram to document your design. It is easy to use, free and helps you think about your DB design.
There are several difficult aspects of this design that you should think about carefully. Especially how you represent Twitter’s following functionality, and commenting and liking.
Submit a link to your design. We will look for correct relationships (1-1, 1-many, many-many), correct use of primary and foreign keys, what twitter functionality this initial schema is supporting and in general how thorough and careful job you do.
Submit a link to your github repo. Make sure you make Pito, Susan and Bishal collaborators on your PRIVATE Github repo.