hi, i want to ask for little help in doing the database in unix. the database is very large file that can store ,edit the data. can you give me the solution for this matter? anyway here is the questions for UNIX database As a system administrator, you are keen to develop a database of all equipment/software available in your installation. For each equipment/software, you have decided to store the following information: • Equipment/Software Number (Unique number, system-generated) • Category (Hardware/Software) • Type (Computer, Terminal, Disk Drive, Printer, Modem, Hub, Router, Application software, System Software, Compiler, Interpreter etc etc) • Brand • Model (or version in the case of software) • Serial Number • Date Commissioned (Date, Month, Year) • Status (In operation/Installed, Under repair, In storage, Decommissioned, Upgraded) • Vendor Name • Support Telephone N • Warranty/Support lapse date (Date, Month, Year) Your task is to develop a complete application in UNIX which will enable you to maintain a database of the above information. This application should provide the following functions: Add New Equipment/Software Search based on Serial Number or Type (in which case a list of equipment/software matching the type will be produced) Provide a report listing details of equipment under repair Update Equipment/Software details Delete Equipment/Software Details

Is your teacher asking about an SQL rdbms ? Or is this a text file. Hash tables are common but only support a key-value pair.

no, my teacher asked me to do it with sql, but rather store it in the file,large file like in /etc/passwd. something like that. and i think the field separator is : thanks