This was i guess the prompt for this competition i am entering, but i have no idea how to do this...What program should i use, where can i get more info on it? are there any tutorials?
Here it is:
Your school has a lending library with resources to
assist students with preparing for student organization competitive events and career related projects. You
have been contacted to create an application that keeps
track of the items in the lending library. Types of
items in the library include, but are not limited to,
books, magazines, DVDs, and CDs.
For this program you will create four comma separated
data files as described below. You must save your data
files as text (*.txt) files. You will need to choose appropriate data types to store and manipulate your data
while running the program.
DATA FILES
You must be able to differentiate between different
types of items. To help with this, you will create a
data file called TYPES that contains one record for
each type of item in the lending library. This data file
should contain two fields as follows:
• unique code for the type of item (abbreviation)
• description of type
It is necessary to keep track of all the items you have in the lending library;
therefore, you will need to create a data file called LIBRARY that contains one
record for each item in the lending library. This data file should contain five fields
as follows:
• unique number for each item in the lending library (can be an auto number)
• type of item (must match a code from the TYPES data file)
• title of the item
• author/singer/publisher (author(s) or singer(s) where available otherwise
publisher in the case of magazines, movies, etc.)
• published date (month/year)
In order to determine who is borrowing items from the lending library, you will
create another data file called PATRONS. The PATRONS data file will keep
track of all people who can potentially borrow items from the lending library and
will contain one record for each person. This data file should contain nine fields as
follows:
• unique number for each patron (can be an auto number or a user name type
entry)
• first name, last name, e-mail address, phone number, street address, city, state,
and zip code
Finally, you must keep track of the items that have been borrowed from the lending
library. You will create a data file that tracks these items called ITEMS_OUT
with a record for each item borrowed containing four fields as follows.
• item number (populated from the LIBRARY data file)
• patron number (populated from the PATRONS data file)
• date checked out
• date due (two weeks after check out date)
