Posts

Showing posts from March, 2023

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

Image
 I created this diagram using DRAW.IO. The entities include ORDER, PRODUCT with their attributes marked inside the cardinality ratios that are also marked using the figure that was showed and I also used the diamond to show the relationships between the entities.

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

Image
  Definition of an ERD  Entity Relationship Diagram, or ER Diagram for short, is a diagram that shows the connections between entity groups that are kept in databases. To put it another way, ER diagrams assist in describing the rational organization of databases. Three fundamental ideas are used to make ER diagrams: things, characteristics, and connections (Peterson, 2022) RED related terms: ENTITY: An entity, which stores data in the database, can be a location, person, object, event, or concept. Entity characteristics must have a property and a distinctive key. Each "attribute" that makes up an entity serves to symbolize it. ATTRIBUTE: It is either a single-valued entity or relationship type attribute. RELATIONSHIP: The definition of a relationship is simply the association of two or more things. Tom, for instance, works in the Chemistry division. CARDINALITY: The definition of the word "cardinality" differs marginally in the context of databases, though. Cardinal

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

Image
A database is a collection of data that has been organized to make it simple to handle and update. A collection of data records or files, such as sales transactions, customer information, financial data, and product information, are usually kept in computer databases (Lutkevich, 2023) Definition of database from what I think: A database is an organized collection of data and information that are stored. Advantages of Database:    1Improves staff productivity and data sharing. 2. No duplicate material 3. Increases the data's protection and privacy. 4. Presents the overall view. 5. Improves your capacity to boost earnings. 6. Assures data integrity 7. Dependable storage and restoration 8. Makes your marketing more effective generally and guarantees better customer service.  (Valcheva, 2020) Database concepts: Primary Key: A table's primary key is used to uniquely identify each entry. (Gallagher, 2022) Foreign key: A foreign key connects records between two tables in a database. (

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

Image
 Hello, in this blog I would want to show my progress on database and the screenshots. moreover, I used MS Excel to create it. My progress: 1. I started by using the title of the database. All I did was to type and write it.  2. And then I changed the color to green. To change the color or to use color I went to HOME first then went to the font section After then I clicked on the LETTER A that indicates the color when you place the arrow of your mouse on top of it.  3. After then I wrote the titles in each category, I also made the texts bigger. 4. After all that I ensured that all the information was there. 5.Finally, I added all border to make it even more presentable and better. this is the final look.