Same name to attributes which are in different tables

Assignment Help Database Management System
Reference no: EM1349542

Q1) When it comes to naming attributes, would you say that it is okay to give different names to the same attribute in different tables? For example, StudentFirstName, TeacherFirstName. Why or why not?

What about giving the same name to attributes that are in different tables but are not the same? For example, "Description" in both a Course table and a Classroom table.

Reference no: EM1349542

Questions Cloud

How to implement a personal organizational change : Who are the stakeholders of these changes and what is the impact if this is not done?
Impact of ratios : A company faces financial pressures from attempting to increase too rapidly. Which of the following ratios would you expect to be impacted the most by these pressures?
Find the potential difference between plates : Attempting to stop on a slippery road, a car moving at 80 skids across road at a 30 angle to its initial motion, coming to a stop in 3.8.
Every new change is resisted by someone : Explain what are several barriers that would prevent the communication of a strategy down through the various levels of an organization?
Same name to attributes which are in different tables : What about giving same name to attributes which are in different tables but are not same? For instance, "Description" in both a Course table and a Classroom table.
Explanation of cash conversion cycle : Assuming a 365-day year, what is the length of its cash conversion cycle?
Explain an unidentified principal : Explain an unidentified principal and Ulani indicates that she is acting as an agent on behalf of an unnamed client
Step-by-step answer to organizational change : Describe in examples instances of the human implications of a major organizational change. Analyze the critical success factors for organizational change from the perspective of managing people
Implications of a flat organizational structure : How would change from a traditional organization hierarchy to a modern flat hierarchy affect the system dynamics of an organization

Reviews

Write a Review

Database Management System Questions & Answers

  Prepare the e-r diagram for the movie database

Energy in the home, personal energy use and home energy efficiency and Efficient use of ‘waste' heat and renewable heat sources

  Explaining unclustered b pus tree index

Suppose you have a table which contains 27,000 data records, and you have unclustered B+ Tree Index on the table.

  Creating erd containing order and customer entity

Create ERD containing Order and Customer entity types connected by 1-M relationship from Customer to Order. Select suiatble relationship name using your common knowledge of intersection.

  Explaining business activity in new is with a database

Assume you manage business activity which needs a new IS with a database. The development team is divided on which DBMS you must use. One faction wishes to use oracle,a second wants to use MtSQL, and a third wants to use SQL server.

  Explain the datawarehouse and data mining concepts

There are six major types of information systems which organisations use in their operations. Discuss how these information systems support managers in their decision making role Explain the datawarehouse and data mining concepts using appropria..

  Demodulator circuits and amplitude modulator

Explain how much the modulating signal power is required to generate 100 percent modulation? What is the approximate center frequency of filter required to pass the lower sideband?

  Write names and e-mail addresses from database

Suppose a database has tables given below. Write the names and e-mail addresses for all customers who have had stove repair which cost more than $50.

  Baxter aviation database

ER diagram for the Baxter Aviation database

  Analysis of a simple case study

VSS has an existing software package that controls its high bay systems and wants to rewrite it. The existing system is written in C and uses C-ISAM files to store data.

  Explaining concept of organizational intelligence

Need a page and half on concept of organizational intelligence. It must specifically talk about organizational intellignece being outcome of organization's efforts to gather store, process and interpret data.

  Explaining views for protecting access by unauthorized users

Why do you believe that views by themselves are insufficient for protecting access by unauthorized users?

  Use cases perform a requirements analysis for the case study

Use Cases Perform a requirements analysis for the Case Study

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd