How to represent derived attributes in database?

Answers

Answer 1

Answer:

Derived attribute can be defined as a type of attribute where its value will be derived from one or more of the other attributes of the same entity set.

Explanation:

An example of derived attribute is when we have an entity set called General. The set then has attributes like [Form], [Characteristics], [Address}, (Employment No).

(Employment No) which is represented distinctly in the attribute set can be called a derived attribute if it can be derived from one or more of the other attributes.

Derived attribute can be gotten through calculating values and not storing values.

For example, let us consider the following record of Teachers records;

(‘Teacher Number’, ‘Name’, ’Date of Birth’, Age today)

(‘E105’, ‘Samson’, ’07-Dec-1990’, 0)

This record shows that the teacher Samson was born on 7th of December, 1990. At the time of record insertion, he was born and 0 years old. What will be the value of his age on ’07-Dec-2000’? It is about 10 years. It clearly shows that the value is not fixed and it is a variable whenever the DOB is adjusted.

Therefore, we are not creating our table with derived attributes in it. Instead, the values ofderived attributes can be calculated at the time of retrieval and shown to the user. Hence, the record will look like as follows;

(‘E105’, ‘Samson’, ’07-Dec-1990’)

This means that 0 is a derived attribute from the Date of birth.


Related Questions

Assume that IBM has a relatively low unit market share for blockchain technology and that the blockchain technology industry’s growth rate is extremely high (averaging 30% per year). Using the BCG business portfolio analysis framework, blockchain technology would be classified as a ________ SBU for IBM.

Answers

Answer:

The blockchain technology would be classified as a Question Mark strategic business unit (SBU)

Explanation:

The Boston Consulting Group Matrix was first developed towards the end of the nineteenth century for use in analysing the performance and classifying products and business units.

This tool is still very relevant today.

The Matrix is made up of four quadrants:

Top Left - Question Mark

Top Right - Star

Bottom Left -  Dog

Bottom Right -  Cashcow

A Question Mark product or business unit is one which at the onset has a very little market share in an environment with a high growth rate. It is at the onset also characterised by losses and will need more time and money for it to bloom. If invested and nurtured can become a start and then a cash cow. There is also a risk that it will end up a white elephant business unit or product if it is not nurtured properly thus leading to losses.

Cheers!

Which command displays the contents of the NVRAM?

Answers

Answer:

Explanation:

NVRAM (nonvolatile random-access memory) is a small amount of memory that your Mac uses to store certain settings and access them quickly. And to show the content of the NVRAM

Show startup-config will display NVRAM content

All the sentences below are missing one or more commas. By placing commas in the correct places, complete the following ten-question exercise. You may use The Writer' Reference handbook if needed.
1. Parents once automatically gave their children the father's surname but some no longer do.
2. Italians insist that Marco Polo the thirteenth-century explorer did not import pasta from China.
3. Prices having risen rapidly the government debated a price freeze.
4. A price rise unlike a rise in interest rates seemed a sure solution.
5. Shoes with high heels originated to protect feet from the mud garbage and animal waste in the streets.
6. The festival will hold a benefit dinner and performance on March 10 2011 in Ashville.
7. "In coming to a new land" says writing teacher Peter Elbow "you develop a new conception of what you are writing about."
8. Mr. Spock as chief science officer is also Captain Kirk's closest friend.
9. The quarterback told the tight end to sprint five yards juke to the inside then break for the right sideline.
10. Fielding the ball on three hops the shortstop fired a strike to first base for the final out.

Answers

Answer:

1. Parents once automatically gave their children the father's surname, but some no longer do.

2. Italians insist Marco Polo, the thirteenth-century explorer did not import pasta from China.

3. Prices, having risen rapidly, the government debated a price freeze.

4. A price rise, unlike a rise in interest rates, seemed a sure solution.

5. Shoes with high heels originated to protect feet from the mud, garbage, and animal waste in the streets.  

