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 #33

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

[x] Add definitions to LDM
[ ] Add comments to PDM columns
[x] Add the data types to all columns/attributes
[x] Add domains to columns/attributes
[x] 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

adrianmnh commented 1 year ago

Entity descriptions

Table Attributes

[x] Constraints added to YearlyCost, Status, and AvgFrameRate columns to test transferability
[x] Defaults added to YearlyCost and DeviceLimit for testing
[x] Schemas for constraints and defaults created