.. This file is part of the OpenDSA eTextbook project. See
.. http://opendsa.org for more details.
.. Copyright (c) 2012-2020 by the OpenDSA Project Contributors, and
.. distributed under an MIT open source license.

.. avmetadata::
   :author: Noha
   :satisfies: Big picture of relational data model
   :topic: Big picture of relational data model


Big picture of relational data model
====================================
As discussed before **database application** refers to a particular database and the associated programs that implement the database queries and updates.
For example, a
Hospital database application that keeps track of patient records and  health status would include
programs that implement database updates corresponding to patient admission and discharge from hospital. These programs would provide user-friendly 
graphical user interfaces (GUIs) utilizing forms and menus for the end users of the application (i.e. hospital doctors and patients in this example).
In addition, it is now common to
provide interfaces to these programs to Hospital patients via mobile devices using mobile apps. Hence, a major part of the database application will require
the design, implementation, and testing of these application programs. Traditionally, the design and testing of application programs has been considered to be 
part of software engineering rather than database design. In many software design tools, the database design methodologies and software engineering 
methodologies are intertwined since these activities are strongly related.

What is relational database?
----------------------------
ssssssssssssssssssssssssss
satisfiess
satisfiess
satisfiess
satisfiess

Advantages of using relational database
---------------------------------------

Relational Anatomy
------------------

.. inlineav:: ChenVsCrossFoot ss
   :long_name: ChenVsCrossFootRepresentation Slideshow
   :links: AV/Database/ChenVsCrossFoot.css
   :scripts: AV/Database/ChenVsCrossFoot.js
   :output: show

.. inlineav:: ChenVsCrossFootAttributes ss
   :long_name: ChenVsCrossFootAttributesRepresentation Slideshow
   :links: AV/Database/ChenVsCrossFootAttributes.css
   :scripts: AV/Database/ChenVsCrossFootAttributes.js
   :output: show

.. inlineav:: ChenVsCrossFootMultiAtt ss
   :long_name: ChenVsCrossFootMultiAttRepresentation Slideshow
   :links: AV/Database/ChenVsCrossFootMultiAtt.css
   :scripts: AV/Database/ChenVsCrossFootMultiAtt.js
   :output: show


.. inlineav:: ChenVsCrossFootDerivedAtt ss
   :long_name: ChenVsCrossFootDerivedAttRepresentation Slideshow
   :links: AV/Database/ChenVsCrossFootDerivedAtt.css
   :scripts: AV/Database/ChenVsCrossFootDerivedAtt.js
   :output: show

.. inlineav:: Cardinality ss
   :long_name: CardinalityRepresentation Slideshow
   :links: AV/Database/Cardinality.css
   :scripts: AV/Database/Cardinality.js
   :output: show

.. inlineav:: Participation ss
   :long_name: ParticipationRepresentation Slideshow
   :links: AV/Database/Participation.css
   :scripts: AV/Database/Participation.js
   :output: show

.. inlineav:: CardinalityVsParticipation ss
   :long_name: CardinalityVsParticipationRepresentation Slideshow
   :links: AV/Database/CardinalityVsParticipation.css
   :scripts: AV/Database/CardinalityVsParticipation.js
   :output: show

.. inlineav:: min-maxNotation ss
   :long_name: min-maxNotationRepresentation Slideshow
   :links: AV/Database/min-maxNotation.css
   :scripts: AV/Database/min-maxNotation.js
   :output: show

.. inlineav:: ChenVsCrossFootRelations ss
   :long_name: ChenVsCrossFootRelationsRepresentation Slideshow
   :links: AV/Database/ChenVsCrossFootRelations.css
   :scripts: AV/Database/ChenVsCrossFootRelations.js
   :output: show

.. inlineav:: ChenVsCrossFootRelationsMM ss
   :long_name: ChenVsCrossFootRelationsMMRepresentation Slideshow
   :links: AV/Database/ChenVsCrossFootRelationsMM.css
   :scripts: AV/Database/ChenVsCrossFootRelationsMM.js
   :output: show

.. inlineav:: ChenVsCrossFootRelations1M ss
   :long_name: ChenVsCrossFootRelations1MRepresentation Slideshow
   :links: AV/Database/ChenVsCrossFootRelations1M.css
   :scripts: AV/Database/ChenVsCrossFootRelations1M.js
   :output: show

.. inlineav:: ChenVsCrossFootRelationsM1 ss
   :long_name: ChenVsCrossFootRelationsM1Representation Slideshow
   :links: AV/Database/ChenVsCrossFootRelationsM1.css
   :scripts: AV/Database/ChenVsCrossFootRelationsM1.js
   :output: show