6. The festival will hold a benefit dinner, and performance on March 10, 2011, in Ashville.

7. "In coming to a new land," says writing teacher Peter Elbow, "you develop a new conception of what you are writing about."

8. Mr. Spock, as chief science officer, is also Captain Kirk's closest friend.

9. The quarterback told the tight end to sprint five yards juke to the inside, then break for the right sideline.

10. Fielding the ball on three hops, the shortstop fired a strike to first base for the final out.

The corrected sentences are :
1. Parents once automatically gave their children the father's surname, but some no longer do.

2. Italians insist Marco Polo, the thirteenth-century explorer did not import pasta from China.

3. Prices, having risen rapidly, the government debated a price freeze.

4. A price rise, unlike a rise in interest rates, seemed a sure solution.

5. Shoes with high heels originated to protect feet from the mud, garbage, and animal waste in the streets.  

6. The festival will hold a benefit dinner, and performance on March 10, 2011, in Ashville.

7. "In coming to a new land," says writing teacher Peter Elbow, "you develop a new conception of what you are writing about."

8. Mr. Spock, as chief science officer, is also Captain Kirk's closest friend.

9. The quarterback told the tight end to sprint five yards juke to the inside, then break for the right sideline.

10. Fielding the ball on three hops, the shortstop fired a strike to first base for the final out.

Why is punctuation crucial in sentence construction?

Punctuation is crucial in sentence construction because it helps convey meaning, clarify relationships between words and phrases, and create a clear and coherent flow of information.

Here are the places where the commas were placed -

Placed a comma after "surname" and before "but" to separate two independent clauses.Placed a comma after "explorer" to set off a non-essential phrase.Placed a comma after "rapidly" to indicate an introductory adverbial phrase.Placed commas before and after "unlike a rise in interest rates" as it's a non-restrictive clause.Placed commas after "mud" and "garbage" to separate items in a series.Placed a comma after "2011" to indicate the year in the date.Placed commas before and after "says writing teacher Peter Elbow" as it's a non-essential clause.Placed commas before and after "as chief science officer" to set off a non-restrictive phrase.Placed commas after "yards" and "inside" to separate items in a series.Placed a comma after "hops" to indicate an introductory participial phrase.

Learn more about sentences  at:

https://brainly.com/question/552895

#SPJ2

Multiple Single SNMP managers are communicating with a single SNMP agent in:_____.

Answers

Answer:

many-to-many

Explanation:

Many-to-Many Communication is a term that describes a form of online or over the internet communication whereby numerous users are sending and receiving information, in such a way that the recipient does not have the idea of who the receiver is, and neither does the receiver know who the sender is, even though the information facets frequently connects through various websites.

Hence, Multiple Single SNMP managers are communicating with a single SNMP agent in "many-to-many communication."

Which Compatibility Modes setting is available for Photoshop?

Answers

Answer:

k

Explanation:

In this assignment, you will write a Python 3.x program to calculate the length of the hypotenuse (side C) of a right triangle, given the lengths of the other two sides (A & B) as provided by the user. The program will also calculate the area of the triangle and the perimeter (the sum of the three sides). Other specifications: WRITE THE CODE FOR THE ANSWER.

Answers

Answer:

Explanation:

from math import hypot #import hypot for finding the hypotenuse

a = int(input("Enter a value for a: " )

b = int(input("Enter a value for b: " )

def find_hypotenuse(a,b):

return hypot(a,b) #find the hypotenuse

def find_area(a,b):

return 0.5 * a * b #calculate the area

def find_perimeter(a,b):

return a + b + find_hypotenuse(a,b) #calculate the perimeter

print("the hypotenuse is :", find_hypotenuse(a,b))

print("the area is :", find_area(a,b))

print("the perimeter is :", find_perimeter(a,b))

All of the data stored and transmitted by digital devices is encoded as bits.A. TrueB. False

Answers

Answer:

A. True

Explanation:

A digital device is an electronic device that has the ability and capability to receive, store, process and transmit data to another device.

Since the processing device in the digital device understands only zeros and ones which are binary numbers (also called bits), transmission and storage of data in these devices should be encoded in bits.

Examples of digital devices are;

i. flash drives

ii. mobile phones

iii. speakers

iv. printers

v. scanners

Assign secretID with firstName, a space, and lastName. Ex: If firstName is Barry and lastName is Allen, then output is:

Answers

Answer:

I'll answer this question using Python

firstName = input("First Name: ")

lastName = input("Last Name: ")

secretID = firstName+" "+lastName

print(secretID)

Explanation:

This line prompts user for first name

firstName = input("First Name: ")

This line prompts user for last name

lastName = input("Last Name: ")

This line calculates secretID

secretID = firstName+" "+lastName

This line prints secretID

print(secretID)

Answer:

My name is Barry Allen, and I am the fastest man alive. When I was a child I saw my mother killed by something impossible. My father went to prison for the murder. Then an accident made me the impossible. To the outside world, I’m an ordinary forensic scientist, but secretly, I use my speed to fight crime and find others like me. And one day, I’ll find who killed my mother and get justice for my father. I am the Flash.

Explanation:

My name is Barry Allen, and I am the fastest man alive. When I was a child I saw my mother killed by something impossible. My father went to prison for the murder. Then an accident made me the impossible. To the outside world, I’m an ordinary forensic scientist, but secretly, I use my speed to fight crime and find others like me. And one day, I’ll find who killed my mother and get justice for my father. I am the Flash.

Which of the following is the process of writing the step-by-step instructions that can be understood by a computer?

Answers

Answer:

The process should be called an algorithm!

An app developer is shopping for a cloud service that will allow him to build code, store information in a database and serve his application from a single place. What type of cloud service is he looking for?A. laas(Infrastructure as a Service)B. DaaS (Directory as a Service)C. SaaS (Software as a Service)D. PaaS (Platform as a Service)

Answers

Answer:

Explanation:

We build Database Driven Web Applications tailored to your business. Consulting, UX, Dev. Database Web App Support/Maintenance Experts. Trusted for 15 years. Free Consultation.

You have an array of integers: int myints[10]; and the address of the first integer is be4350. What is the address of myints[1]? myints[2]?

Answers

Answer:

&myints[1] == 0xbe4354

&myints[2] == 0xbe4358

Explanation:

Assuming that sizeof(int) == 4, add 4 bytes for every array element.

Answer gets the brainliest!!! Choose the venues where audiovisual materials can be found today. (Select all that apply.) schools the internet stores businesses doctors’ offices homes

Answers

Answer:

doctors offices

internet stores buisnesses

Explanation:

Audio Visual Materials (AVMs) are those things can be understood by observing visual aspect of anything's. According to The Librarian Glossary (1987) “AVMs as non-book materials like tapes, slides, films which are renewed and recent to rather then read as books.”

Which of the following type of online advertising intermediaries decide the placement and pricing of online display ads by using the supply and demand of the ad landscape in a real- time auction process?
a. Ad networks
b. Retargeters
c. Content publishers
d. Data providers
e. Ad exchanges

Answers

Answer:

e. Ad exchanges

Explanation:

The ad exchange is a form of an online strategy that promotes the transaction of media advertising inventory from numerous ad networks. Here, prices for the inventory are defined through the supply and demand in a real-time auction system.

Hence, in this case, the correct answer is that the type of online advertising intermediaries is generally referred to as Ad Exchanges.

A type of online advertising intermediaries that can be decided ivia placement and pricing of online display ads is Ad Exchangers.

What is an ad exchanger?

An ad exchange is known to be a type of technology methods that is often used when buyers and sellers tries to connect so that they can sell and purchase ad goods.

Note that it is the one that acts as a middleman in the advertising transaction means that exit between supply side platforms (SSPs) (publishers) and demand side platforms (DSPs) (brands).

Learn more about Ads from

https://brainly.com/question/1658517


Select the correct answer.
For her homework, Annie has added the picture of a fruit in a document. She wants to enhance it to give a cut-out look. Which feature or menu
option should she use?

ОА SmartArt
OB. Clip Art
OC Charts
OD Shapes

Reset
Next

PLEASE HELP!!

Answers

Answer: B- Clip art

Explanation:

Answer:

Clip Art

Explanation:

how do u beat sonic unleashed

Answers

Answer: I guess you gotta do the fast, and then you gotta beat the things up when Sonic becomes even more of a furry ¯\_(ツ)_/¯

Explanation:

Watch playthroughs of the game.

8. What is the correct syntax of declaring arrays of pointers of integers of size 10

in C++?

a) int arr = new int[10];

b) int **arr = new int*[10];

