Introduction to Database Systems (SQL), is based on relational database use and design. The core elements of the class include: SQL programming language, database administration and management, programmatic database access through Java, Algorithms and data structures for queries and transactions. The course serves as an pre-introduction to data science imparting knowledge of database management, software development, big data and foundational theories on algorithms and structures. Indispensable knowledge for anyone serious about pursuing virtually any domain in technology.
This is a design for a database that is used by pharmacies to track patient prescriptions. In addition, the database also stores information about doctors and patients.There are five basic entities: Doctor, Patient, Drug, Pharmacy, and Prescription. There are two additional junction tables, prescription_refill which is used for entering refills, and drug_cost which determines the cost of a drug.