Database Design proposal. IT & Computer Science Essay
In the final phase of the Database Design Proposal assignment, you are required to design a working prototype of the proposal. You will be required to utilize SQLite Database.
The SQLite database is a small, lightweight database application, suited for learning SQL and database concepts, or to just explore some database-related ideas without requiring a full-blown database management system (DBMS). Refer to "Supplement: SQL Examples for SQLite Database," for the link to the SQLite Database download and examples.
The working prototype should include the following:
Provide a brief synopsis (utilizing research from related assignments) analyzing the detailed requirements of your prototype database design and how it would be used to support data warehousing, reporting and mining
Design a database prototype that includes diagrams, data dictionary, design decisions, limitations, etc. The database should consist of at least four tables, two different user roles, and two reports.
Database Design Proposal
Student Name
Institutional Affiliations
Database Design Proposal
Synopsis
SQLite is a relational database management system found in a C library. It usually implements fast, small, high-reliability, self-contained, and full-featured engines (Bonawitz, Eichner, Grieskamp, Huba, Ingerman, Ivanov, & Van Overveldt, 2019). It is the most used type of database in the world. It is usually built into most computers and all mobile phones, and it is contained in other applications that are commonly used by people daily. The main reason for the preference of the SQLite file format is that it is cross-platform, stable, and also backward compatible (Jonas, Schleier-Smith, Sreekanti, Tsai, Khandelwal, Pu, & Gonzalez, 2019). Its usability and reliability in this format have led to developers pledging to ensure that it remains that way until at least 2050. Such files find common uses as containers for transferring rich content between different systems. Further, the source code is available in the public domain, and anyone can use it for free for any purpose (Lenarduzzi, Saarimäki, & Taibi, 2019). SQLite is used for creating databases and prototypes of such systems as a bank account database.
Prototype Database Design Created
In this exercise, an online tool was used to create the required prototype, with the necessary features to ensure its functionality so that it supports data reporting, warehousing, and mining (Nemetz, Schmitt, & Freiling, 2018). The prototype diagram below shows the user-created data dictionary, user reports (2), tables (2), and entered the data fields appropriately. Arrows are used in this case to the design decisions taken to show the interconnection between the elements to each other. Further, the arrows indicate the dependency between each of the tables and records. One can interpret the interdependency of the tables and files by considering the direction to and from which the arrow points.
A constraint was also added to the prototype design to ensure the restriction of specific fields to provide protection and retention of data integrity and ensure the database tables are connected (Clemencic, 2019). Data types were chosen depending on their appropriateness to each of the attributes to enhance the functionality and effectiveness of the prototype design, before filling in the input data appropriately to ensure that it was available and t...
You Might Also Like Other Topics Related to scientific essays:
- Philosophers who focus on environmental ethics. Social Sciences Essay2 pages/≈550 words | MLA | Social Sciences | Essay |
- Identity and Cognitive Dissonance Social Sciences Essay5 pages/≈1375 words | APA | Social Sciences | Essay |
- When does deterrence succeed Social Sciences Research Paper18 pages/≈4950 words | Other | Social Sciences | Research Paper |
- Socioecological System analysis Social Sciences Essay1 page/≈275 words | APA | Social Sciences | Essay |
- Squirrels' Evolution Biological & Biomedical Sciences Essay2 pages/≈550 words | MLA | Biological & Biomedical Sciences | Essay |
- Service Learning Social Sciences Term Paper Research4 pages/≈1100 words | APA | Social Sciences | Term Paper |
- Development of Social Thought Social Sciences Essay2 pages/≈550 words | APA | Social Sciences | Essay |