I need desperate help with this Computer Science Practical,
I have no idea what I'm doing and I am going to fail
any help at all, even just explaining how to do the general idea
would be amazing
Need Help With Computer Science Practical Watch
- Thread Starter
- 22-03-2016 23:45
- 23-03-2016 00:16
Seems like you will need to create a Database containing the information. I would recommend using Python and SQLite to create this as the user would need to be able to easily find Employee data through the use of a search form. I would generate two databases: Employees & QualificationLevel.
The databases would look a little bit like this:
EMPLOYEES (CustomerID, First Name, Last Name, Telephone Number, Qualification)
QUALIFICATIONS (Qualification, QualAbbreviation)
Key: Primary keys underlined, Foreign Keys italicised.
The use of two databses will ensure data integrity within the system. The Employees table will reference back to QualAbbreviation in the Qualifications table to get the full name of the qualification status of a given employee. At this stage, I would then design an algorithm which can auto-generate a CustomerID based on the data entered for the First Name and the Last Name columns.
This is the bulk of the project, assuming you know how to design simple algorithms for buttons which can clarify whether or not the data entered is correct.
Python, thankfully, has a Tkinter module which will allow you to design the GUI for your practical. Python also has built in SQLite modules to allow you to create databases from within the IDE.
If you are stuck, I would recommend consulting your teacher over this as they may help you find a more appropriate solution than the one i've provided above. If you are stuck on anything related to the software engineering aspects of your practical, google searches and websites such as StackOverflow are your best friends when it comes to this, as well as your teacher.
Happy to help!Last edited by Killerpenguin15; 23-03-2016 at 00:17.