Posts

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

Image
   Screenshot of product database with 10 entries using MS Excel  

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

Image
 ERD for my e-commerce website database

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

Image
  Entity-Relationship A database or information system's structure can be modelled and described using a diagram. It aids in comprehending how data is arranged and the connections between various system elements. In order to plan and record database structures, ERDs are frequently used in database design and development. Entities The essential building elements of a database system's representation of actual things, ideas, or entities are known as entities in the context of database design. These things, which are frequently nouns, act as data storage and organisation units. A company database may contain the following entities: "Customer," "Product," "Employee," and "Order." Attributes The qualities or traits attached to entities are known as attributes, and they specify the types of data that may be stored by each object. An entity's attributes are used to specify the specific information that relates to it. For example, the "C...

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

Image
  Screenshot of customer database with 10 entries using MS Excel  

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

Image
Database Introduction  Data is actual information about any object in various format for example, your name, age, weight, etc. are some data related to you. Image, file, pdf, etc. are also data. A database is a systematic collection of data that is organized and stored in a way that allows efficient data storage, retrieval, manipulation, and management.  Databases are essential tools for businesses, organizations, and individuals to store and manage large volumes of structured and sometimes unstructured data. They provide a systematic way to manage data and ensure data integrity, consistency, and security. For instance, Facebook stores, manipulates, and present data to give suggestions of friend. For advertisement, and a lot more. Peterson (2023).   Advantages of Databases: It can be stored and retrieved in various techniques. It minimises the data redundancy. It balances the needs of multiple applications using the same data. It has uniform administration procedu...

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
  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 Introduction In today's world, software plays a crucial role in society, driving numerous industries and facilitating intricate tasks. The Software Development Life Cycle (SDLC) offers a structured approach to software creation, guaranteeing efficiency, excellence, and predictability at every stage of the development process. This article delves into the different methodologies encompassed within the SDLC, highlighting their respective benefits and outlining the key phases that form the journey of software development.  Arora (2016) Within the realm of software development, there exist various methodologies that encompass the Software Development Life Cycle (SDLC), each offering its own unique approach to managing the process. These methodologies encompass:   Methodologies The planni...