ben_m_gunn
02-20-02, 10:31
| Hi All I am a self confessed newbie and know little of databases. I have read a little on Database design and have had a preliminary play with MySQL. My question is this: Someone asked me about making a database which must support the features I have listed at the end of this post. They also wanted something that was user friendly and easy to access. I wouldn't have the slightest clue on how to begin. I take it that there are two parts to this task. The first would be to select and design a suitable database. The second would be to design a front end application to interact with the database. Given the database requirements what would be the best choice for a front end? I thought using PHP might be good, as the user can access the database from the web. But then I thought "PHP is just a scripting language so it probably would not be good for this kind of DB". Is this assumption correct? What would others recommend as the best Database + Frontend combination? Many thanks, Ben ----------------------- requirements for database: 1/ Input function : add, revise, delete, search by keyword, turn page 2/ Search function : Besides search by key words, search can also be done on multi-conditions, and the number of records conforming to the conditions will be given. The results will be displayed in the way as requested. The data will be classified according to input of multiple subjects and the classified results will be saved in the database. 3/ Output function : What is searched can be saved either on the hard or floppy disk as desired in the form of text, database or HTML. 4/ Print function : print data of selected member(s), print what is searched in the form of list/table. 5/ Import/Export function 6/ Backup function 7/ User friendly |