advertisement

Topic 11 : Implementation

57 %
43 %
advertisement
Information about Topic 11 : Implementation
Education

Published on February 10, 2014

Author: PradipKharbuja

Source: slideshare.net

advertisement

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