c) int *arr = new int[10];

d) int *arr = new int [10];

Answers

Answer:

(b) int **arr = new int*[10];

Explanation:

An array of pointers is simply an array containing pointer variables. These pointer variables may be Strings, integers, doubles e.t.c

To declare such arrays of pointers, for example, of integers, in C++, we write;

int **arr = new int*[10];

The left hand side of the above code snippet i.e int ** arr, suggests that arr is a pointer that points to a pointer to integer variables.

The right hand side i.e new int* [10], creates a new array of 10 integer pointer variables.

Now, put together, int **arr = new int*[10] will create/declare an array of pointers of integers having a size of 10.

Computer ForensicsThere are many differences between public-sector and private-sector computer investigations. What do you see are the top three and why?

Answers

Answer:

For a private computer investigation into cyber crime the private sector  should complete all its courses and must be certified by the relevant authorities and must also be an expert in the computer investigations. while

Public computer investigations has more aspects that involves non-certified personnel's

The private-sector computer investigations are used mostly on all the cyber crimes and hacking and loss of business data.while public-sector computer investigations are used on crimes like rapes, accidents and murders crimes

Explanation:

Computer forensics are used to resolve crimes like cyber crime, hacking, malfunctions and data interrupts.

Before a private computer investigations which is into cyber crime investigation can continue, the private sector  should complete all its courses and must be certified by the relevant authorities and must also be an expert in the computer investigations. while

Public computer investigations has more aspects that involves non-certified personnel's and the personnel's are not necessarily supposed to complete the courses

The private-sector computer investigations are used mostly on all the cyber crimes and hacking and loss of business data.while public-sector computer investigations are used on crimes like rapes, accidents and murders crimes

Adnan merges the shapes he added to mimic the bridge structure. The modification is shown below. On the left side are a small square above a long rectangle. An arrow points right to where the small square is positioned partly over the top of the rectangle, to look like a bridge pillar. Which tab did Adnan use to merge the shapes? Which Merge Shapes option did Adnan use? Which property of the shapes did Adnan modify?

Answers

Answer:

The insert tab in the menu was used to select the shapes and all the shapes were selected with the shift key plus left-click on the mouse and on the right-click, a menu pops up and the items were grouped.

Explanation:

Microsoft office word is used in creating and editing text documents. It has several functionalities that can be used to convert documents, create tables, draw shapes, format the arrangement of text in the pages, etc.

To use some of the functions like drawing shapes, go to the insert tab and select "add shapes". There, you can find varieties of shapes and formats and it can be grouped or merged by right-clicking on the selected shapes and clicking on the group option.

Answer:

Which tab did Adnan use to merge the shapes? is drawing tools

Which Merge Shapes option did Adnan use? is combine

Which property of the shapes did Adnan modify? is shape outline

Explanation:

i just did the assignment on engenuity2020

