Table nameĪ positive whole number uniquely identifying this row in the table: 1, 2, etc.Ī string naming the item for sale, e.g., Eggs.Ī string describing the units by which it's priced, e.g., lb. The columns of the tables are structured as follows. In a table, a row comprises one set of related data: one announcement, one item for sale, etc. These tables are similar to spreadsheets, organized in rows and columns. This database must store four tables of data, one for each section. Database schemaĪ database schema defines how the information is structured. To accomplish these goals, the structure of the data must be defined. The "Control Panel" interface is accessible at route /admin, and is intended for administrator use only. Goal 2: The application should provide a browser interface where database entries can be viewed, created, updated, or deleted. The current data is incorporated into the view template and displayed to the user. Goal 1: When the user requests the home page route / from the website, the app should read the current data for these sections from a database. The home page of the website displays four content sections in the main body: Announcements, Items for sale, Upcoming events, and Message of the day.īy adding connectivity to a database, this application seeks to accomplish two related goals.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |