Posts

What is an ERD. Define the RED related terms, including entities, attributes, cardinalities and relationships

Image
Entity Relationship Diagram (ERD) An entity relationship diagram (ERD), also known as an entity relationship model, is a graphical representation that depicts relationships between objects, places, concepts, or events within an information technology (IT) system. An ERD uses data modelling approaches to build business processes and lay the foundation for a relational database (Biscobing, 2019). Entity relationship diagrams assist establish the requirements for an organization's information systems and provide a visual starting point for database architecture. When a relational database has been implemented, an ERD can still be utilised as a reference in the event that additional debugging or re-engineering of business processes is necessary. An ERD can assist in the organisation of data that can be represented by a relational structure, but it cannot effectively represent semi-structured or unstructured data. Also, it is unlikely to be helpful on its own in integrating data into an...
Post a Comment
Read more

Using MS Excel, create a customer database with at least 10 entries, with screenshots to document and show your progress

Image
  (freepik.com, 2020) What is customer database? A customer database is a repository of data that contains lead contact information such first and last names, phone numbers, email addresses, etc. There are various purposes for customer databases. They can be applied strategically to develop customer journey maps, sales funnels, critical account profiles, and buyer personas (Zhostka, 2022) . A customer database in Microsoft Excel might include customer related information, for example, Customer ID, First Name, Last Name, Email, Phone Number, and, Address. What is Product database? A product database is an organised collection of information about a product that is electronically maintained and stored. These facts are known as product specs. They include a wide range of data, including the product name, weight, internal and external references, ingredients, raw materials, packaging, supplier, official labels, labelling information, and more (inno-foodproducts-brainbox.com, 2021)...
Post a Comment
Read more

Create an ERD for your website database. Identify the entities, attributes, relationships and cardinalities

Image
Draw.io (formerly known as diagrams.net) is a free, online diagramming and flowcharting application. It allows users to create diagrams, flowcharts, whiteboards, org charts, mind maps, network diagrams, UML diagrams, and more. It is easy to use and can be used for both personal and professional purposes. Draw.io is a great tool for business analysts, as it allows them to create diagrams and flowcharts to help visualize and document their processes. The BA Guide has a great tutorial on how to use draw.io to create a network diagram for free. Draw.io has a comprehensive collection of video tutorials to help users get up and running quickly. It also has a wide range of shape tools and color options to help users create diagrams that are visually appealing. Additionally, draw.io allows users to collaborate in real-time with their team and save their work in the cloud (draw.io, 2022). ERD of website database   Reference Tutorials (2022) draw.io . Available at: https://drawio-app.c...
Post a Comment
Read more

Write about your understanding of databases. Explore the database advantages and write about database concepts such as primary and foreign keys

Image
(freepik.com, 2018) Database A database is an organized collection of structured information or data, usually stored electronically in a computer system. A database is usually managed by a database management system, "DBMS". controlled. Data and his DBMS and related applications are collectively called a database system, often abbreviated simply as database. Data in the most common types of databases in operation today are typically modeled as rows and columns in a series of tables to streamline processing and data retrieval. You can then easily access, manage, modify, update, control and organize your data. Most databases use Structured Query Language (SQL) to write and query data(Oracle.com, 2023).   Databases have evolved dramatically since their birth in the early 1960s. Navigational databases such as hierarchical databases (based on a tree-like model ...
Post a Comment
Read more

Research about SDLC, discussing it's methodology, benefits and key stages. Comment on activities you have conducted during your website development that correlates with the stages

Image
The SDLC or software development life cycle is the process of creating software with the highest quality and lowest cost in the shortest amount of time. The SDLC provides a well-structured flow of phases that help companies rapidly create quality, well-tested, production-ready software.     SDLC reduces software development costs while improving quality and reducing production time. SDLC achieves these seemingly different goals by following a plan that eliminates the typical pitfalls of software development projects. This plan begins with an assessment of existing systems for deficiencies. Next, define the requirements for your new system. We then build the software through the analysis, planning, design, development, testing, and deployment phases. By anticipating costly mistakes such as the following, for example, SLDC can eliminate unnecessary rework and ...
Post a Comment
Read more