Advance database concepts

After you determine a background of your project and collect information about the project. Each project would typically go through the following phases: (1) Design the database using Entity-Relationship Diagrams/UML Class Diagrams. (2) Create tables, including constraints such as primary keys, foreign keys, check constraints, and not null constraints. (3) Create PL/SQL, and Objects. (4) Create triggers and active elements to maintain integrity of the database and to perform appropriate actions on database updates. (5) Populate the database using SQL insert statements or by writing programs in Java, VB, C#, Python, ASP.NET, JSP, or any language. (6) Write application programs in any language. After you determine a background of your project and collect information about the project. Each project would typically go through the following phases: (1) Design the database using Entity-Relationship Diagrams/UML Class Diagrams. (2) Create tables, including constraints such as primary keys, foreign keys, check constraints, and not null constraints. (3) Create PL/SQL, and Objects. (4) Create triggers and active elements to maintain integrity of the database and to perform appropriate actions on database updates. (5) Populate the database using SQL insert statements or by writing programs in Java, VB, C#, Python, ASP.NET, JSP, or any language. (6) Write application programs in any language. After you determine a background of your project and collect information about the project. Each project would typically go through the following phases: (1) Design the database using Entity-Relationship Diagrams/UML Class Diagrams. (2) Create tables, including constraints such as primary keys, foreign keys, check constraints, and not null constraints. (3) Create PL/SQL, and Objects. (4) Create triggers and active elements to maintain integrity of the database and to perform appropriate actions on database updates. (5) Populate the database using SQL insert statements or by writing programs in Java, VB, C#, Python, ASP.NET, JSP, or any language. (6) Write application programs in any language. PROJECT (Group Project) After you determine a background of your project and collect information about the project. Each project would typically go through the following phases: (1) Design the database using Entity-Relationship Diagrams/UML Class Diagrams. (2) Create tables, including constraints such as primary keys, foreign keys, check constraints, and not null constraints. (3) Create PL/SQL, and Objects. (4) Create triggers and active elements to maintain integrity of the database and to perform appropriate actions on database updates. (5) Populate the database using SQL insert statements or by writing programs in Java, VB, C#, Python, ASP.NET, JSP, or any language. (6) Write application programs in any language. (7) Documents the project. The application programs would have to implement some form of user interface. The simplest user interface is terminal based and involves menus and sub-menus.