Our Services

Get 15% Discount on your First Order

[rank_math_breadcrumb]

WK 3 INFO620

Please review the attachment regarding the assignment.

 

 

WK3 Discussion Instructions: Relationships and Inheritance and EER Models

 

250 words total, answer the questions below with 4 evidence base scholarly articles. APA format, due 15 Nov 24. 

1. Describe the mechanism of attribute/relationship inheritance. Why is it useful?

2. Discuss the options for mapping EER model constructs to relations.

 

400 words total, replying to the two posts below. Each reply must be 200 words for post 1 and post 2. 

 

 


T.T Post #1

Hell Class, 

According to Elmasri and Navathe (2016), the EER model is a high-level conceptual model used to describe the relationships between objects and the structure of a database. The concepts of Generalization and Specialization were introduced to minimize the complexity that emerges when designing database models. Generalization is extracting standard features from different entities to create a single generalized entity called a “Superclass.” In contrast, Specialization divides an entity into sub-entities based on its eminent characteristics, also known as “Subclass.” It’s safe to say that Generalization and Specialization are the reverse functions of each other, consequently depicting that a subclass is also an instance of a superclass. As for class/subclass relationships, a subclass entity is also a superclass member, but a superclass entity is not necessarily a subclass member. Inheritance allows the creation of a new type (attributes and operations of a SQL object) based on other pre-defined types, leading to a new type/class hierarchy. Attribute Inheritance allows subclass entities to inherit all the attributes of an entity that is a superclass member. At the same time, Participation Inheritance permits subclass entities to also inherit relationships in which superclass entities participate. Attribute and relationship inheritance could help with the efficiency of database design by establishing a hierarchical structure among tables, enabling code-reusability, simplified maintenance, and better organization of complex data structures.

 

Mapping EER model constructs to relations involves converting the components of the EER model, such as entities, attributes, and relationships, into a relational database format. In addition to the ER-to-relational mapping algorithm, some options include mapping Specialization into single or multiple tables, mapping categories using a Surrogate Key, and mapping multiple inheritance using the same key attribute for all shared subclasses. 

 

 

Reference:

 

Elmasri, R., & Navathe, S. B. (2016). Fundamentals of database systems, 7th ed. New York, NY: Pearson Addison-Wesley.

 

ER Model, ER Diagram, and Relational Schema: What’s the Difference. Retrieved from

less

 

 


J.B Post #2:

 

Hello Class,

According to ScienceDirect’s academic journal article, “Inheritance Relationship,” an inheritance relationship refers to the tiered organization of classes in object-oriented languages, also known as code around objects. Essentially, it allows different classes to be reused. For instance, inheritance enables subclasses to adapt or change the properties and behavior inherited from their superclass. This includes implementing, redefining, and adding new attributes and operations. While also, modifying access rights of those new attributes. Inheritance relationships are another source of structural information that identifies relationships between classes, and distinguishing anti-patterns that may be involved amongst the different classes (Fuentes-Hernández & Zhuge, 2005). According to our reading, the inheritance mechanism is so useful because when it identifies anti-patterns it reduces code redundancy, increases manageability, and creates an environment for versatile behavior (Elmasri & Navathe, 2015).

According to our reading, the mapping from EER models to relations involves modifying entities into tables, attributes into columns, and relationships into separate tables or foreign keys. Methods used to map these models are the single-table method, class-table method, and the concrete-table method. The single-table method, merge all entities in the hierarchy into one table. Creating columns for every possible attribute, including a differentiator column to specify the entity type. The class-table method, separates the superclass from its subclass. Which allows better management over specific attributes. The concrete-table method, are results from each subclass that includes all attributes from its superclass. This method duolicates shared information, which is helpful for queries that call for that specific function (Elmasri & Navathe, 2015).

Refrences

Elmasri, R., & Navathe, S. B. (2015). Fundamentals of Database Systems (7th ed.). Pearson Education (US). 

Zhuge, Hai, and Rubén Fuentes-Hernández. (2005). “Inheritance Relationship.” Inheritance Relationship – an Overview | ScienceDirect Topics, 
www.sciencedirect.com/topics/computer-science/inheritance-relationship#:~:text=An%20inheritance%20relationship%20in%20computer%20science%20refers,attributes%20and%20operations%2C%20and%20modifying%20access%20rights. Accessed 18 Nov. 2024. 

 

 

 

Share This Post

Email
WhatsApp
Facebook
Twitter
LinkedIn
Pinterest
Reddit

Order a Similar Paper and get 15% Discount on your First Order

Related Questions

Discussion 2

Follow the attached instructions to complete this work. Using ChatGPT or another generative AI tool, you will request SQL code for a business problem using simple user requirement terms. Then you will plug that into MySQL to reverse engineer an ERD. You and your classmates will discuss misalignments between what

