Question

which data base type may be identified based on the connection between common attributes in separate...

which data base type may be identified based on the connection between common attributes in separate tables, each containing different types of information?

a) analytical database

b) relational database

c)hierarchical database

d)object-oriented database

Homework Answers

Answer #1

Answer: The correct answer is option b "Relational database"

In the relational database, each table is connected by the common attributes in a separate table we call this a foreign key even though each table is containing different types of information.

Ex:

Student table:

Student(Student_Id, Staudent_name, age, sex)  

Course table:

Course(Student_id, course_name)

Here both the Student and course table contains different information but they are connected by the common attribute student_id.

Analytical database: Analytical database is read-only storage.

Object-oriented database: In object-oriented database data is represented and stored in the form of objects.

Hierarchical database: In a hierarchical database, data is organized in tree-like structure.

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
1. Which of the following is true? a. Marketplaces are seldom attractive to citizen-suppliers who want...
1. Which of the following is true? a. Marketplaces are seldom attractive to citizen-suppliers who want to make use of expensive items they have purchased, that are not regularly used. b. Capital investment, utilities, and maintenance are some of the costs that sharing economy upstarts save over their competitors. c. Highly fragmented markets are seldom ripe for rollup in electronic marketplaces. d. In highly fragmented markets, marketplaces seldom extend their value chain by getting between supplier and customers that would...
1. Which of the following is NOT a type of data anomaly? a. Insertion b. Transformation...
1. Which of the following is NOT a type of data anomaly? a. Insertion b. Transformation c. Deletion d. Modification 2. Functional dependency has the following characteristics EXCEPT a. Attribute Y is functionally dependent upon attribute X, if the value of X uniquely determines the value of Y b. It's a constraint between two tables c. It's a constraint between two attributes (columns) d. Represented as Determinant(s) -> Dependent(s) 3. The definition of a partial dependency is a.One or more...
Florida Now Real Estate (45 pts) Tanya Pierce, President and owner of Florida Now Real Estate...
Florida Now Real Estate (45 pts) Tanya Pierce, President and owner of Florida Now Real Estate is seeking your assistance in designing a database for her business. One of her employees has experience in developing and implementing Access-based systems, but has no experience in conceptual or logical data modeling. So, at this point Tanya only wants you to develop a conceptual data model for her system. You are to use our entity-data diagramming notation - Crows foot symbols. Tanya has...
You are a database consultant with Ace Software, Inc., and have been assigned to develop a...
You are a database consultant with Ace Software, Inc., and have been assigned to develop a database for the Mom and Pop Johnson video store in town. Mom and Pop have been keeping their records of videos and DVDs purchased from distributors and rented to customers in stacks of invoices and piles of rental forms for years. They have finally decided to automate their record keeping with a relational database. You sit down with Mom and Pop to discuss their...
Draw an E-R diagram pls Required Data The data items required for the train reservation database...
Draw an E-R diagram pls Required Data The data items required for the train reservation database can be classified into six categories: trains, stations, train schedules, reservations, customers and employees. The above classification does not imply any particular table arrangement. You are responsible for arranging the data items into tables, determining the relationships among tables and identifying the key attributes. Finally, you should specify and enforce integrity constraints on the data, including referential integrity constraints. You will first create an...
Question 2 The questions in this section are all based on the “Online Book Exchange System...
Question 2 The questions in this section are all based on the “Online Book Exchange System (EyesHaveIt.com)” Case Study on the last page of this document. Read the case study carefully before answering these questions. b) An analyst has identified all the domain classes and their attributes required for the system, as listed below. Use ONLY the classes in this list to draw a Class diagram. The diagram must show all the classes, their attributes, and the relationships between the...
1.  Which of the following is not a consideration in segment reporting for diversified companies? a. Consolidation...
1.  Which of the following is not a consideration in segment reporting for diversified companies? a. Consolidation policy. b. Defining the segments. c. Transfer pricing. d. Allocation of joint costs. 2.  Cream Company operates in three different industries, each of which is appropriately regarded as a reportable segment. Segment No. 1 contributed 60% of Cream Company's total sales. Sales for Segment No. 1 were $450,000 and traceable costs were $200,000. Total common costs for Cream were $300,000. Cream allocates common costs on...
When is a hypothesis considered scientific? a. when it is based on something other than observation...
When is a hypothesis considered scientific? a. when it is based on something other than observation b. when it can be tested and is refutable c. when it relies on anecdotal evidence d. when it relies on mystical explanations e. All hypotheses are considered scientific until experiments determine otherwise. 3. Of the following, which is the earliest step in the scientific process? a. generating a hypothesis b. analyzing data c. conducting an experiment d. drawing a conclusion e. developing a...
Area 4: Management Please answer the following questions in a succinct and concise manner. Each answer...
Area 4: Management Please answer the following questions in a succinct and concise manner. Each answer should yield about 3-5 sentences. How would you explain the difference between Transactional and transformational leaders? Describe the major functions of Managers. Define SWOT analysis and explain how to apply it in a business situation or setting. Area 5: Management Information Systems Please answer the following questions in a succinct and concise manner. Each answer should yield about 3-5 sentences. What are the two...
Question 1) Which of the following are considered valid criticisms of the legalistic model of crime...
Question 1) Which of the following are considered valid criticisms of the legalistic model of crime and criminology? a. Law in action departs substantially from the ideal behavior of the law. b. Focusing only on legally criminalized behavior makes it impossible to consider the impact of gender, race, age and ethnicity. c. Legalistic definitions ignore acts that cause great harm. d. The legalistic model suggests that these are absolute standards for judging right and wrong. e. All of the above....