{"id":1221,"date":"2023-04-13T15:23:08","date_gmt":"2023-04-13T14:23:08","guid":{"rendered":"https:\/\/blogs.glowscotland.org.uk\/es\/software\/?page_id=1221"},"modified":"2023-04-13T15:26:53","modified_gmt":"2023-04-13T14:26:53","slug":"database-analysis","status":"publish","type":"page","link":"https:\/\/blogs.glowscotland.org.uk\/es\/software\/data-modelling\/database-analysis\/","title":{"rendered":"Database analysis"},"content":{"rendered":"\n<p>During the analysis phase of creating a database you need to examine:<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>End user requirements<\/li><li>Functional requirements<\/li><\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">End user requirements<\/h2>\n\n\n\n<p>End user requirements are the tasks that the end user of the database wants to perform on it.<\/p>\n\n\n\n<p>You could ask a sample group of end users what they need to system to provide to get an idea of the inputs, outputs and processes that you will need for the database.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Functional requirements<\/h2>\n\n\n\n<p>Functional requirements are the tasks that the database will need to perform.<\/p>\n\n\n\n<p>Based on the end user requirements you can work out the tables and fields required.<\/p>\n\n\n\n<p>Then you can work out the following:<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>What input forms are required to add a new entity.<\/li><li>What processes are needed to query the data.<\/li><li>That reports are needed to view the data.<\/li><\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">Example<\/h2>\n\n\n\n<p>A garage wants a database to manage their customer details. What might each of the following want from the system:<\/p>\n\n\n\n<div class=\"wp-block-columns is-layout-flex wp-container-core-columns-is-layout-9d6595d7 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<h3 class=\"wp-block-heading\">Receptionist<\/h3>\n\n\n\n<ul class=\"wp-block-list\"><li>Enter new customer details<\/li><li>Enter new vehicle details<\/li><li>Search for customer details by name or vehicle registration<\/li><li>Edit customer details<\/li><\/ul>\n<\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<h3 class=\"wp-block-heading\">Mechanic<\/h3>\n\n\n\n<ul class=\"wp-block-list\"><li>Search for vehicle details and notes<\/li><li>Add new note to vehicle<\/li><\/ul>\n<\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<h3 class=\"wp-block-heading\">Accountant<\/h3>\n\n\n\n<ul class=\"wp-block-list\"><li>Enter new invoice<\/li><li>View invoices over dates<\/li><\/ul>\n<\/div>\n<\/div>\n\n\n\n<p>Take your end user requirements and use them to come up with a list of input forms, processes and output views\/reports.<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"350\" src=\"https:\/\/blogs.glowscotland.org.uk\/es\/public\/software\/uploads\/sites\/4063\/2023\/04\/13152537\/DB10-1024x350-1.png\" alt=\"Example requirements table\" class=\"wp-image-1225\" srcset=\"https:\/\/blogs.glowscotland.org.uk\/es\/public\/software\/uploads\/sites\/4063\/2023\/04\/13152537\/DB10-1024x350-1.png 1024w, https:\/\/blogs.glowscotland.org.uk\/es\/public\/software\/uploads\/sites\/4063\/2023\/04\/13152537\/DB10-1024x350-1-300x103.png 300w, https:\/\/blogs.glowscotland.org.uk\/es\/public\/software\/uploads\/sites\/4063\/2023\/04\/13152537\/DB10-1024x350-1-768x263.png 768w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><figcaption>Example requirements table<\/figcaption><\/figure><\/div>\n\n\n\n<p class=\"nextlink\"><a href=\"https:\/\/blogs.glowscotland.org.uk\/es\/software\/data-modelling\/database-design\/\" data-type=\"page\" data-id=\"1226\">Next: Database design<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>During the analysis phase of creating a database you need to examine: End user requirements Functional requirements End user requirements End user requirements are the tasks that the end user of the database wants to perform on it. You could ask a sample group of end users what they need to system to provide to&hellip; <a class=\"more-link\" href=\"https:\/\/blogs.glowscotland.org.uk\/es\/software\/data-modelling\/database-analysis\/\">Continue reading <span class=\"screen-reader-text\">Database analysis<\/span><\/a><\/p>\n","protected":false},"author":5710,"featured_media":0,"parent":1179,"menu_order":2,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-1221","page","type-page","status-publish","hentry","entry"],"_links":{"self":[{"href":"https:\/\/blogs.glowscotland.org.uk\/es\/software\/wp-json\/wp\/v2\/pages\/1221","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blogs.glowscotland.org.uk\/es\/software\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/blogs.glowscotland.org.uk\/es\/software\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/blogs.glowscotland.org.uk\/es\/software\/wp-json\/wp\/v2\/users\/5710"}],"replies":[{"embeddable":true,"href":"https:\/\/blogs.glowscotland.org.uk\/es\/software\/wp-json\/wp\/v2\/comments?post=1221"}],"version-history":[{"count":3,"href":"https:\/\/blogs.glowscotland.org.uk\/es\/software\/wp-json\/wp\/v2\/pages\/1221\/revisions"}],"predecessor-version":[{"id":1228,"href":"https:\/\/blogs.glowscotland.org.uk\/es\/software\/wp-json\/wp\/v2\/pages\/1221\/revisions\/1228"}],"up":[{"embeddable":true,"href":"https:\/\/blogs.glowscotland.org.uk\/es\/software\/wp-json\/wp\/v2\/pages\/1179"}],"wp:attachment":[{"href":"https:\/\/blogs.glowscotland.org.uk\/es\/software\/wp-json\/wp\/v2\/media?parent=1221"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}