Is it possible to have the conceptual schema of your database ? Currently I'am doing a case study for a university in witch I try to evaluate a functional size of a part of Web Time Entry.
Thank you for your help !
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I am not too sure what you are looking for. I really don't have any other documentation on the database schema for this project. Maybe you could look for a tool that will create one for you. I would think that someone would have created something on Sourceforge for printing schema from a MySQL datasource. I am really not sure. What is it that you need to see and what do you mean by "evaluate a functional size of a part of Web Time Entry"?
Thanks for the interest in the project - Hope you get an 'A',
Paul Jones
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Thank you for your response, I'll try to better explain what I'm looking for. The functional size of a program is used to determine the size of the application in term of user's functionalities. So it's not a size like the number of code's lines or perhaps if you know the cyclomatic complexity. The result is used, generally, to determined the efforts needed to build the program or a part of it. You can also make an evaluation after the construction of the application to estimate the cost of the maintenance.
Actually I work on an automatisation of the functional size metric Cosmic-FFP and I choose Web Time Entry for a case studie. But we lack of documentation and particularly the documentation which describe the data. I tried to make a short reverse engineering process on the database's creation code but because MySql doesn't include other constraints that the primary keys, I have some difficulties to determine the relation between the entities (for example : employees, projects, accruals, transactions, invoices,...) represented by the tables and I need to know these relations (especially the foreign keys) and the structure and links between the different concepts of the programm to make a good estimation. That's why I'm asking you a conceptual schema of the concepts, a data-model or something else which can help me.
I hope this help to clarify my problem and thank you for your help.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
At the moment a complete database data-flow showing all foreign keys and table relationships only exists in my head. To create such a document would be a little too much work at this point in time for me (Web Time Entry is not the only project I have on-going). Probably what I could do is take a look at what you have reverse engineered to-date. I can make corrections clarify anything you don’t understand and help with any additions you might need to make. If your documentation is actuate and detailed, I would add it to the project within the documentation area.
Thanks again for the interest in our project.
Paul Jones.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
For the moment, I have a first schema of the database. I can send it to you if you tell me where. I used a special case tool, call DB-Main, to create the schema. Here is the link where you can find it : http://www.db-main.be/doc.php?id=ro12&tid=2&lang=1
The tool is in english and work only with Windows. You can take the education edition, which is free , but the download's page is in french and you have to register first to receive an activation key. If it's a problem for you and if you use another free tool, you can tell me and I'll try to make the translation. Otherwise I can send you a pdf format of the schema but it's not editable.
Thanks
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Is it possible to have the conceptual schema of your database ? Currently I'am doing a case study for a university in witch I try to evaluate a functional size of a part of Web Time Entry.
Thank you for your help !
I am not too sure what you are looking for. I really don't have any other documentation on the database schema for this project. Maybe you could look for a tool that will create one for you. I would think that someone would have created something on Sourceforge for printing schema from a MySQL datasource. I am really not sure. What is it that you need to see and what do you mean by "evaluate a functional size of a part of Web Time Entry"?
Thanks for the interest in the project - Hope you get an 'A',
Paul Jones
Thank you for your response, I'll try to better explain what I'm looking for. The functional size of a program is used to determine the size of the application in term of user's functionalities. So it's not a size like the number of code's lines or perhaps if you know the cyclomatic complexity. The result is used, generally, to determined the efforts needed to build the program or a part of it. You can also make an evaluation after the construction of the application to estimate the cost of the maintenance.
Actually I work on an automatisation of the functional size metric Cosmic-FFP and I choose Web Time Entry for a case studie. But we lack of documentation and particularly the documentation which describe the data. I tried to make a short reverse engineering process on the database's creation code but because MySql doesn't include other constraints that the primary keys, I have some difficulties to determine the relation between the entities (for example : employees, projects, accruals, transactions, invoices,...) represented by the tables and I need to know these relations (especially the foreign keys) and the structure and links between the different concepts of the programm to make a good estimation. That's why I'm asking you a conceptual schema of the concepts, a data-model or something else which can help me.
I hope this help to clarify my problem and thank you for your help.
At the moment a complete database data-flow showing all foreign keys and table relationships only exists in my head. To create such a document would be a little too much work at this point in time for me (Web Time Entry is not the only project I have on-going). Probably what I could do is take a look at what you have reverse engineered to-date. I can make corrections clarify anything you don’t understand and help with any additions you might need to make. If your documentation is actuate and detailed, I would add it to the project within the documentation area.
Thanks again for the interest in our project.
Paul Jones.
For the moment, I have a first schema of the database. I can send it to you if you tell me where. I used a special case tool, call DB-Main, to create the schema. Here is the link where you can find it :
http://www.db-main.be/doc.php?id=ro12&tid=2&lang=1
The tool is in english and work only with Windows. You can take the education edition, which is free , but the download's page is in french and you have to register first to receive an activation key. If it's a problem for you and if you use another free tool, you can tell me and I'll try to make the translation. Otherwise I can send you a pdf format of the schema but it's not editable.
Thanks
Wow - Yup its all in french. How about send me the PDF of what you have...
Jonathan
Took a quick look at your documentation and it looks pretty close to me. You are missing a few relationships:
-AccrualBalance.EmployeeID - many:1 - Employee.EmployeeID
-Earncodes.EarnCode - 1:many - Timenty.EarnCode
-EntCodes.Entcode - 1:many - TimeEntry.Ent
Other than that – I don’t see anything else.
Paul
give the complete uml design for the web time entry projct