Pharmacy Database - PL/SQL - Final Project

Pharmacy Oracle SQL database - Logical, Conceptual and Physical models

Topics

• CONCEPTUAL MODEL
  • Entity Relationship (DER) diagram
• RELATIONAL Diagram (DR)
• PHYSICAL MODEL
  • TABLE CREATION
  • TABLE INSERTS
  • INSERT
  • ALTER TABLE
  • SELECT and its variations
  • Delete
  • View
  • Update
  • Group by
  • Having
  • Subquery
  • PL / SQL
  • SELECT INTO
  • IF
  • LOOPS
  • STORED PROCEDURES
  • TRIGGER

Authors

• Jonas dos Santos - JonasCassiano
• Matheus dos Anjos - MatanjosM

License

NON-COMMERCIAL

FEDERAL UNIVERSITY OF SÃO FRANCISCO VALLEY - UNIVASF