AWS is Amazon’s umbrella description of all of their web-based technology services. Main services include:
|
Category |
Service |
|
Compute |
|
|
Storage |
|
|
Content Delivery |
|
|
Database |
|
|
Deployment & Management |
|
|
Application Services |
|
|
Networking |
|
SaaS - Definition
|
Traditional packaged Software |
Saas |
|
Designed for customers to install, manage and maintain |
Designed from the outset up for delivery as Internet-based services |
|
Architect solutions to be run by an individual company in a dedicated
instantiation of the software |
Designed to run thousands of different customers on a single code |
|
Infrequent, major upgrades every 18-24 months, sold individually to
each installed base customer |
Frequent, "digestible" upgrades every 3-6 months to
minimize customer disruption and enhance satisfaction |
|
Version control |
Version control |
|
Upgrade fee |
- do - |
|
Fixing a problem for individual customer |
Fixing a problem for one customer fixes it for everyone |
JS Code
<script>
$(document).ready(function(){
var userid = $('#userid').val();
}
</script>
HTML Code
<input type="hidden" name="userid" id="userid" value="8"/>
Iterative and Evolutionary Development
Current research
demonstrates that iterative methods are associated with higher success and
productivity rates, and lower defect levels.
Timeboxing
A key idea is that iterations are timeboxed, or fixed in
length.
De-scoping: removing tasks or requirements from the
iteration, and including them in a future iteration, rather than slipping the
completion date.
Iterative and Evolutionary Development (also known as iterative and inceremental development; spiral development and evolutionary development)
Build-Feedback-Adapt
Cycles
In complex changing systems, feedback and adaptation are key
ingredients for success:
Benefits of Iterative development
The Unified Process is a popular iterative software development process.
Why a new
methodology?
Process-oriented
methods:
Waterfall (Sequential)
Lifecycle
Why the waterfall
lifecycle fails?
The key false assumption:
dynamic-table.php
action.php
Config.php
Employee.php
<?php require('config.php'); class Employee extends Dbconfig { protected $hostName; protected $userName; protected $password; protected $dbName; private $empTable = 'employment'; private $dbConnect = false; public function __construct(){ if(!$this->dbConnect){ $database = new dbConfig(); $this -> hostName = $database -> serverName; $this -> userName = $database -> userName; $this -> password = $database ->password; $this -> dbName = $database -> dbName; $conn = new mysqli($this->hostName, $this->userName, $this->password, $this->dbName); if($conn->connect_error){ die("Error failed to connect to MySQL: " . $conn->connect_error); } else{ $this->dbConnect = $conn; } } } public function employeeList(){ $sqlQuery = "SELECT * FROM ".$this->empTable." "; $result = mysqli_query($this->dbConnect, $sqlQuery); $employeeData = array(); while( $employee = mysqli_fetch_assoc($result) ) { $empRows = array(); $empRows[] = $employee['post']; $empRows[] = $employee['company']; $empRows[] = $employee['type']; $empRows[] = $employee['fromdate']; $empRows[] = $employee['todate']; $empRows[] = $employee['scale']; $empRows[] = $employee['gross']; $empRows[] = '<button type="button" name="update" id="'.$employee["id"].'" class="btn btn-warning btn-xs update">Update</button>'; $empRows[] = '<button type="button" name="delete" id="'.$employee["id"].'" class="btn btn-danger btn-xs delete" >Delete</button>'; $employeeData[] = $empRows; } $output = array( "draw" => intval($_POST["draw"]), "data" => $employeeData ); echo json_encode($output); } public function getEmployee(){ if($_POST["empId"]) { $sqlQuery = " SELECT * FROM ".$this->empTable." WHERE id = '".$_POST["empId"]."'"; $result = mysqli_query($this->dbConnect, $sqlQuery); $row = mysqli_fetch_array($result, MYSQLI_ASSOC); echo json_encode($row); } } public function updateEmployee(){ if($_POST['empId']) { $updateQuery = "UPDATE ".$this->empTable." SET userid = '".$_POST["userid"]."', post = '".$_POST["post"]."', company = '".$_POST["company"]."', type = '".$_POST["type"]."', fromdate = '".$_POST["fromdate"]."' , todate = '".$_POST["todate"]."' , scale = '".$_POST["scale"]."', gross = '".$_POST["gross"]."' WHERE id ='".$_POST["empId"]."'"; $isUpdated = mysqli_query($this->dbConnect, $updateQuery); } } public function addEmployee(){ $insertQuery = "INSERT INTO ".$this->empTable." (userid, post, company, type, fromdate, todate,scale, gross) VALUES ('".$_POST["userid"]."','".$_POST["post"]."', '".$_POST["company"]."', '".$_POST["type"]."', '".$_POST["fromdate"]."', '".$_POST["todate"]."', '".$_POST["scale"]."', '".$_POST["gross"]."')"; $isUpdated = mysqli_query($this->dbConnect, $insertQuery); } public function deleteEmployee(){ if($_POST["empId"]) { $sqlDelete = " DELETE FROM ".$this->empTable." WHERE id = '".$_POST["empId"]."'"; mysqli_query($this->dbConnect, $sqlDelete); } } } ?>
employee.sql
Inception - Activities
Inception - Exit criteria
ER Model is a popular high-level (conceptual) data model. It is an approach to designing Semantic Conceptual schema of a Database. ER model allows us to describe the data involved in a real-world environment in terms of objects and their relationships, which are widely used in design of database. ER model provides preliminary concepts or idea about the data representation which is later modified to achieve final detailed design.
Important concepts/notions used in ER modeling are-
Entity
It is an object in real-world or some idea or concept which can be distinguished from other objects.
Ex.: person, school, class, department, weather, salary, temperature etc.
Entity has independent existence.
Entity type
Each entity belongs to an Entity type that defines the structure.
Entity Set
It is a Collection of similar objects.
Attribute
Reflects a property of an object or entity. We have following types of attributes.
> Simple attribute
> Composite attribute
> Single valued attribute
> Multi-valued attribute
> Derived attribute
> Stored attribute
Key
Is an Attribute of an entity type whose value can uniquely identify an entity in a set.
Relationship
The association between entities is known as relationship.
Domain of an attribute
The set of possible values is known as domain of an attribute
1. Satisfy the customer through early and continuous delivery of valuable software.
2. Welcome changing requirements, even late in development.
3. Deliver working software frequently, from a couple of weeks to a couple of months, with a preference to the shorter time scale.
4. Business people and developers must work together daily throughout the project.
5. Build projects around motivated individuals.
6. The most efficient and effective method of conveying info.
7. Working software is the primary measure of progress.
8. Agile processes promote sustainable development.
9. The sponsors, developers, and users should be able to maintain a constant pace indefinitely.
10. Continuous attention to technical excellence and good design enhances agility.
11. Simplicity – the art of maximizing the amount of work NOT done is essential.
12. The best architectures, requirements, and designs emerge from self- organizing teams.
13. At regular intervals, the team reflects on how to become more effective, then tunes and adjusts its behavior accordingly.
Data Model is a collection of concepts that can be used to describe the structure of the database. Structure means data types, relationships, constraints etc. DBMS allows a user to define the data to be stored in terms of a data model.
1. High-level data models
2. Low-level data models
3. Representational or Implementation data models
High-level Data Models
Use set of concepts to describe the database, where the descriptions are close to user views. High-level data models are also known as conceptual models. In conceptual data modeling we use concepts like – entity, attributes, relationship etc.
Low-level Data Models
Give details about how the data is stored in a computers (storage level details).
Representational/Implementation Data Models
This is in between high-level and low-level data models. Here we represent the concepts described in conceptual model using a specific structures like, networks, objects, tables, trees etc. Ex: Relational Model, NW Model, Hierarchical Model, Object Model, Object relational model etc.
Relational Model
The central data description construct in this model is a relation, which can be thought of as a set of records.
Schema
Description of data in terms of a data model is called a schema. A relation schema specifies the name of the relation, fields, type etc.
eg:. Student (sid: string; name: string; age: integer) every row follows the schema of the relation.
The following are some important representational data models (DBMS Specific)
1. Network Model
Though the basic structure is a record, the relationships are captured using links. The database can be seen as an arbitrary network of records connected by links. Ex.: GE’s Integrated Data store (IDS), in Early 1960s
2. Hierarchical Model
The records containing data are organized as a collection of trees. Ex.: IBMs IMS (Information Management System), in late 1960s
3. Relational Model (early 1970s)
Data & relationships are captured as tables & keys. Ex.: Oracle, IBMs DB2, MySQL, Informix, Sybase, MS Access, Ingress, MySQL etc. The basic storage structure is a record.
4. Object Data Model
Objects created through object–oriented programs can be stored in database. Ex.: Object Store
5. Object Relational Model
Objects can be stores in tables. Ex.: Oracle, Informix
Description of a database is called as database Schema.
Three-Schema Architecture:
A database can be described using three different levels of abstractions. Description at each level can be defined by a schema. For each abstraction we focus on one of the specific issues such as user views, concepts, storage etc.
1. External schema: Used to describe the database at external level. Also described in terms of the data model of that DBMS. This allows data access to be customized at the level of individual users/groups/applications. Any external schema has one or more views and relations from the conceptual schema. This schema design is guided by end user requirements.
2. Conceptual schema (logical schema) Describes the stored data in terms of the data model specific to that DBMS. In RDBMS conceptual schema describes all relations that are stored in the database. Arriving at good choice of relations, fields and constraints is known as conceptual database design.
3. Physical schema: Describes the physical storage strategy for the database.
include ("function.php");
use include_once("function.php");1. Download the latest version of TinyMCE SDK
https://www.tiny.cloud/get-tiny/
2. Extract the folder [tinymce] and put in your application root folder.
eg: C:\xampp\htdocs\tinymcedemo\tinymce [tinymcedemo is the root folder]
3. Create a php file "test.php" and place the below code
Login to server WHM as a root user
Edit the php.ini file. Add below lineFatal error: Cannot pass parameter by reference in PHP.
The error is with 'test' in the bind_param call.
All parameters to bind_param must be passed by reference. A string is a primitive value, and cannot be passed by reference.
You can fix this by creating a variable and passing that as a parameter instead:
$testvar="test";