ok here is the most updated one. and yea the dates are killing me. How would i do this date time thing? This should be a lot more updated. It loads and everything but when i insert my date i get the obvious date check issue and patient foreign key issue out the butt.

Also the reason why i used a lot of what i did was because i followed this one that was provided for my class....and yes this class is absurb. If you have 90%+ right the teacher gives you 50% #$^#$&#$& One missing relationship is like 25-50% off -_- I also attached the example files

Also the reason why it is like it is because the requirements were to make any type of database that would have 7-10 relationships, 7-10 tables, 16 records, 8 queries with 4 compound. This is like a semester long project.

So from what the directions are for the project you are looking too deep into it. We simply need to have it relate for the most part, be able to input data, and query it. It doesn't have to update perfectly and be 100% linked and stuff liek your saying but yea this project is a bit extreme

Lastly, i have been getting help from like 2 class mates so who knows if they know what they are doing -_- At least half the class is lost as can be.

"

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

Msg 547, Level 16, State 0, Line 134

The INSERT statement conflicted with the CHECK constraint "ValidHireDate". The conflict occurred in database "Z1725527", table "NIUNT\Z1725527.Employees", column 'HireDate'.

The statement has been terminated.

Msg 547, Level 16, State 0, Line 141

The INSERT statement conflicted with the CHECK constraint "ValidHireDate". The conflict occurred in database "Z1725527", table "NIUNT\Z1725527.Employees", column 'HireDate'.

The statement has been terminated.

(1 row(s) affected)

(1 row(s) affected)

Msg 547, Level 16, State 0, Line 162

The INSERT statement conflicted with the CHECK constraint "ValidHireDate". The conflict occurred in database "Z1725527", table "NIUNT\Z1725527.Employees", column 'HireDate'.

The statement has been terminated.

Msg 547, Level 16, State 0, Line 169

The INSERT statement conflicted with the CHECK constraint "ValidHireDate". The conflict occurred in database "Z1725527", table "NIUNT\Z1725527.Employees", column 'HireDate'.

The statement has been terminated.

Msg 547, Level 16, State 0, Line 176

The INSERT statement conflicted with the CHECK constraint "ValidHireDate". The conflict occurred in database "Z1725527", table "NIUNT\Z1725527.Employees", column 'HireDate'.

The statement has been terminated.

Msg 547, Level 16, State 0, Line 183

The INSERT statement conflicted with the CHECK constraint "ValidHireDate". The conflict occurred in database "Z1725527", table "NIUNT\Z1725527.Employees", column 'HireDate'.

The statement has been terminated.

Msg 547, Level 16, State 0, Line 190

The INSERT statement conflicted with the CHECK constraint "ValidHireDate". The conflict occurred in database "Z1725527", table "NIUNT\Z1725527.Employees", column 'HireDate'.

The statement has been terminated.

(1 row(s) affected)

Msg 547, Level 16, State 0, Line 204

The INSERT statement conflicted with the CHECK constraint "ValidHireDate". The conflict occurred in database "Z1725527", table "NIUNT\Z1725527.Employees", column 'HireDate'.

The statement has been terminated.

Msg 547, Level 16, State 0, Line 211

The INSERT statement conflicted with the CHECK constraint "ValidHireDate". The conflict occurred in database "Z1725527", table "NIUNT\Z1725527.Employees", column 'HireDate'.

The statement has been terminated.

Msg 547, Level 16, State 0, Line 218

The INSERT statement conflicted with the CHECK constraint "ValidHireDate". The conflict occurred in database "Z1725527", table "NIUNT\Z1725527.Employees", column 'HireDate'.

The statement has been terminated.

Msg 547, Level 16, State 0, Line 225

The INSERT statement conflicted with the CHECK constraint "ValidHireDate". The conflict occurred in database "Z1725527", table "NIUNT\Z1725527.Employees", column 'HireDate'.

The statement has been terminated.

Msg 547, Level 16, State 0, Line 232

The INSERT statement conflicted with the CHECK constraint "ValidHireDate". The conflict occurred in database "Z1725527", table "NIUNT\Z1725527.Employees", column 'HireDate'.

