Published on February 10, 2014
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
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
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.
EIA Training Resource Manual Second edition 2002 403 Topic 11 Implementation and follow up Training session outline Topic 11—Implementation and
1. Er. Pradip KharbujaTopic 11Implementation . 2. Aspects of Implementation Creating...1.Tables2.Indexes3.Views4.Domains Write an example of each.
Topic #11: Strategy Implementation (ppt) Topic #11: Strategy Implementation (ppt) Nov 22, 2014 Documents alistercrowe. of 15
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 ...
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 ...
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 ...