(Solved) : 1 Create Access Database Named Surnamenameaccdb Create Following Tables Database Table Na Q32989467 . . . .

1. Create an Access Database named:“surname_name.accdb” Create the following tables in thisdatabase:

a. Table Name: MovieAttributes:

mID (number, long integer, indexed – no duplicates, required,primary key)

mName (text, 100, required)

mDate (date/time, short date)

mScore (number, long integer)

b. Table Name: ActorAttributes:

aID (number, long integer, indexed – no duplicates, required,primary key)

aName (text, 20, required)

aSurname (text, 20, required)

aAge (number, long integer)

c. Table Name: GenreAttributes:

gID (number, long integer, indexed – no duplicates, required,primary key)

gName (text, 20, required)

d. Table Name: hasCastAttributes:

mID (number, long integer, indexed – duplicates ok, required,primary key)

aID (number, long integer, indexed – duplicates ok, required,primary key)
(mID and aID form the composite primary key, since we need