Please help with the followingWrite the SQL code to create the table structures for the entities shown in Figure 1. The structures should contain the attributes specified in the ERD. Use data types that are appropriate for the data that will need to be stored in each attribute. Enforce primary key and foreign key constraints as indicated by the ERD. Figure 1:DETAILRENTALMEMBERSHIPPK,FK1 RENT NUMPK,FK2 VID NUMRENTALPK MEM_NUMPK RENT_NUMH--OMEM_FNAMEMEM_LNAMEMEM_STREETМЕМ СITYMEM_STATEМЕM ZIPMEM_BALANCEDETAIL_FEEDETAIL DUEDATEDETAIL_RETURNDATEDETAIL_DAILYLATEFEERENT_DATEFK1 MEM_NUMMOVIEVIDEOPKH-OVID_NUMPKMOVIE_NUMPRICEVID_INDATEFK1 MOVIE_NUMMOVIE_TITLEMOVIE YEARMOVIE COSTMOVIE_GENREFK1 PRICE_CODEPK PRICE CODEH0---OPRICE DESCRIPTIONPRICE RENTFEEPRICE DAILYLATEFEEFigure 2:MEMBERSHIPМЕММЕММЕММЕМMEMMEM_STREETMEM_CITYMEM_ZIPNUMFNAMELNAMESTATEBALANCE102TamiDawson2632 Takli CircleNoreneTN3713611CurtKnight4025 Cornell CourtFlatgapQuebeck103KY412196104JamalMelendez788 East 145th AvenueTN38579105IvaMcclain6045 Musket Ball CircleSummitKY4278315106MirandaParks4469 Maxwell PlaceGermantownTN38183107RosarioElliott7578 Danner AvenueColumbiaTN38402108MattieGuy4390 Evergreen StreetLilyKY40740RENTALRENT NUMRENT DATEMEM_NUM100101-MAR-09103100201-MAR-09105100302-MAR-09102100402-MAR-09110100502-MAR-09111

Actually, ERD stands for Entity Relationship Diagram.

Answered: Write the SQL code to create the table…

Computer Networking: A Top-Down Approach (7th Edition)

7th Edition

ISBN:9780133594140

Author:James Kurose, Keith Ross

Publisher:James Kurose, Keith Ross

Chapter1: Computer Networks And The Internet

Section: Chapter Questions

Problem R1RQ: What is the difference between a host and an end system? List several different types of end...

See similar textbooks

Related questions

Question

Please help with the following

Write the SQL code to create the table structures for the entities shown in Figure 1. The structures should contain the attributes specified in the ERD. Use data types that are appropriate for the data that will need to be stored in each attribute. Enforce primary key and foreign key constraints as indicated by the ERD.