Written Assignement Unit-1

docx

School

University of the People *

*We aren’t endorsed by this school

Course

5210

Subject

Computer Science

Date

Nov 24, 2024

Type

docx

Pages

8

Uploaded by UltraChinchilla1269

Report
MSIT 5210 - Written Assignment Unit 1 1 Relationships Between Tables MSIT-5210 Written Assignment 1 University of The People
MSIT 5210 - Written Assignment Unit 1 Abstract This paper aims to examine a key concept in database design - relational databases. A database relationship will be defined, tools used to build a relational structure will be covered, a database diagram and design, anatomy of a database relationship, and tools used to construct a relational structure. In conclusion, the reader should understand why we use relational databases, how they are created at a high level, and how to visualize them.
MSIT 5210 - Written Assignment Unit 1 What is a Database Relationship? The term "database relationships" refers to associations between tables that are created using join statements in order to retrieve data from the database (IBM, 2022). In order to establish a relationship between two database tables, one table must use a foreign key that refers to the primary key of the other table. Essentially, this is what relational databases are all about. (Chapple, 2022). In a relational database, there are typically three types of relationships. The following is an overview of each. One-to-One One-to-one relationships are relationships where each table has only one matching row in the other table. When a one-to-one relationship (1:1) exists in a database, each side of the relationship has a record. In order for a foreign key to be unique, it must relate to only one entry from another table. Typically, one-to-one relationships are the result of enforced business rules. A one-to-one relationship between two tables does not violate normalization rules (Phoenixnap, 2022). Figure 1 . One-to-One Relationship (Database.guide, 2022)
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
MSIT 5210 - Written Assignment Unit 1 One-to-Many Relationship in a Database . One-to-many (1: N) relationships in databases have a single entry on one side and multiple entries on the other. One or more records from another table are associated with every primary key. Foreign keys are not unique in this case. The one-to-many relationship is a natural one, and often appears in database modeling as a logical connection (Phoenixnap, 2022). Figure 2 . One-to-Many Relationship (Database.guide, 2022) Many-to-Many Relationship in a Database Typically, many-to-many (N: N) relationships exist in a database where both ends of the relationship have multiple entries. In order to solve this problem, many entries may exist on both ends, so a standard solution is to create an association table (joint) that contains foreign keys from both tables. In relational databases that are implemented in web technologies, such as ecommerce websites, many-to-many relationships are a common practice (Phoenixnap, 2022).
MSIT 5210 - Written Assignment Unit 1 Figure 3 . Many-to-Many Relationship (Database.guide, 2022) Database Diagrams and the tools available to build that structure. The database diagram is a graphic representation of how the database is structured and the relationship between the objects in the database. There are three types of diagrams you can create: a diagram for a data source, a schema, and a table diagram. Consider using foreign keys and primary keys in order to create relationships between database objects. (PhpStorm Help, 2022). Endpoints, line styles, and related tables provide the basis for defining relationships in a database diagram (Microsoft Press, n.d.). An endpoint indicates a 1:1 or a 1: many relationships. Referential integrity is enforced by line styles. A primary: foreign key pair indicates whether two tables are related (Microsoft Press, nd). Identification of tables, key pairs, and relationships is necessary to create a database diagram. Flow charts should be used to visually represent these once they have been identified. Visualization can be made easy with tools such as Visio or LucidChart. Upon first glance, a database diagram, also known as an ER Diagram (Entity Relation Diagram), appears to be very similar to a flowchart, and it is very true. In spite of this, the ER
MSIT 5210 - Written Assignment Unit 1 Diagram contains many specialized symbols, and the meanings of these symbols make this model unique. In the ER Diagram, the purpose is to represent the entity framework infrastructure as a whole. Figure 4 . Entity Relationship Diagram Example (Guru99, 2022)
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
MSIT 5210 - Written Assignment Unit 1 Conclusion Relationships between databases are one of the most essential functions of database management. By using them, we can reduce the size of the tables, improve information security and access control, and enhance data integrity and linkages. The possibility of sequestering private information such as credit card numbers and social security numbers would be nearly impossible without the existence of database relationships. In addition, having to keep all the information related to a specific data set in a single database table would also result in a large and unwieldy database. The key to managing a database effectively is to have a thorough understanding of relational database theory.
MSIT 5210 - Written Assignment Unit 1 References Chapple, M. (2022). Relationships Are the Basis for Relational Databases. Retrieved 6 September 2022, from https://www.lifewire.com/database-relationships-p2-1019758 Database.guide. (2022). Database Relationships Explained. Retrieved 7 September 2022, from https://database.guide/database-relationships-explained/ Guru99. (2022). Entity Relationship (ER) Diagram Model with DBMS Example. Retrieved 7 September 2022, from https://www.guru99.com/er-diagram-tutorial-dbms.html IBM. (2022). IBM Documentation. Retrieved 6 September 2022, from https://www.ibm.com/docs/en/control-desk/7.6.0?topic=structure-database-relationships Microsoft Press. (n.d.). Design database diagrams - visual database tools. Design Database Diagrams - Visual Database Tools | Microsoft Docs. Retrieved April 7, 2022, https://docs.microsoft.com/en-us/sql/ssms/visual-db-tools/design-database-diagramsvisual- database-tools?view=sql-server-ver15 Phoenixnap. (2022). Database Relationship Types & How They Are Established | phoenixNAP KB. Retrieved 6 September 2022, from https://phoenixnap.com/kb/database- relationships

Related Documents

Project Three - Questions.pptx
Project 0 | CS 188 Spring 2023.pdf
SAP Back-End Developer - ABAP Cloud C_ABAPD_2309 Dumps.pdf
ecc.py
guessingGame.rtf
Lab 4.pdf
HW 09.pdf
disc12-regular.pdf
Assignment 001 - (8).png
Ahan_Shah_-_Create_PT_-_Survival_Guide_2021
Introduction to R Programming.docx
Screenshot 2023-11-01 at 1.47.41 PM.png
Recommended textbooks for you
Text book image
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781305627482
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Text book image
A Guide to SQL
Computer Science
ISBN:9781111527273
Author:Philip J. Pratt
Publisher:Course Technology Ptr
Text book image
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781285196145
Author:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:Cengage Learning
Text book image
Principles of Information Systems (MindTap Course...
Computer Science
ISBN:9781305971776
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning
Text book image
Principles of Information Systems (MindTap Course...
Computer Science
ISBN:9781285867168
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning
SEE MORE TEXTBOOKS
Recommended textbooks for you
Text book image
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781305627482
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Text book image
A Guide to SQL
Computer Science
ISBN:9781111527273
Author:Philip J. Pratt
Publisher:Course Technology Ptr
Text book image
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781285196145
Author:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:Cengage Learning
Text book image
Principles of Information Systems (MindTap Course...
Computer Science
ISBN:9781305971776
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning
Text book image
Principles of Information Systems (MindTap Course...
Computer Science
ISBN:9781285867168
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning
SEE MORE TEXTBOOKS