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?
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
EIA Training Resource Manual Second edition 2002 403 Topic 11 Implementation and follow up Training session outline Topic 11—Implementation and
Read more
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) Topic #11: Strategy Implementation (ppt) Nov 22, 2014 Documents alistercrowe. of 15
Read more
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
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
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
Add a comment