Posts

Image
  VIEWS IN DATABASE   Views in SQL are kind of virtual tables. A view also has rows and columns as they are in a real table in the database. We can create a view by selecting fields from one or more tables present in the database. A View can either have all the rows of a table or specific rows based on certain condition. There are two types of database views: 1.     Dynamic views 2.     Static views   DYNAMIC VIEWS Dynamic views can contain data from one or two tables and automatically include all of the columns from the specified table or tables. Dynamic views are automatically updated when related objects or extended objects are created or changed. When you create a dynamic view with data from two tables, you must ensure that both tables have the same PRIMARYKEYCOLSEQ columns or contain unique indexes with the same column name in the same order.   STATIC VIEWS Static views can contain data from multiple tables a...
Post a Comment
Read more

Use of Simulation software in Service Industries

~ By Samved Patil -  A simulation is a useful way for you to test real-life situations and processes without actually implementing those situations and processes. Since they help you to identify where improvements can be made before processes are put in place, working with simulations can save valuable time and resources.  Simulation modeling solves real-world problems safely and efficiently. It provides an important method of analysis which is easily verified, communicated, and understood. Across industries and disciplines, simulation modeling provides valuable solutions by giving clear insights into complex systems. Just as simulating traffic conditions and driving situations can help students improve their driving skills, simulations can help you analyze the service sector processes and entire industry and discover where improvements need to be made. In today’s world of global competition, customer satisfaction has become a major concern in service industry settings l...
14 comments
Read more