Skip to content

[IDS] Pharmacy Database

Notifications You must be signed in to change notification settings

JiriFurda/IDS-proj

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

25 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

Pharmacy Database (IDS projects)

Bachelor study at FIT VUT Brno
4th semester - summer 2018
Subject: Database Systems (IDS)

Authors

  • Jiří Furda (xfurda00)
  • Peter Havan (xhavan00)

Score

  • Project 1: 5/5
  • Project 2: 4/5
  • Project 3: 2/5
  • Project 4 & 5: 15/19
  • Overall: 26/34

Project 1 details

Original ERD had to make new purchase record for every item even though it was more pieces of the same medication. This small error hasn't affected the score. The ERD in repository is already fixed.

Project 2 details

  • Every table must have primary key (e. g. "hrazeni" or "uskladneni" doesn't have one)
  • Missing data format check (e. g. CHECK) - We thought it's part of project 3

Project 3 details

The project wasn't successfuly uploaded to school system and we found out this fact a week after deadline. Otherwise the project would be rated 5/5.

Project 4 & 5 details

The remaining 4 points could be obtained by doing extra tasks but we decided not to do them.

Releases

No releases published

Packages

No packages published

Languages