Jake is preparing his resume. He is applying for the position of iOS application developer at a large software company. He wants to include his expertise in C++ and Java. Which sub-heading should he use? A. User-centric Design Skills B. Cross-Platform Development Skills C. Modern Programming Language Skills D. Agile Development Skills

Answers

Answer:

C. Modern Programming Language Skills

Explanation:

Which delivery model is an example of a cloud computing environment that provides users with a web based email service?
a. SaaS
b. PaaS
c. IaaS

Answers

Answer:

a. SaaS

Explanation:

Cloud computing can be defined as a type of computing that requires shared computing resources such as cloud storage (data storage), servers, computer power, and software over the internet rather than local servers and hard drives.

Generally, cloud computing offers individuals and businesses a fast, effective and efficient way of providing services.

Cloud computing comprises of three (3) service models and these are;

1. Platform as a Service (PaaS).

2. Infrastructure as a Service (IaaS).

3. Software as a Service (SaaS).

Software as a Service (SaaS) can be defined as a cloud computing delivery model which involves the process of making licensed softwares available over the internet for end users on a subscription basis through a third-party or by centrally hosting it.

Hence, Software as a Service (SaaS) is an example of a cloud computing environment that provides users with a web based email service.

You need to transmit PII via email and you want to maintain its confidentiality. Which of the following choices is the BEST solution?a. Use hashes.b. Encrypt it before sending.c. Protect it with a digital signature.d. Use RAID.

Answers

Answer:

B. Encrypt

Explanation:

The data, in this case PI will be encrypted from end to end. which means that only the person with the encryption keys is able to read what is in the message. Also the encryption will keep data in motion encrypted during transport.

Which of the following best describes how computing devices represent information?
A. A computer will either represent information as bits or bytes but not both
B. A computer represents data as a byte which is either a 0 or a 1
C. A computer represents data as bits which is either a 0 or a 1
D. A computer represents information as bits which contain 8 bytes.

Answers

Answer:

The answer is "C"

Explanation:

In the computer system, the data which separates a data object into relevant concepts is known as data representation. In the representation of data, it uses the binary digits, that are in the form of '0 and 1'. It is used by computers to store information and these numbers are also known as bits, and wrong choices can be defines as follows:

In option A, It is wrong because when we see the file details it shows both. In option B, It's incorrect because the smallest unit of data representation is bits. In option D, It is incorrect because bits includes only "0 and 1".

how do media and networks interact

Answers

Answer:

Media are connected to networks that make information easier to access and pass on.

answer for brainliest Today, trending current events are often present on websites. Which of the following early developments in audiovisual technology is most closely related to this? soundtracks newsreels microphones televisions

Answers

Maybe it is the telephone

How do others see technology?

Answers

It honestly depends. A lot of people could have different technology views. Imagine this: you meet 2 people. One person loves technology and the other person fears it.

If the <em> tags are around a word then it will be ____​

Answers

Answer: The HTML <em> tag represents stress emphasis of its contents. The <em> tag is used when you need to emphasize a particular word or phrase within a sentence. The placement of stress emphasis changes the meaning of the sentence. Also see the <strong> and <b> tags.

hopefully this helps, sorry if i'm off

MLMenu, a natural language interface for the TI Explorer, is similar to __________
a) Ethernet
b) NaturalLink
c) PROLOG
d) The Personal Consultant

Answers

Answer:

The correct option is B: Natural Link

Explanation:

Natural language is also an advanced system like MLMenu. In order to be able to retrieve and derive from present knowledge, it heavily depends on comprehending and producing natural language (and hence it has been named as such!). This technology is advancing and getting better day by day.

Normally used for small digital displays

Answers

Answer:

LCD screens would be used for students using smaller devices in the classroom, like iPads or handheld touchscreens

In which architecture is the application logic usually on the client side?

Answers

Answer:

two-tier architecture

Explanation:

A two-tier architecture is a term often used in computer operation, that describes a form of software architecture that comprises a presentation tier or window outlook that operates from the client-side, while on the server-side, a data outlook or data configuration is saved. An example is platform architecture.

