Describing a solution for Employee database?
I have to describe a solution for Employee database. Here is the assignment:
A large production company wants you to design and implement employee database that consists of two sections: one section that everybody has access to and a section that only HR department and the CEO can see. First section consists of data like name, title, phone number ect. The other section consists of data concerning what education, courses tests ect. that each employee has taken, that is when it was taken, when it must be re-evaluated, if more education is needed for the employee to conduct his or hers job better.
Explain how you want to develop such system using documentation like E/R diagrams, development methods, Visual Vocabulary, paper prototypes etc. And show sample code that describes a solution for a paper of the system.
If any of you have any advice, links to tutorials or something relevant just post it i would be really thankful!
- 1 decade agoFavorite Answer
This is something you have to do on your own, Here are some references that will help/guide you in making right decisions.
SRS how to make a srs :
Case Study of an Employee Database :
You can also search for many case studies on your choice of search engine.
Complete SDLC process dcoumentation (beginner's)
An example ER model :
Things you should keep in mind while designing database :
Anything else you may need reach out to me via e-mail.Source(s): Google & past experience.
- 4 years ago
Is this your homework? Doing your homework for you would waste your time and money. Start by underlining the entities in the paragraph. Then put them together in a way that shows the relationships (one to one, one to many etc). Finally add the attributes. The database will then become very obvious, rather elegant and already in third normal.