Data Modelling Assignment: System Analysis & Design Of Bookedbook Company

Question

Task: Scenario (The Case)

Book reading is an extremely healthy activity. It has many benefits and above all, it is exciting, entertaining and a great way to release stress, anxiety and depression. These are not the only benefits. Above everything; book reading helps in mental stimulation; improvement of memory and it also helps in improving language skills. It also certainly allows an individual to help concentrate better. In short, the benefits are enormous.
In recent times we have been introduced to technologies such as laptops, cell phones, tablets and other technologies but to date, the conventional book reading is something that people cherish and enjoy in its own way. It is believed that a “book has no substitute” and book readers from all over the world firmly agree to this. Cynthia, a young technopreneur and a book lover; plans to open an online lifestyle substitute business named ‘bookedbook.com’. This online business is Cynthia’s dream. Cynthia has formally registered her new company; everything is in place from a legal perspective and the company now has ample funds to develop an online website that would support Cynthia’s business idea.

bookedbook.com would be an extremely interesting website. This website will require user registration. Children would also be able to register but their registration would be accompanied with some details of parents and their contacts. The website would only offer individual registrations and proof of ID would be a must when registering. bookedbook.com will offer quarterly, biannual and annual memberships. The whole idea is very simple. Registered book readers would be able to launch the books that they own and which they would want to give away to other registered members. A book launch would require complete details of the book. It would also require the user to provide the address where the book is available. Once the book details are provided by the subscriber (registered book reader) the company’s content manager would approve the book launch request. Once approved, the book would be available for all users for them to review and/or acquire. The review process would allow all users to provide feedback and comments about the book and would also allow users to rate the book. The acquisition process would allow book readers to acquire the book from the book owner. The users planning on acquiring the book, would make a request for book acquisition. This request would help facilitate book reader meetup and exchange books. Once the book would be acquired the book owner would have the option of removing the book. bookedbook.com will also allow users to interact with one another via messaging and chat rooms. Users will be given an option to decide the mode of communication that they would prefer. Off course all chat request, messages and acquisition request and all other messages are also provided to the user via email that is provided at the time of subscription.
The website would also provide a portal to the administrator for data analytics. Cynthia is keen to observe and analyse every type of data that is obtained at this website. For example, she wants to know which book is being exchanged mostly, she wants complete customer analytics, book exchange analytics, analysis of book reviews and rating and other similar portals for data analysis.
As soon as the user registration would expire, all book launch requests would be halted by the system and the users interested in acquiring the book(s) placed by the user whose registration is about to expire would be sent an email that these book(s) are no longer available. Users would be asked to renew their subscription 15 days before the registration expiry date to ensure continuity of services.

Cynthia does not want this website to be a book exchange platform only. She also wants the website to provide a platform for all the users to arrange for an online and face to face meetup. She wants to ensure that any book meetup events that bookedbook.com plans should be available to its users. Users should be able to register for these events which may be paid or unpaid. She feels that these meetups would be a great source of fun for book lovers and also a source of marketing for the company.

In order to ensure this website stays profitable Cynthia also wants this website to allow book authors from all around the world to advertise their books on bookedbook.com. This functionality, however, would not require book authors to register with bookedbook.com formally. Book authors would be able to just fill in a ‘book show request form’, provide their details, provide the details of their book and a credit/debit card number. They would also provide information about the time period for which they want their book to be advertised on the website. Advertisement requests would also be approved by the content manager. Once approved, the book authors would be charged and the advertisement would go live. The ad would be removed by the system automatically once it reaches the end date. bookedbook.com will only allow advertisement of up to 5 books at a time. All advertisement requests would be entertained by the system on a first come first serve basis. The advertisement functionality is also available for subscribers. In this case the fee for advertisement is very minimal. Cynthia wants this website to be upgradable and secure. She wants simple and modern interfaces and also wants a mobile application version of this website. Requirements to be covered in the data modelling assignment: With an in-depth understanding of the functional requirements of the System, you are now required to perform further analysis through process and data modelling. In doing so, you also need to provide a preliminary data storage design for the System. Both process modelling and data modelling can be used to provide deeper understanding of a new System. Thus, they are an integral part of System Analysis. Process modelling describe processes – i.e. the sequence of activities that people do; while data modelling seeks to describe the data flows through those processes. Data flow diagrams (including context diagrams) and entity relationship diagrams are the most common process and data modelling techniques used in industry.

