system
... ýmuch user friendly as possible.ý ý2. System Study We can deduce the input files from the data dictionary and data stores ýdone in the previous report.ý • Employee records file • ý Journal Records fileý • Weekly timesheet file • General Accounting file • Daily receipt file • Official holidays file • Statistical data file • Sold item records file • Backup file ý2.1 Employee records file Every employee has a record that describes his identify, performance, and ýposition at work. The following is a detailed description specifying all fields in this ýfile.ý ý1.ý Employee ID ý2.ý Employee name a.ý First name b.ý Middle name c.ý Last name ý3.ý Position ý4.ý Age ý5.ý Date of birth a.ý Year b.ý Month c.ý Day ý6.ý Date of admission a.ý Year b.ý Month c.ý Day ý7.ý Nationality ý8.ý Country ý9.ý city ý10.ý Sex ý11.ý Religion ý12.ý Marital status ý13.ý Home Address ý14.ý Second Address ý15.ý ID or passport number ý16.ý Home number ý17.ý Mobile Number ý18.ý Relative number ý19.ý Insurance type ý20.ý work status ý21.ý salary ý22.ý performance ý23.ý previous experience ý24.ý company name used to work forý ý ý • The primary key to be used is the Employee ID.ý • This file is created for all new employees.ý • This is a master file saved on the local hard disk.ý • To access this file, we need direct access mode.ý ý2.2 Journal Record fileý Every Journal in the Al Nada Journal must have a record that describes ýeverything about the Journal. The following is a detailed description specifying ýall fields in this file.ý ý1.ý ý Journal IDý ý2.ý ý Journal isbn numberý ý3.ý author ý4.ý editor (if any)ý ý5.ý translator (if any)ý ý6.ý publisher ý7.ý date of publication ý8.ý Title ý9.ý sub title ý10.ý edition ý11.ý volume (if any)ý ý12.ý quantity in stock ý13.ý price ý14.ý date received ý15.ý Shelf mark numberý ý16.ý availability ý17.ý category • The primary key to be used is the Journal id.ý • This file is created for all Journals entered into the Al Nada Journal ýstocks.ý • This is a master file saved on the local hard disk.ý • To access this file, we ...