Pharmacy. Prices, Prescriptions, Purchases, Discounts. Create a relational database with at least 3 relations, the datab
Posted: Fri May 20, 2022 5:01 pm
Pharmacy. Prices, Prescriptions,
Purchases, Discounts.
Create a relational database with at least 3 relations, the
database should be in BCNF. Add a basic python script that can
populate it (say from a CSV file), query it (e.g. select all
products of certain price), insert / remove records (tuples).
1. Well-documented source
code including all
the modules that you created (.py,
.ipynb, etc.) and a file with your queries to create the tables,
procedures / functions, triggers, etc. (.sql). Commentaries for
every single line are not required, however, I would expect the
following:
a)
Descriptionofthemodule,developers,version,e.g.
"""
Helper functions for creating the logs and tracking game
progress @file filename.py
@author Author A, Author B, Author C
@version 1.01 May, 2021
"""
b)
Explanationsfortheclasses,functions,structures,etc.E.g.
"""
Stores integer coordinates of a point on a 2D plane """
class Coordinates: ...
"""
Returns distance between two points in 2 dimensions
"""
def distance (A, B): ...
c) Other in-place commentaries explaining
details of implementation # Euclidean distance
distance = np.sqrt((x1 - y1)**2 + (x2 - y2, 2)**2)
2. Printscreen images of the running
program. Sometimes there might be problems with different compilers
and different OS understanding the same code differently. A
printscreen images will support the validity of your program and
that it runs in your environment.
Purchases, Discounts.
Create a relational database with at least 3 relations, the
database should be in BCNF. Add a basic python script that can
populate it (say from a CSV file), query it (e.g. select all
products of certain price), insert / remove records (tuples).
1. Well-documented source
code including all
the modules that you created (.py,
.ipynb, etc.) and a file with your queries to create the tables,
procedures / functions, triggers, etc. (.sql). Commentaries for
every single line are not required, however, I would expect the
following:
a)
Descriptionofthemodule,developers,version,e.g.
"""
Helper functions for creating the logs and tracking game
progress @file filename.py
@author Author A, Author B, Author C
@version 1.01 May, 2021
"""
b)
Explanationsfortheclasses,functions,structures,etc.E.g.
"""
Stores integer coordinates of a point on a 2D plane """
class Coordinates: ...
"""
Returns distance between two points in 2 dimensions
"""
def distance (A, B): ...
c) Other in-place commentaries explaining
details of implementation # Euclidean distance
distance = np.sqrt((x1 - y1)**2 + (x2 - y2, 2)**2)
2. Printscreen images of the running
program. Sometimes there might be problems with different compilers
and different OS understanding the same code differently. A
printscreen images will support the validity of your program and
that it runs in your environment.