Topic 11 : Implementation

57 %
43 %
Information about Topic 11 : Implementation
Education

Published on February 10, 2014

Author: PradipKharbuja

Source: slideshare.net

Topic 11 Implementation Er. Pradip Kharbuja

Aspects of Implementation ï‚§ Creating... 1. Tables 2. Indexes 3. Views 4. Domains ï‚§ Write an example of each.

Some More Constraints ï‚§ Null Integrity ï‚§ Entity Integrity ï‚§ Referential integrity ï‚§ Domain constraints or General Constraints ï‚§ Propagation constraints ï‚§ Table constraints

departments and workers Table departments dept_no workers PK emp_no dept_no PK FK

departments and workers Table

workers Table

Propagation Constraint ï‚§ What happens if we delete a department from departments table? ï‚§ There are lots of workers records that reference it. What happens to them? ï‚§ What happens if we update or change dept_no?

Options for Propagation 1. No action 2. Set Null 3. Cascade 4. Set Default

Table with Propagation Constraint DEMO ???

Table Constraints ï‚§ This example limits the amount of times a boat can be rented to less than 10. ï‚§ Table constraints can be dropped using the Alter Table clause.

Inserting Multiple Rows of Data

Data Loading Tools ï‚§ Bulk insert in SQL server ï‚§ http://sqlserver2000.databases.aspfaq.com/how-do-i-load-textor-csv-file-data-into-sql-server.html ï‚§ Oracle SQL loader ï‚§ http://oreilly.com/catalog/orsqlloader/chapter/ch01.html ï‚§ My-SQL uses something called 'Bulk Insert' ï‚§ http://mysql.bigresource.com/Bulk-insert-from-text-filesdDPRzHYo.html#2t6P0D5I

Bulk Insert ï‚§ Create CSV file with student_id, level_name and course. Save the file as D:students.csv.

Further Studies ï‚§ PL/SQL ï‚§ Stored functions ï‚§ Stored procedures ï‚§ Triggers ï‚§ Data warehouses

ANY QUESTIONS?

Add a comment

Related presentations

Related pages

Topic 11—Implementation and follow up - UNEP - Geneva

EIA Training Resource Manual u Second edition 2002 407 Topic 11 Implementation and follow up Training session outline the whole life cycle of the project.
Read more

Topic 11 Implementation and follow up - UNEP - Geneva

EIA Training Resource Manual Second edition 2002 403 Topic 11 Implementation and follow up Training session outline Topic 11—Implementation and
Read more

Topic 11 : Implementation - Education - documents

1. Er. Pradip KharbujaTopic 11Implementation . 2. Aspects of Implementation Creating...1.Tables2.Indexes3.Views4.Domains Write an example of each.
Read more

Topic #11: Strategy Implementation (ppt) - Documents

Topic #11: Strategy Implementation (ppt) Topic #11: Strategy Implementation (ppt) Nov 22, 2014 Documents alistercrowe. of 15
Read more

Topic Doc SY 11-12 Fee Policy Implementation

Topic Doc - SY11-12 Fee Policy Implementation (09 Nov 2011) (Page 5 of 26) REMEMBER: All 1st and 2nd child rates should be even numbers (able to be divided ...
Read more

PKCS#11 implementation - Google Groups

For Java applications we recommend to use the pure-Java implementation as found in the eid-applet project. A big plus is that this implementation does not ...
Read more

Topic - 11.4 Implementation - Notemonk

Notemonk is an exciting new way to experience books. An easy to use webtool helping students to prepare better by downloading books, taking notes, sharing ...
Read more