The statement has been terminated.

Msg 547, Level 16, State 0, Line 239

The INSERT statement conflicted with the CHECK constraint "ValidHireDate". The conflict occurred in database "Z1725527", table "NIUNT\Z1725527.Employees", column 'HireDate'.

The statement has been terminated.

Msg 547, Level 16, State 0, Line 261

The INSERT statement conflicted with the CHECK constraint "ValidDateOfBirth". The conflict occurred in database "Z1725527", table "NIUNT\Z1725527.PATIENTRECORDS", column 'DateOfBirth'.

The statement has been terminated.

(1 row(s) affected)

Msg 547, Level 16, State 0, Line 269

The INSERT statement conflicted with the CHECK constraint "ValidDateOfBirth". The conflict occurred in database "Z1725527", table "NIUNT\Z1725527.PATIENTRECORDS", column 'DateOfBirth'.

The statement has been terminated.

Msg 547, Level 16, State 0, Line 273

The INSERT statement conflicted with the CHECK constraint "ValidDateOfBirth". The conflict occurred in database "Z1725527", table "NIUNT\Z1725527.PATIENTRECORDS", column 'DateOfBirth'.

The statement has been terminated.

Msg 547, Level 16, State 0, Line 277

The INSERT statement conflicted with the CHECK constraint "ValidDateOfBirth". The conflict occurred in database "Z1725527", table "NIUNT\Z1725527.PATIENTRECORDS", column 'DateOfBirth'.

The statement has been terminated.

Msg 547, Level 16, State 0, Line 281

The INSERT statement conflicted with the CHECK constraint "ValidDateOfBirth". The conflict occurred in database "Z1725527", table "NIUNT\Z1725527.PATIENTRECORDS", column 'DateOfBirth'.

The statement has been terminated.

(1 row(s) affected)

(1 row(s) affected)

Msg 547, Level 16, State 0, Line 293

The INSERT statement conflicted with the CHECK constraint "ValidDateOfBirth". The conflict occurred in database "Z1725527", table "NIUNT\Z1725527.PATIENTRECORDS", column 'DateOfBirth'.

The statement has been terminated.

(1 row(s) affected)

(1 row(s) affected)

Msg 547, Level 16, State 0, Line 305

The INSERT statement conflicted with the CHECK constraint "ValidDateOfBirth". The conflict occurred in database "Z1725527", table "NIUNT\Z1725527.PATIENTRECORDS", column 'DateOfBirth'.

The statement has been terminated.

Msg 547, Level 16, State 0, Line 309

The INSERT statement conflicted with the CHECK constraint "ValidDateOfBirth". The conflict occurred in database "Z1725527", table "NIUNT\Z1725527.PATIENTRECORDS", column 'DateOfBirth'.

The statement has been terminated.

Msg 547, Level 16, State 0, Line 313

The INSERT statement conflicted with the CHECK constraint "ValidDateOfBirth". The conflict occurred in database "Z1725527", table "NIUNT\Z1725527.PATIENTRECORDS", column 'DateOfBirth'.

The statement has been terminated.

Msg 547, Level 16, State 0, Line 317

The INSERT statement conflicted with the CHECK constraint "ValidDateOfBirth". The conflict occurred in database "Z1725527", table "NIUNT\Z1725527.PATIENTRECORDS", column 'DateOfBirth'.

The statement has been terminated.

(1 row(s) affected)

Msg 547, Level 16, State 0, Line 338

The INSERT statement conflicted with the FOREIGN KEY constraint "PatientIDFK1". The conflict occurred in database "Z1725527", table "NIUNT\Z1725527.PATIENTRECORDS", column 'PatientID'.

The statement has been terminated.

(1 row(s) affected)

Msg 547, Level 16, State 0, Line 348

The INSERT statement conflicted with the FOREIGN KEY constraint "PatientIDFK1". The conflict occurred in database "Z1725527", table "NIUNT\Z1725527.PATIENTRECORDS", column 'PatientID'.

The statement has been terminated.

Msg 547, Level 16, State 0, Line 353

