Convert the E-R diagram of Figure9-16 page 316 and 317 normalized relations, entity fields are on page 316. Convert these entities into physical design database tables using Microsoft Access.

Answer:

MS Access using physical design:

please use this google drive link to download the answer file.

https://drive.google.com/file/d/1MbXKK3m6LiFx1az3OiInTkDrPcdDHDXV/view?usp=sharing

note: if you have any trouble in viewing/downloading the answer from the given link, please use this below guide to understand the whole process.

https://helpinhomework.org/blog/how-to-obtain-answer-through-google-drive-link