Hence, two-tier architecture is a form of architecture in which the application logic is usually on the client-side

Testing mode identify internal components of a computer.

Answers

Answer:

CPU

Heatsink

Motherboard

PSU

HDD

RAM

GPU (If CPU does not have integrated graphics)

Chassis Fans

Some of the internal components of a computer are CPU, RAM, ROM, etc.

What are the internal components of a computer?

Internal components of a computer refer to the parts inside the computer case that enable it to function properly.

We have,

Some of the internal components of a computer are:

- CPU (Central Processing Unit): This is the brain of the computer, responsible for executing instructions and processing data.

- Motherboard: The motherboard is the main circuit board of the computer that connects all the components together.

- RAM (Random Access Memory): This is the computer's temporary storage space, where data and programs are loaded for fast access by the CPU.

- Hard Disk Drive (HDD) or Solid State Drive (SSD): These are the main storage devices in the computer, where all the data and programs are permanently stored.

- Power Supply Unit (PSU): This is responsible for providing power to all the components of the computer.

- Graphics Processing Unit (GPU): This is responsible for rendering graphics and images, and is particularly important for gaming and video editing.

- Sound Card: This component handles the computer's audio processing and output.

- Optical Drive: This is used to read and write data from optical discs such as CDs and DVDs.

- Cooling System: This includes fans and heat sinks that help keep the components of the computer cool and prevent overheating.

- Expansion Cards: These are additional components that can be added to the motherboard to add functionality, such as network cards, sound cards, or video capture cards.

Learn more about internal components here:

https://brainly.com/question/17475476

#SPJ5

Other Questions
Help Quick i have 1 min please help ASAP -4 + 5x 7 = 10 + 3x 2x what eqauls x why is the quotient -100/(-5) the same as the quotient 100/5 If a resident accidentally causes a chunk of ice to fall from the roof, how fast would the ice be moving when it hits the ground? Neglect air resistance. shows how a noun or pronoun and another word are related How did ancient rome use currency? What was the effect on international trade? Continue each pattern with the next two numbers.1.7,14,8,16,10,20,14, The type of study that generally does not follow the scientific method and typically contains many confounds is the What was the result of the overhunting of sea otters along the Pacific Coast? The sea otters on the Pacific Coast went extinct. The sea urchin population expanded and consumed the kelp and damaged the habitat. The sea urchin population was reduced to dangerous levels. The kelp grew rapidly and created new habitat for fish. Please answer the question in the photo. Match the description to the culture. Foraged for food, invented the atlatl and bow & arrow, lived together in small communities. 1. Paleolithic C Built ceremonial centers where people gathered for worship and recreation, traded with others for what they needed. 2. Archaic 3. Woodland Invented and used stone weapons to hunt large animals, 4. Mississippian Grew corn, beans, and squash, and were dependent on forest resources What is the density of a 700 kg object with a volume of 649 m3? (Density: D = D = m over v.) 0.927 kg/m3 .4543 kg/m3 1.079 kg/m3 4.543 kg/m3 How to find midpoint I can explain in 2 - 3 sentences why the interger -2 has a greater value than the integer -5. In order to solve 2 - 3 you __________________. The reason -2 has a greater value than -5 is because ________________________________________________. Which expression shows 7 more than the product of 8 times 9? A sample of 2,000 people yielded P(hat) = .52. What is the variance of the population proportion?a. .0056b. .0161c. .0112d. .00012 Ray KN is the angle bisector of angle JKL. Explain how you could find m angle JKNif you know m angle JKL. I will give the brainiestSuppose x = 7 is a solution to the equation 4x - 2(x + a) = 8. Find the value of a that makes theequation true.263-25 Which number is less than 2.16? 2.3, 2.09, 2.93, or 2.9 Identify the real number that corresponds to the point plotted on the real number line.