Commit Graph

185 Commits

Author SHA1 Message Date
Andreas Zweili d5118e3f6b some changes to the use case table 2017-07-20 17:08:17 +02:00
Andreas Zweili ad34e2baeb change the Stundenplanung to a long table 2017-07-20 17:05:09 +02:00
Andreas Zweili ca21f78f1a adjust the width of the columns in the use case table 2017-07-20 15:21:47 +02:00
Andreas Zweili 1b7884483d continue working on the documentation
Things I've added are:

- a table template for use cases
- a new package tabularx to let a table use the whole width of a page
- Must and Wish targets
- Corrected the option of the test case table
2017-07-18 22:26:03 +02:00
Ismail 9ae88c4e52 add a insert function which puts a person into the database with a GUI 2017-07-18 21:01:55 +02:00
Andreas Zweili b804d6acdb extend the content 2017-07-17 23:09:54 +02:00
Andreas Zweili d207c92159 add missing attributes 2017-07-17 23:09:39 +02:00
Andreas Zweili 8201eab0c3 add some chances 2017-07-17 22:00:09 +02:00
Andreas Zweili afea7c7dce remove cache file 2017-07-17 21:42:28 +02:00
Andreas Zweili 622cdbfd50 update gitignore with all the visual studio stuff 2017-07-17 21:38:13 +02:00
Andreas Zweili 068868aa47 update gitignore 2017-07-17 21:36:54 +02:00
Andreas Zweili 2189f03a3c remove binary files 2017-07-17 21:36:11 +02:00
Andreas Zweili 2b82521431 add generic sql connection 2017-07-16 13:02:29 +02:00
Andreas Zweili eeac347ee1 update project file 2017-07-16 12:28:20 +02:00
Andreas Zweili 8f3809b591 add a main routine 2017-07-16 12:22:30 +02:00
Andreas Zweili 75b4627eb3 add exe files to the ignore list 2017-07-15 20:16:40 +02:00
Andreas Zweili 8fd60829d9 close visual studio 2017-07-15 20:16:17 +02:00
Andreas Zweili 4f5a855800 close visual studio 2017-07-15 20:15:57 +02:00
Andreas Zweili 6476f32896 extend ignore list 2017-07-15 20:15:06 +02:00
Andreas Zweili be88cfafe1 rename directory 2017-07-15 20:13:05 +02:00
Andreas Zweili 444c988105 rename directory 2017-07-15 20:12:14 +02:00
ismail 1f8ea757c8 second version of the application , to read data out of the database 2017-07-12 23:14:39 +02:00
Andreas Zweili ede47123cd add changes after saving the sql studio 2017-07-09 20:00:24 +02:00
Andreas Zweili 245c555878 add various test data to all tables 2017-07-09 19:48:26 +02:00
Andreas Zweili 0308f06dae remove unnecessary code
To remove the database it's not needed to remove all tables beforehand.
2017-07-09 19:01:18 +02:00
Andreas Zweili 0b33cd0c09 add code to insert all swiss cities 2017-07-09 18:58:42 +02:00
Andreas Zweili 48c795939c add the identity property to all the primary keys 2017-07-09 18:57:47 +02:00
Andreas Zweili 7db40baaaa add a missing comma 2017-07-09 18:39:26 +02:00
Andreas Zweili e058e9ab17 fix various minor things 2017-07-06 13:18:35 +02:00
Andreas Zweili 68d9aff0d0 move email address to the members table 2017-07-03 21:47:34 +02:00
Andreas Zweili 596deb2803 move email address to member
This is necessary to have a way for identifying a member without
a relation ship to a person (e.g. a test user)
2017-07-03 20:36:37 +02:00
ismail bbaa9d5769 new sections ( c#) in the doku 2017-07-03 19:26:35 +02:00
ismail a5249a0edd merge coding gui DB 2017-07-03 19:08:44 +02:00
Andreas Zweili 7ba52b07ce add all the required constraints
in addition I've fixed some minor bugs.
2017-06-26 21:18:21 +02:00
Andreas Zweili 1d4128e8f9 clean up the removal script 2017-06-26 21:17:54 +02:00
Andreas Zweili 3784d21327 correct some minor mistakes in the erm 2017-06-26 21:17:16 +02:00
Andreas Zweili c347e0d95f closed sql studio 2017-06-24 20:10:22 +02:00
Andreas Zweili 887d168df2 remove unnecessary parentheses 2017-06-24 20:08:30 +02:00
Andreas Zweili 8ab5cd6957 switch the attribute reference and the constrait name
To create a constrait you first define the name and then
link to it's target.
2017-06-24 20:07:23 +02:00
Andreas Zweili 370af5e89b first draft of the create table script 2017-06-24 15:32:42 +02:00
Andreas Zweili a2c1a6b67d add a short paragraph about risks 2017-06-24 13:52:54 +02:00
Andreas Zweili c11d10aebf extend the description of the entities. 2017-06-24 13:47:26 +02:00
Andreas Zweili 3928c4f230 extend the erm
I've added a few more fields to the quality checks and added
a password attribute to the members entity.
2017-06-24 13:46:47 +02:00
Andreas Zweili 9f0d7de589 add data type to the rents entity 2017-06-21 13:41:46 +02:00
Andreas Zweili 2d10526da0 add description about the entities 2017-06-21 13:40:45 +02:00
Andreas Zweili 86a5edc81c Merge branch 'andreas' 2017-06-05 13:21:49 +02:00
Andreas Zweili cd3e9ff0d7 update after closing the project 2017-06-05 13:18:27 +02:00
Andreas Zweili 6242fcf903 Merge branch 'master' of git.2li.ch:ibz/db_AI-4 2017-06-05 13:12:33 +02:00
Andreas Zweili cb75683957 Merge branch 'andreas' of git.2li.ch:ibz/db_AI-4 into andreas 2017-06-05 13:11:59 +02:00
Andreas Zweili 9171086de8 create project for the sql scripts 2017-06-05 13:11:26 +02:00