Say I have a database structure like this:
CREATE table Customer (id identity, name varchar(30), dateofbirth datetime, Photo varbinary, primary key (id)) CREATE table Order (id int, Date datetime, Primary Key (id)) create table CustomerOrder (CustomerID, OrderID)
Say I wanted to copy the database into DynamoDB for CQRS. The dynamodb table would have the following columns:
Name DateOfBirth Photo List of Orders
However, if the customer places 100 orders then the same photo is stored 100 times. Is it normal to do this or should the photo be stored in a different table?