0
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.
What else can I help you with?
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?"
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.
What different types of behavior?
being carefuly
What are the different kinds of dispersion?
The three main types of dispersion are normal dispersion, anomalous dispersion, and material dispersion. Normal dispersion is when the refractive index decreases with increasing wavelength, while anomalous dispersion is when the refractive index increases with increasing wavelength. Material dispersion is due to variations in refractive index with different wavelengths in a medium.
Explain characteristics of different types of organsational structures in management function and behavior?
Explain different types of ability
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 of volcanoes?
Extinct, dormant and active.
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.
Are woodpeckers and chipmunks types of squirrels?
No, woodpeckers and chipmunks are not types of squirrels. They are all different types of animals. Woodpeckers are birds known for their pecking behavior on trees, while chipmunks are small rodents similar to squirrels but with differences in appearance and behavior.