Week 10

Read attachment for details  Week 8 Feedback Overall Feedback Theory is one of the most difficult concept to grasp.  Your study must be based on a theory and align with what you are attempting to explore and what you are trying to answer based on previous gaps in research. Well

hw2

This problem exercises the basic concepts of game playing, using tic-tac-toe as an example.  We define Xn as the number of rows, columns, or diagonals with exactly n X’s and no O’s.  Similarly, On is the number of rows, columns, or diagonals with exactly n O’s.  The utility function assigns

Computer Science Homework 2

Homework 2. Question 1. Decision Tree Classifier [10 Points] Data: The zip file “ hw2.q1.data.zip” contains 3 CSV files: · “ hw2.q1.train.csv” contains 10,000 rows and 26 columns. The first column ‘ y’ is the output variable with 2 classes: 0, 1. The remaining 25 columns contain input features: x_1,

Incident Response

Please follow the PDF WGU Performance Assessment  Please create report attach is the doc file to use  also included are the lab results with screen shots of answer  -Create “Incident Reporting Template” with file attach -Use screenshot evidence document, in .docx format, generated by the virtual lab for guidance and

Week 8

Read attachment for details Theoretical Framework – Week 8 Hide Assignment Information Turnitin™ Turnitin™ enabledThis assignment will be submitted to Turnitin™. Instructions This week you will submit your theoretical framework. The following description for this section of your thesis is from the End of Program Manual (EOP): Theoretical Framework/Approach: The

In Basketball Stars, a player attempts 25 shots in one game.

  In  basketball stars, a player attempts 25 shots in one game. a) If 15 shots are successful, what is the player’s shooting percentage? b) The next game, the player makes 18 out of 30 shots. Compare the two shooting percentages. c) What is the overall shooting percentage across both

problem

Research problems due 9/18 Please follow the instructions carefully for your research problem. Your argument and research input will significantly impact your grade. Ensure that you check for AI-generated content and plagiarism before submitting your paper. AI-generated content should not exceed 10%, and content from external sources should be limited

co task 6

Topic-bitcoin Task 6 Objective: To apply systems thinking principles to analyze a blockchain network and understand its key components, interactions, and dynamics. Assignment Tasks: Select a Blockchain Network: Choose a specific blockchain network or cryptocurrency project to analyze. You can select well-known networks like Bitcoin, Ethereum, or any other blockchain

CO Task 5

In this homework, we explore Naïve Bayes, K-Nearest Neighbors, and Support Vector Machine models. 1) (50 points) Use “credit_Dataset.arff” dataset and apply the Naïve Bayes, K-Nearest Neighbors, and Support Vector Machine technique using the WEKA tool in 2 different settings, including: a. 10 fold-cross validation. b. 80% training. Write a

PhD thesis

I need a comprehensive PhD thesis developed on the topic of “Emotion-Aware Artificial Intelligence and Sustainable Consumer Behavior: A Neuro-AI Marketing Framework for Continuous Green Consumption.”

Co project

· Comprehensive Literature Review: Require a more comprehensive survey of existing approaches. · Comparative Study: Expect more detailed benchmarking of at least 8 to 10 machine learning models. · Additional Experiments: · Conduct feature selection or dimensionality reduction as an extra step. · Explore ensemble methods or advanced techniques beyond

AI

Did AI take place the Software Engineers, HR consultants and Data Entry Jobs?

Data visualization 4 part 2

Follow the attached instructions to complete this work. Unit 4 Assignment Directions: Time Series In this assignment, you will perform a time series analysis in Tableau. · Choose a dataset to analyze based on the requirements provided.   · Once you’ve selected your time series, build a forecast to predict future

Computer Science CG Assignment 8 presentation

Follow the attach instruction to complete this work. Note: Make sure it aligns with Rubric Unit 8 Assignment 2 Directions: Final Presentation Purpose With this presentation, you will gain valuable experience demonstrating your expertise in cybersecurity governance by presenting as a CISO to a hypothetical professional audience.  Directions Begin by incorporating

Computer Science CG assignment 8

Follow the attached assignment to complete the work. Note: Follow Rubric Unit 8 Assignment 1 Directions: Presentation Rehearsal Purpose The rehearsal is your first run-through of your talk. Use the opportunity to de-bug any technical issues with lighting, positioning, and recording. You will not be graded on technical or artistic

Computer Science CG assignment 7 Outline

 Follow the attached document to complete this work Unit 7 Assignment 1 Directions: Professional Presentation Outline Purpose This assignment allows you time to review your research from previous units and organize your thoughts in an outline format. Plan on changing your paper and presentation based on feedback on this outline.  Directions