SQL 2000 Tables

I currently have two small MS SQL 2000 databases. The first database have 17 populated tables, 17 stored procedures, and 4 user defined functions. The second database is empty, it contains no data. The empty database have 21 empty tables. Your job will be: 1. To populate the second empty database with the data from the first populated database (ten tables only). Ideally, this task should be setup to run by itself at the end of the day (6 pm), six days a week, otherwise it can be done manually. 2. Table field dynamic updates triggered by changes in eleven (11) foreign related tables (triggers or constrains as applicable). 3. Only ten tables need to be [login to view URL] remaining tables in the second database are new. There are two tpyes of updates: 1. One that changes a field from "yes"(default) to "no" (tables1) based on the activity of another related table (attendance1) and according to certain attendance criteria. 2. Another that inserts a date and record number into a table (attendance1) based in the activity of ten related tables (attendance2, attendance3,..attendance11). Attendance1 table cannot have duplicated records for the same day and record number. Be aware that: The dabatabase structure and primary relationships are similar but not the same. You are free to make small changes to the second database to accomplished the data insert and dynamic updates, but without changing significatevely the overall design. Data from two or more tables from the first database are consolidated into one table in the second database. ## Deliverables 1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables): a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment. b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request. 3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement). ## Platform MS SQL 2000 Server All WINDOWS PLATFORMS