Search for question
Question

My Family Reunion Database - Physical Model Family Reunions Reunion_ID Reunion_Name Reunion_Date Reunion_Family Reunion_ID Family_ID Families Family_ID Family_Name Year Established Family Count The Physical Data Model illustration Int (Identity) Varchar(30) Int

Date Int Int (Identity) Varchar(30) # Date Int Family Member Addresses FM_Address_ID FM_Address FM_City FM_State FM_ZipCode Family_Member_ID Family Members Family Member_ID FM_FirstName FM_LastName FM_MiddleInitial FM_Age Family_ID Int (Identity) Varchar(50) Varchar(25) VarChar(2) Varchar(5) Int Int (Identity) Varchar(30) Varchar(30) Varchar(1) Null Int Int/nHANDIDS AMOR (0) Calventna 20 ( Curt Odnie:00 of the ( M (0) Mediaspe S (Streptone (2) Produ OLO (Grectione Produced/nIn this scenario, you now have a physical database model of your retail store that sells bikes from Unit 3 take this model and prepare Data Definition Language (DDL) code if you were tasked to implement and create these tables in a SQL-driven database. In a Microsoft Word document, research the library or internet to discuss the purpose of Data Definition Language (DDL) and all of its uses to support the development and variants of the database schema. The paper should be in the range of about 500 words. When concluding your paper, lead these conclusions into your proposed and written-out DDL code to implement tables based upon your physical database model finalized from unit 3. For example, notice the example DDL code tab, which would be used to create these tables in Microsoft SQL Server from the example Physical Model presented in unit 3.

Fig: 1

Fig: 2

Fig: 3