The INSERT statement conflicted with the FOREIGN KEY constraint "PatientIDFK1". The conflict occurred in database "Z1725527", table "NIUNT\Z1725527.PATIENTRECORDS", column 'PatientID'.

The statement has been terminated.

Msg 547, Level 16, State 0, Line 358

The INSERT statement conflicted with the FOREIGN KEY constraint "PatientIDFK1". The conflict occurred in database "Z1725527", table "NIUNT\Z1725527.PATIENTRECORDS", column 'PatientID'.

The statement has been terminated.

Msg 547, Level 16, State 0, Line 363

The INSERT statement conflicted with the FOREIGN KEY constraint "PatientIDFK1". The conflict occurred in database "Z1725527", table "NIUNT\Z1725527.PATIENTRECORDS", column 'PatientID'.

The statement has been terminated.

(1 row(s) affected)

(1 row(s) affected)

Msg 547, Level 16, State 0, Line 378

The INSERT statement conflicted with the FOREIGN KEY constraint "PatientIDFK1". The conflict occurred in database "Z1725527", table "NIUNT\Z1725527.PATIENTRECORDS", column 'PatientID'.

The statement has been terminated.

(1 row(s) affected)

(1 row(s) affected)

Msg 547, Level 16, State 0, Line 393

The INSERT statement conflicted with the FOREIGN KEY constraint "PatientIDFK1". The conflict occurred in database "Z1725527", table "NIUNT\Z1725527.PATIENTRECORDS", column 'PatientID'.

The statement has been terminated.

Msg 547, Level 16, State 0, Line 398

The INSERT statement conflicted with the FOREIGN KEY constraint "PatientIDFK1". The conflict occurred in database "Z1725527", table "NIUNT\Z1725527.PATIENTRECORDS", column 'PatientID'.

The statement has been terminated.

Msg 547, Level 16, State 0, Line 403

The INSERT statement conflicted with the FOREIGN KEY constraint "PatientIDFK1". The conflict occurred in database "Z1725527", table "NIUNT\Z1725527.PATIENTRECORDS", column 'PatientID'.

The statement has been terminated.

Msg 547, Level 16, State 0, Line 408

The INSERT statement conflicted with the FOREIGN KEY constraint "PatientIDFK1". The conflict occurred in database "Z1725527", table "NIUNT\Z1725527.PATIENTRECORDS", column 'PatientID'.

The statement has been terminated.

(1 row(s) affected)

Msg 547, Level 16, State 0, Line 430

The INSERT statement conflicted with the FOREIGN KEY constraint "PatientIDFK2". The conflict occurred in database "Z1725527", table "NIUNT\Z1725527.PATIENTRECORDS", column 'PatientID'.

The statement has been terminated.

(1 row(s) affected)

Msg 547, Level 16, State 0, Line 440

The INSERT statement conflicted with the FOREIGN KEY constraint "PatientIDFK2". The conflict occurred in database "Z1725527", table "NIUNT\Z1725527.PATIENTRECORDS", column 'PatientID'.

The statement has been terminated.

Msg 547, Level 16, State 0, Line 445

The INSERT statement conflicted with the FOREIGN KEY constraint "PatientIDFK2". The conflict occurred in database "Z1725527", table "NIUNT\Z1725527.PATIENTRECORDS", column 'PatientID'.

The statement has been terminated.

Msg 547, Level 16, State 0, Line 450

The INSERT statement conflicted with the FOREIGN KEY constraint "PatientIDFK2". The conflict occurred in database "Z1725527", table "NIUNT\Z1725527.PATIENTRECORDS", column 'PatientID'.

The statement has been terminated.

Msg 547, Level 16, State 0, Line 455

The INSERT statement conflicted with the FOREIGN KEY constraint "PatientIDFK2". The conflict occurred in database "Z1725527", table "NIUNT\Z1725527.PATIENTRECORDS", column 'PatientID'.

The statement has been terminated.

(1 row(s) affected)

(1 row(s) affected)

Msg 547, Level 16, State 0, Line 470

