The Albums Persistence Layer - Githubissues

joshpham97 / soen487-restful-repository

SOEN 487 Team Project

0 stars 0 forks source link

The Albums Persistence Layer #26

Open ExZos opened 3 years ago

ExZos commented 3 years ago

Handles data persistency in a database (or file system)

[ ] You may use any of Fowler's Data Architecture Patterns to implement data persistency
[ ] Using a relational database is recommended but not mandatory. You may use any database system of your choice

Main tasks:

[ ] Album data
[ ] Change log data
[ ] Album DAO
[ ] Change log DAO

Albums have the following fields:

isrc (unique)
title
contentDesc (optional)
releasedYear
artistFirstName
artistLastName
coverImage (optional)
coverImageMIMEType?

Log Entries have the following fields:

timestamp (date and time)
typeOfChange (CREATE, UPDATE, or DELETE)
recordKey (Album ISRC)

Notes:

[ ] Artist info is stored in the same table as Album, no normalization is required
[ ] You need to store image data as well as its MIME type