BI商业智能>> IDS-proj>> 返回
项目作者： JiriFurda

项目描述 ：
[IDS] Pharmacy Database
高级语言： PLSQL
项目地址: git://github.com/JiriFurda/IDS-proj.git
创建时间： 2018-04-01T16:48:36Z
项目社区：https://github.com/JiriFurda/IDS-proj
开源协议：
下载


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.