The INSERT statement conflicted with the FOREIGN KEY constraint "PatientIDFK2". The conflict occurred in database "Z1725527", table "NIUNT\Z1725527.PATIENTRECORDS", column 'PatientID'.

The statement has been terminated.

(1 row(s) affected)

(1 row(s) affected)

Msg 547, Level 16, State 0, Line 485

The INSERT statement conflicted with the FOREIGN KEY constraint "PatientIDFK2". The conflict occurred in database "Z1725527", table "NIUNT\Z1725527.PATIENTRECORDS", column 'PatientID'.

The statement has been terminated.

Msg 547, Level 16, State 0, Line 490

The INSERT statement conflicted with the FOREIGN KEY constraint "PatientIDFK2". The conflict occurred in database "Z1725527", table "NIUNT\Z1725527.PATIENTRECORDS", column 'PatientID'.

The statement has been terminated.

Msg 547, Level 16, State 0, Line 495

The INSERT statement conflicted with the FOREIGN KEY constraint "PatientIDFK2". The conflict occurred in database "Z1725527", table "NIUNT\Z1725527.PATIENTRECORDS", column 'PatientID'.

The statement has been terminated.

Msg 547, Level 16, State 0, Line 500

The INSERT statement conflicted with the FOREIGN KEY constraint "PatientIDFK2". The conflict occurred in database "Z1725527", table "NIUNT\Z1725527.PATIENTRECORDS", column 'PatientID'.

The statement has been terminated.

(1 row(s) affected)

Msg 547, Level 16, State 0, Line 524

The INSERT statement conflicted with the FOREIGN KEY constraint "PatientIDFK3". The conflict occurred in database "Z1725527", table "NIUNT\Z1725527.PATIENTRECORDS", column 'PatientID'.

The statement has been terminated.

(1 row(s) affected)

Msg 547, Level 16, State 0, Line 534

The INSERT statement conflicted with the FOREIGN KEY constraint "PatientIDFK3". The conflict occurred in database "Z1725527", table "NIUNT\Z1725527.PATIENTRECORDS", column 'PatientID'.

The statement has been terminated.

Msg 547, Level 16, State 0, Line 539

The INSERT statement conflicted with the FOREIGN KEY constraint "PatientIDFK3". The conflict occurred in database "Z1725527", table "NIUNT\Z1725527.PATIENTRECORDS", column 'PatientID'.

The statement has been terminated.

Msg 547, Level 16, State 0, Line 544

The INSERT statement conflicted with the FOREIGN KEY constraint "PatientIDFK3". The conflict occurred in database "Z1725527", table "NIUNT\Z1725527.PATIENTRECORDS", column 'PatientID'.

The statement has been terminated.

Msg 547, Level 16, State 0, Line 549

The INSERT statement conflicted with the FOREIGN KEY constraint "PatientIDFK3". The conflict occurred in database "Z1725527", table "NIUNT\Z1725527.PATIENTRECORDS", column 'PatientID'.

The statement has been terminated.

(1 row(s) affected)

(1 row(s) affected)

Msg 547, Level 16, State 0, Line 564

The INSERT statement conflicted with the FOREIGN KEY constraint "PatientIDFK3". The conflict occurred in database "Z1725527", table "NIUNT\Z1725527.PATIENTRECORDS", column 'PatientID'.

The statement has been terminated.

(1 row(s) affected)

(1 row(s) affected)

Msg 547, Level 16, State 0, Line 579

The INSERT statement conflicted with the FOREIGN KEY constraint "PatientIDFK3". The conflict occurred in database "Z1725527", table "NIUNT\Z1725527.PATIENTRECORDS", column 'PatientID'.

The statement has been terminated.

Msg 547, Level 16, State 0, Line 584

The INSERT statement conflicted with the FOREIGN KEY constraint "PatientIDFK3". The conflict occurred in database "Z1725527", table "NIUNT\Z1725527.PATIENTRECORDS", column 'PatientID'.

The statement has been terminated.

Msg 547, Level 16, State 0, Line 589

