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

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

Computer Science CG assignment 6 ,

Follow the attached direction to complete this work. Note: Make sure it Aligns with Rubric Unit 6 Assignment 2 Directions: Timothy Brown vs. the SEC Purpose The Securities and Exchanges Commission (SEC) is a key US federal agency that regulates financial reporting. In this paper, you will explore how the

Microsoft 365Tenant to Tenant Migration Solution

A smooth tenant-to-tenant migration requires more than just moving mailboxes—it demands precision, security, and planning. With the MailsDaddy Cross-Tenant Migration Service, IT teams can execute a flawless cross-tenant mailbox migration that covers emails, attachments, calendars, contacts, and OneDrive data. It’s built for businesses of every size, ensuring the entire Office

CO Data 3

DECISION TREES for Risk Assessment One of the great advantages of decision trees is their  interpretability. The rules learnt for classification are easy for a person to follow, unlike the opaque “black box” of many other methods, such as neural networks. We demonstrate the utility of this using a  German

Computer Science Homework 1

MMIS 671 Homework 1. Constrained Optimization Problems A company produces 3 types of cables: A, B, and C. In-house production costs per foot of cables A, B, and C are $6, $8, and $10, respectively. The production process requires 5 resources: Drawing, Annealing, Stranding, Extrusion, and Assembly. For each resource,