BDG Scenario 1

TitleAuth.sql

If Exists (Select * From sysobjects Where name = N'titleauth' And user_name(uid) = N'dbo')
    Drop Table dbo.titleauth
Go

Create Table dbo.titleauth
    (
    bib# int Not Null,
    auth# int Not Null
    )
Go
Alter Table dbo.titleauth Add Constraint
    FK_titleauth_title Foreign Key
    (
    bib#
    ) References dbo.title
    (
    bib#
    )
Go
Alter Table dbo.titleauth Add Constraint
    FK_titleauth_author Foreign Key
    (
    auth#
    ) References dbo.author
    (
    auth#
    )
Go