Please complete the following tasks:
Task 1. Create a Context Diagram for the given case study.
Task 2. Create and document a Level 0 Data Flow Diagram (DFD). The Level 0 DFD should contain all the major high-level processes of the System and how these processes are interrelated.
Task 3. Select three important processes from Level 0 DFD, decompose each of the processes into a more explicit Level 1 DFD.
Task 4. For the given case study, provide an Entity Relationship Diagram (ERD).
Task 5. For the given case study, identify the data stores including the files that are not part of ERD.
Task 6. Translate the ERD you developed in Task 4 into a physical relational database design. Document database tables and their relationship in MSWord file. Normalise your database design to the Third Normal Form (3NF).
Please note that your responses to the tasks above must relate to the case study provided.

Answer

Introduction
The following report on data modelling assignment will be carried out for the system analysis and design of Bookedbook company. The following report will be determined with the representation of the entire process which is included in the business process of the company. There has been a creation of website by the authorities of the company, it has been done such that the stakeholders will be able to read, provide content, and the company could gain some amount of subscribers to the website of the company. The website has been developed which would require some contribution to the website from every stakeholder. There are some of the stakeholders which has been categorized into some level of classification. The company has some more members who are included in the system as admin panel, these are the content manager and the analytical team. In the following report will be creating a context diagram or the level 0 data flow diagram such that the boundaries of the information technology software system will be defined in a clearer manner. The report will also be providing a data flow diagram for the software system of Bookedbook. The report will also be providing three important processes from the data flow diagram and then the processes will be providing a clearer view in depth with the help of level 1 diagram. The report will also be providing an entity relationship diagram (ERD) diagram related to the software system of Bookedbook, the data stories will be provided and documented.

Task 1: Context level diagram

As it could be observed from the above diagram that the replication of the context level diagram has been proposed. It could be observed that there is a block for the software system of the company, and all the related stakeholders are associated to it (Boudjemline et al., 2017). It could be observed that the potential user first registers their details to the software system of Bookedbook, if there is any minor group, they will be allowed to register and get subscription with the help of their parent’s credentials. The registered users are termed as the book readers who are already influenced with the subscription, they provide the details of the book which is needed by them. It could also be observed from the diagram that the content manager provides their decision whether the request could be approved or not, this could be related to the advertisement request made by the book owner. book authors and book owners who launch the details of the related content.

Task 2: Data Flow Diagram

As it could be observed from the above diagram that the data flow diagram for Bookedbook.com has been shown. The data flow diagram for the website consists of all the high level and majorly important processes. It has also been shown that the interrelation of all the high level processes and the communication between each processes (Widaryanto, Widiyanto&Rifa’i, 2017). The above diagram includes all the input, output, data stores and data sub processes which will be carried out during the process takes place. There are some of the stakeholders which has been categorized into some level of classification. There are the most important actors which has been considered by the web based system of Bookedbook, they are book readers, book owners, book authors, these are some of the actors who are priority of the web based system where they also have some functions and roles to play in the web based system. The readers will be able to read books on the platform and they will have to do nothing but register to the web system by providing some amount of contribution. The book owners will be the ones who will also have to get registered to the system and provide content to the readers such that they will be able to read them. The book authors will be able to advertise their books such that the content could get maximum reach to the readers out there. The company has some more members who are included in the system as admin panel, these are the content manager and the analytical team. The content manager has been determined with the task of approving the request which they will be getting from the user side. The analytical team has been determined with the task of optimizing the data.

Task 3: Explicit level 1 DFD
Process 1

As it could be observed from the above diagram that one of the most important processes from the level 0 DFD has been selected and decomposed into explicit level 1 DFD. The process has been shown regarding the registration of book readers and the website user It has been shown that the potential user first registers their details to the software system of Bookedbook, if there is any minor group, they will be allowed to register and get subscription with the help of their parent’s credentials. They will also have to select the type of subscription through which they will be connected to the software. They will have to provide the user ID which they got after the registration process and they get the subscription.

Process 2

As it could be observed from the above diagram that one of the most important processes from the level 0 DFD has been selected and decomposed into explicit level 1 DFD. The process has been replicated which is related to the request of book advertisement. The owner requests books to the content manager and has to provide an ID related to their subscription. The advertisement will be approved after they have got the book ID which will be reviewed by the content manager and they will then receive an author ID.

