Database programming PRESENTATION ID 1 NAMRATHA REDDY GANGULA

Database programming PRESENTATION ID: 1 NAMRATHA REDDY GANGULA PAGES: [358 -365], [371 -379]

OUTLINE HOW TO WORK WITH FILE PATHS HOW TO USE NAVIGATION CONTROLS WITH ASP. NET ROUTING INTRODUCTION TO RELATIONAL DATABASE DESIGN OF HALLOWEEN DATABASE

HOW TO WORK WITH FILE PATHS If a page is running in response to request made through asp. net routing, the page’s Route. Data property provides access to the parameter values in the URL To use a route parameter as a select parameter for a SQL data source, Route. Parameter is coded within the select parameter element of the data source The paths must be made relative to root directory One way to make sure that the URL for a static resource will be rendered correctly is to combine the use of the tilde operator with the Resolve. URL method of the page class

HOW TO USE NAVIGATION CONTROLS WITH ASP. NET ROUTING To use ASP. NET routing, you must import System. Web. Routing namespace To provide a default value for a route parameter, a Route. Value. Dictionary object for the parameter is created and a starting value is given.

An introduction to relational databases A relational database uses tables to store and manipulate data. Each table consists of one or more records that contain the data for a single entry The columns contain single item of data Primary key uniquely identifies each row in a table. Primary key can consist of two or more columns, then it is called composite primary key.

An introduction to relational databases Non-primary keys are called unique keys and they are implemented using unique key constraints A non-primary key uniquely identifies each row in a table. A table can be defined using one or more indexes. An index provides an efficient way to access data from a table based on values in specific columns. An index is automatically created for a table’s primary and non-primary keys

An introduction to relational databases The tables are related to each other through their key columns When two tables are related via a foreign key, the table with foreign key is referred to as the foreign key table and table with primary key is referred as primary key table. The relationships between the tables in a database correspond to the relationships between entities they represent. They can be one to one, many to many and one to many relationships.

An introduction to relational databases The data type that’s assigned to a column determines the type of information that can be stored in the column Each column definition is governed by its length, precision and scale Each column definition also indicates whether or not the column can contain null values. A null value indicates that the value of the column is not known A column can be defined with a default value, in case of which that value is used when a new row is added to the table. An identity column is a numeric column whose value is generated automatically when a row is added to the table Constraint values that a column can hold can be restricted when check constraints are used.

Design of Halloween database

Thank you