You are here: HomeDiscussionsBulletin[ARTICLE RELEASE] Series 2 : Part 2 - A Practical Database Implementation of a Things To Do List

ReconTech's Discussion Section

You can ask questions, discuss articles, post snippets of code in this section.

0
Abstract

In this part of the series the two entities and their attributes, from the E-R Diagram developed in the previous part of the series, are used to define two database tables. Each tables, the things to do and note tables, are then created in the database by executing MYSQL statements from a file. Then finally, after each table is populated with data from a text file, a method of creating a composite key from the two table's primary keys, is used to create the relationship between the things to do and notes tables.
Responses (2)
  • Accepted Answer

    Saturday, June 01 2013, 08:45 PM - #permalink
    0
    Just released at set of examples:

    Series 2 : Example 01

    So far in the series it has been demonstrated how to create a database table, ttd, a list of things to do and a notes table, used to store comments on things to do. To cement the ideas learnt the examples that follow will demonstrate:

    The loading of table data into a database.
    Query the database to do the following:
    List all the data in the things to do, ttd, table showing each items id, description and urgency.
    List all items in the ttd table by their description and urgency.
    List all items in the ttd table with a high urgency by their description and urgency .
    List all items with a high urgency and the words 'ARTICLE' in the description by their description and urgency.
    The reply is currently minimized Show
  • Accepted Answer

    Wednesday, June 05 2013, 09:55 AM - #permalink
    0
    Finally, created a download area but have not yet added the code from the article for download. :D
    The reply is currently minimized Show
Your Reply