Ask a question from expert
ICT704 Database Structure Database & Document
8 Pages1358 Words239 Views
Added on 2020-03-16
ICT704 Database Structure Database & Document
Added on 2020-03-16
BookmarkShareRelated Documents
StudentID: Student Name:Course Code: ICT704
Table of ContentsDatabase Structure......................................................................................................................................3Database & Document (comiccrusaders):...............................................................................................3Indexes in comiccrusaders.......................................................................................................................4Relationships in comiccrusaders..............................................................................................................4Alternative Modeling (Relationships)..........................................................................................................5Recommendations to Comic Crusaders.......................................................................................................6References...................................................................................................................................................8
Database StructureDatabase & Document (comiccrusaders):Comic Crusaders are one of the largest comic books retailer having presence in United States (US) and United Kingdom (UK) who wish to have online presence in the current market. For each book they wish to store the customer’s feedback. Only those customers can provide the feedback who register their name with Comic Crusaders. MongoDB database is being used to store the details like comics, publishers and reviews & ratings.[ CITATION Sch \l 1033 ]. Like other RDBMS, MongoDB is non-relational. Tables of RDBMS are represented as collection and rows are represented as fields in MongoDB.Database with the following structure has been created:Database name: “comiccrusaders”Collection Name: “comics” Colletion comics have the following fields:comicidEach comic is recognized by this field and it is compulsory. It cannot be null.titleTitle of the comic.seriestitleSeries of the title e.g. Disney kingdoms. (if any). It can contain a null value.dateofpublicationIt just stores the publication year of the comic and cannot be null.physicaldescriptionPhysical description of the comic book. It is an optional field.topicsCategory or keywords of comic book. It is an optional field. Searching ofa comic depends upon this field.
End of preview
Want to access all the pages? Upload your documents or become a member.
Related Documents
MongoDB Database Implementation and Optimization - Deskliblg...
|13
|2135
|313