The INSERT statement conflicted with the FOREIGN KEY constraint "PatientIDFK3". The conflict occurred in database "Z1725527", table "NIUNT\Z1725527.PATIENTRECORDS", column 'PatientID'.

The statement has been terminated.

Msg 547, Level 16, State 0, Line 594

The INSERT statement conflicted with the FOREIGN KEY constraint "PatientIDFK3". The conflict occurred in database "Z1725527", table "NIUNT\Z1725527.PATIENTRECORDS", column 'PatientID'.

The statement has been terminated.

(1 row(s) affected)

Msg 547, Level 16, State 0, Line 620

The INSERT statement conflicted with the CHECK constraint "ValidAdmissionDate". The conflict occurred in database "Z1725527", table "NIUNT\Z1725527.PATIENTROOM", column 'AdmissionDate'.

The statement has been terminated.

Msg 547, Level 16, State 0, Line 625

The INSERT statement conflicted with the CHECK constraint "ValidAdmissionDate". The conflict occurred in database "Z1725527", table "NIUNT\Z1725527.PATIENTROOM", column 'AdmissionDate'.

The statement has been terminated.

Msg 547, Level 16, State 0, Line 630

The INSERT statement conflicted with the CHECK constraint "ValidAdmissionDate". The conflict occurred in database "Z1725527", table "NIUNT\Z1725527.PATIENTROOM", column 'AdmissionDate'.

The statement has been terminated.

Msg 547, Level 16, State 0, Line 635

The INSERT statement conflicted with the CHECK constraint "ValidAdmissionDate". The conflict occurred in database "Z1725527", table "NIUNT\Z1725527.PATIENTROOM", column 'AdmissionDate'.

The statement has been terminated.

Msg 547, Level 16, State 0, Line 640

The INSERT statement conflicted with the CHECK constraint "ValidAdmissionDate". The conflict occurred in database "Z1725527", table "NIUNT\Z1725527.PATIENTROOM", column 'AdmissionDate'.

The statement has been terminated.

Msg 547, Level 16, State 0, Line 645

The INSERT statement conflicted with the CHECK constraint "ValidAdmissionDate". The conflict occurred in database "Z1725527", table "NIUNT\Z1725527.PATIENTROOM", column 'AdmissionDate'.

The statement has been terminated.

Msg 547, Level 16, State 0, Line 650

The INSERT statement conflicted with the CHECK constraint "ValidAdmissionDate". The conflict occurred in database "Z1725527", table "NIUNT\Z1725527.PATIENTROOM", column 'AdmissionDate'.

The statement has been terminated.

Msg 547, Level 16, State 0, Line 655

The INSERT statement conflicted with the CHECK constraint "ValidAdmissionDate". The conflict occurred in database "Z1725527", table "NIUNT\Z1725527.PATIENTROOM", column 'AdmissionDate'.

The statement has been terminated.

Msg 547, Level 16, State 0, Line 660

The INSERT statement conflicted with the CHECK constraint "ValidAdmissionDate". The conflict occurred in database "Z1725527", table "NIUNT\Z1725527.PATIENTROOM", column 'AdmissionDate'.

The statement has been terminated.

Msg 547, Level 16, State 0, Line 665

The INSERT statement conflicted with the CHECK constraint "ValidAdmissionDate". The conflict occurred in database "Z1725527", table "NIUNT\Z1725527.PATIENTROOM", column 'AdmissionDate'.

The statement has been terminated.

Msg 547, Level 16, State 0, Line 670

The INSERT statement conflicted with the CHECK constraint "ValidAdmissionDate". The conflict occurred in database "Z1725527", table "NIUNT\Z1725527.PATIENTROOM", column 'AdmissionDate'.

The statement has been terminated.

Msg 547, Level 16, State 0, Line 675

The INSERT statement conflicted with the CHECK constraint "ValidAdmissionDate". The conflict occurred in database "Z1725527", table "NIUNT\Z1725527.PATIENTROOM", column 'AdmissionDate'.

The statement has been terminated.

Msg 547, Level 16, State 0, Line 680

The INSERT statement conflicted with the CHECK constraint "ValidAdmissionDate". The conflict occurred in database "Z1725527", table "NIUNT\Z1725527.PATIENTROOM", column 'AdmissionDate'.

