Create blank model, create tables, definition, attributes, domains and data types only for assigned entities

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

Create blank model, create tables, definition, attributes, domains and data types only for assigned entities #35

Closed adrianmnh closed 1 year ago

adrianmnh commented 1 year ago

Create a new model and add the entities assigned. These will be added to the main model during meeting on Friday 10/7/2022

[ ] Add definitions and comments to PDM columns
[ ] Add the data types to all columns/attributes
[ ] Add domains to columns/attributes
[ ] Primary surrogate keys for each of the tables assigned
[ ] Try to add dummy tables and relationships to the PDM or LDM you think are needed(not necessary) to link your entities to the rest of the model Due by #32

jsgarcha commented 1 year ago

Pushed to \Individual-PDM-Work\Jasminder. Uploaded diagrams here also for quick reference. JasminderGarcha-eStreamingMoviesSqlServer2019-20220919_Conceptual Data Model

jsgarcha commented 1 year ago

I think I might change Person First Name to Person Legal First Name and Person Last Name to Person Legal Last Name, to differentiate from a Star's Stage Name. Also, need to decide on Domains considering the rest of the models' datatypes.

ambergarcia commented 1 year ago

Very good