100%(3)3 out of 3 people found this document helpful
This preview shows page 1 - 3 out of 7 pages.
DBFN212 Assessment 4Database FundamentalsIntroductionA database denotes an assortment of information that is classically stored by electronic means ona computer. Primarily, databases are managed by DBMS (database management system), whicha cluster of programs that maintains database edifice and regulates access to data. Manydatabases are designed on a huge number of columns and rows to process and query records inthe current era proficiently.BackgroundThe context critiques the numerous features of databases, including data models and SQL. Someof the enormous databases can be complex to analyze since they may assume different meanings.Content AnalysisWeek 1: The Database ApproachTheoretical DiscussionData denotes raw facts, and information is the outcome of processing data to expose its meaning.Database refers to shared, incorporated computer edifice that saves raw facts (end-use data) andmetadata. The database tool is implemented to generate and present data for a definite motive.DBMS is a software program that collects and saves clients' data while considering the propersafety measures. Besides, the data management systems were designed to counter the latentweaknesses in file systems.Reflection on the ContentIn the current era, databases play a pivotal role since we interact with them in the different arraysof our daily lives. For instance, databases are utilized in various day-to-day operations such asbanks, grocery shops, employee records, supermarkets, online shopping websites, hotels, tickets,and bookings. However, some extensive databases may be troublesome to analyze, and one canerroneously interpret the data leading to data redundancy.OutcomeA well-made database simplifies data management and produces precise and valuable data. Incontrast, an incompetently built database can transpire to depraved decision making, which canfurther lead to collapsing of a business venture. The database management system aims atprocessing data and relieves the user of the task off intricate report articulation. The systemcarries out functions that certify honesty and uniformity of data, including dictionarymaintenance, transformation and representation of data, storage, and security maintenance.Week 2: Data ModelsTheoretical Discussion
Data models are comparatively simple representations of intricate real-world data arrays(typically in graphical form). Data models enable an interface between the designer, theprogrammer, and the end-user. The model categorizes the data to suit the different users sinceusers always have varying opinions and needs for data. The building blocks of data modelsinclude constraints, attributes, entities, and relationships. The emerging trends in technology,such as the internet, have substantially advanced the scope of database systems.