G915-2-Data-Modeling-381 / Project-1-eStreamingMovies

Collaborate and use the best from each of the group member's individual project and create the modernized YourName-eStreamingMoviesSqlServer2019-yyyymmdd. Highlighting the individual's contributions for the best solution. Read the Project one Specification Read the Project plan
0 stars 0 forks source link

Write Definitions and attributes for Person and Address #29

Closed ambergarcia closed 1 year ago

jsgarcha commented 1 year ago

Conceptual Data Model

Business Objects: Person: A single human being. Address: Where a Person lives.

Business Rules: A Person has an Address & an Address belongs to a Person.

Logical Data Model

Entity: Attributes (key attributes are above the line) & Relationships –

 Address: 
 Address Id 
 ____________
 Address State 
 Address City 
 Address Zip Code
 Address Street

 Person: 
 Person Id
 ___________
 Person First Name 
 Person Last Name
 Person Phone Number
 Person Email Address
 Address Id (Foreign Key referencing Address.AddressId)
ambergarcia commented 1 year ago

confirmed