Process 3>

As it could be observed from the above diagram that one of the most important processes from the level 0 DFD has been selected and decomposed into explicit level 1 DFD. The process in the above is shown related to the administrator of the web based system. It is shown how advertisements are reported to the administrators and the reports are generated.

Task 4: Entity Relationship Diagram

It could be observed from the above that the diagram represents the entity relationship relating to the processes of the system of Bookedbook. There are some of the stakeholders which has been categorized into some level of classification. The above has been shown the relationship between the important stakeholders, the important functions and concepts of the system of Bookedbook. There are some of the stakeholders which has been categorized into some level of classification (Rashkovits&Lavy, 2021). There are the most important actors which has been considered by the web based system of Bookedbook, they are book readers, book owners, book authors, these are some of the actors who are priority of the web based system where they also have some functions and roles to play in the web based system. There is the admin level which are composed with the content manager and the analytical team. The content manager has been determined with the task of approving the request which they will be getting from the user side. The analytical team has been determined with the task of optimizing the data.

The functions and the concepts of the information technology has been simplified with the help of the ERD diagram as it has been represented graphically. It could be noticed that the communication and junctions between he users and members of the system could be clearly seen with immense flexibility (Guibijar, 2018). It could be observed that the users are to provide the respective details such as full name, address, city, state, pin code, phone number, if minor, guardian name, and other contact numbers. Whereas, the book authors have to provide their full name, book details, email ID, and nationality. Which is directly linked to the book owners, who are responsible for the advertisement of the books, they composed with author ID, book ID, and other status. All these are reviewed by the content manager and the launches and other subscription related documents.

Task 5: Identification of Data Base Store
The official website of Bookedbook company, Bookedbook.com is connected to the server of the company which contains all the information and data which is related to the important stakeholders as well as the business process. The database server of the website must have been allocated with a huge amount of storage place as it has to contain a large amount of data. All the small and big details of the process which is ongoing through the website of the Bookedbook company will be stored in the database server. The transaction details which has been made between the user and related author, is to be stored in the database server of the company.

Task 6: Data Base in 3NF

Conclusion
The above report has been carried out for the system analysis and design of Bookedbook company. The following report has been determined with the representation of the entire process which is included in the business process of the company. There has been a creation of website by the authorities of the company, it has been done such that the stakeholders will be able to read, provide content, and the company could gain some amount of subscribers to the website of the company. It has been found that the website would require some contribution from every stakeholder. In the above report, there has been creation of a context data flow diagram such that the boundaries of the information technology software system have been defined in a clearer manner. The report has also provided a data flow diagram for the software system of Bookedbook in a broad manner which has included all the high level contexts. There has been a creation of ERD through which the functions and the concepts of the information technology has been simplified with the help of the ERD diagram as it has been represented graphically, and the communication and junctions between the users and members of the system areclearly defined with immense flexibility. The report has also provided three important processes from the data flow diagram which are then decomposed, providing a clearer view in depth with the help of level 1 diagram.

References
Boudjemline, H., Touahria, M., Boubetra, A., &Kaabeche, H. (2017). Heavyweight extension to the UML class diagram metamodel for modeling context aware systems in ubiquitous computing. International Journal Of Pervasive Computing And Communications, 13(3), 238-251. https://doi.org/10.1108/ijpcc-02-2017-0016
Guibijar, B. (2018). Data Flow Diagram DFD in Developing Online Product Monitoring System OPMS of DTI.Data modelling assignment International Journal Of Trend In Scientific Research And Development, Volume-2(Issue-6), 1-7. https://doi.org/10.31142/ijtsrd18394
Rashkovits, R., &Lavy, I. (2021). Mapping Common Errors in Entity Relationship Diagram Design of Novice Designers. International Journal Of Database Management Systems, 13(1), 1-19. https://doi.org/10.5121/ijdms.2021.13101
Widaryanto, R., Widiyanto, A., &Rifa’i, A. (2017). Prototype Function Flow Diagram (FFD) - Combined Unified Modelling Language with Data Flow Diagram. JurnalKomtika, 1(2), 27-33. https://doi.org/10.31603/komtika.v1i2.1793