The statement has been terminated.

Msg 547, Level 16, State 0, Line 685

The INSERT statement conflicted with the CHECK constraint "ValidAdmissionDate". The conflict occurred in database "Z1725527", table "NIUNT\Z1725527.PATIENTROOM", column 'AdmissionDate'.

The statement has been terminated.

Msg 547, Level 16, State 0, Line 690

The INSERT statement conflicted with the CHECK constraint "ValidAdmissionDate". The conflict occurred in database "Z1725527", table "NIUNT\Z1725527.PATIENTROOM", column 'AdmissionDate'.

The statement has been terminated.

Msg 547, Level 16, State 0, Line 695

The INSERT statement conflicted with the CHECK constraint "ValidAdmissionDate". The conflict occurred in database "Z1725527", table "NIUNT\Z1725527.PATIENTROOM", column 'AdmissionDate'.

The statement has been terminated.

Msg 547, Level 16, State 0, Line 714

The INSERT statement conflicted with the FOREIGN KEY constraint "PatientIDFK5". The conflict occurred in database "Z1725527", table "NIUNT\Z1725527.PATIENTRECORDS", column 'PatientID'.

The statement has been terminated.

(1 row(s) affected)

Msg 547, Level 16, State 0, Line 724

The INSERT statement conflicted with the FOREIGN KEY constraint "PatientIDFK5". The conflict occurred in database "Z1725527", table "NIUNT\Z1725527.PATIENTRECORDS", column 'PatientID'.

The statement has been terminated.

Msg 547, Level 16, State 0, Line 729

The INSERT statement conflicted with the FOREIGN KEY constraint "PatientIDFK5". The conflict occurred in database "Z1725527", table "NIUNT\Z1725527.PATIENTRECORDS", column 'PatientID'.

The statement has been terminated.

Msg 547, Level 16, State 0, Line 734

The INSERT statement conflicted with the FOREIGN KEY constraint "PatientIDFK5". The conflict occurred in database "Z1725527", table "NIUNT\Z1725527.PATIENTRECORDS", column 'PatientID'.

The statement has been terminated.

Msg 547, Level 16, State 0, Line 739

The INSERT statement conflicted with the FOREIGN KEY constraint "PatientIDFK5". The conflict occurred in database "Z1725527", table "NIUNT\Z1725527.PATIENTRECORDS", column 'PatientID'.

The statement has been terminated.

(1 row(s) affected)

(1 row(s) affected)

Msg 547, Level 16, State 0, Line 754

The INSERT statement conflicted with the FOREIGN KEY constraint "PatientIDFK5". The conflict occurred in database "Z1725527", table "NIUNT\Z1725527.PATIENTRECORDS", column 'PatientID'.

The statement has been terminated.

(1 row(s) affected)

(1 row(s) affected)

Msg 547, Level 16, State 0, Line 769

The INSERT statement conflicted with the FOREIGN KEY constraint "PatientIDFK5". The conflict occurred in database "Z1725527", table "NIUNT\Z1725527.PATIENTRECORDS", column 'PatientID'.

The statement has been terminated.

Msg 547, Level 16, State 0, Line 774

The INSERT statement conflicted with the FOREIGN KEY constraint "PatientIDFK5". The conflict occurred in database "Z1725527", table "NIUNT\Z1725527.PATIENTRECORDS", column 'PatientID'.

The statement has been terminated.

Msg 547, Level 16, State 0, Line 779

The INSERT statement conflicted with the FOREIGN KEY constraint "PatientIDFK5". The conflict occurred in database "Z1725527", table "NIUNT\Z1725527.PATIENTRECORDS", column 'PatientID'.

The statement has been terminated.

Msg 547, Level 16, State 0, Line 784

The INSERT statement conflicted with the FOREIGN KEY constraint "PatientIDFK5". The conflict occurred in database "Z1725527", table "NIUNT\Z1725527.PATIENTRECORDS", column 'PatientID'.

The statement has been terminated.

(1 row(s) affected)

"