answersLogoWhite

0


Best Answer

updates- a change to the name of a sale rep requires not only change to the table, but several making the update process cumbersome.

inconsistent data- there is nothing about the disgint that would prohibit a sale rep from having two different names in the database.

addition- in order to add sales rep 87 (mary daniels) to the database, she must already present at least one customer. if she has not yet assigned any customers, you must add her record and create a fictitous customer for her to represent.

deletions- if you deleted all the customers of sales rep 35 from the database, you would lose all information concerning sales rep 35.

User Avatar

Wiki User

11y ago
This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: What are four different types of anomalous behavior in MySQL?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

What are the different types of databases available?

sql db2 oracle mysql


What are 5 different types of databases?

sql db2 oracle mysql


What are different types of organization in organisational behavior?

What are different types of organization in organisational behavior?"


What different types of behavior?

being carefuly


How many data types supported by MySQL?

Data types supported by MySQL are date and time data, numeric data, and byte data. Spatial data is another type supported by MySQL which includes the use of spatial extensions.


Explain characteristics of different types of organsational structures in management function and behavior?

Explain different types of ability


What are the different types of behavior of volcanoes?

Extinct, dormant and active.


What are the different engines of MySQL?

There are many different types of storage engine for MySQL, aswell as many custom versions. The most common ones used are MyISAM and InnoDB.MyISAMFalconMergeMemory (heap)FederatedArchiveCSVBlackholeClusterBerkeley DBEXAMPLEMariaInnoDBsolidDBNitroEDBInfobright (formerly Brighthouse)KickfireXtraDBIBM DB2One thing about MySQL is that it allows you to use a mixture of these engines within the same database, so depending on the table you can use the engine type that suits it best for your needs.


What types of database programs are there?

MS Access, MySQL, SQL Server,


What are the different types of behavior in psychology?

there is a two types of behavior ,the overt and covert OVERT-things that we do outwardly expressed COVERT-that cannot be seen by our naked eyes.


What types of biases arise in the different approaches to understanding consumer demand and behavior?

Cultural


What are the three main types of animal mating behavior?

Actually there are 4 different types: sound, movements, scent and display. xxx