Question

Using the South University Online Library or the Internet, research database security and UML.

Based on your research and readings for the week, respond to the following discussion topics.

• Often, systems have only one level of security when it comes to databases. Imagine that someone is trying to add a name (which should be composed only of letters) to a database. The user mistakenly hits a number, and the system rejects the entry. Such security can be implemented at the database management system (DBMS) or the application level. Where would you apply security? Justify your choice.
• What are some alternative practices or standards of utilizing UML for the visual representation of systems? When would you use UML over other standards? When are other standards preferable?

Answer 1

the security can be  applied at the application level and data base security can also be provided using granular privileges,virtual private databases,roles ,stored procedures .these are dbms security mechanisms.

the data base entry can be restricted by applying constraints,triggers directly on columns.

UML was created by the OMG and standardized in 1997.

alternative visual representations are IDEF standard,Systems Modeling Language (SysML),Object Process Methodolog

they are not having tools for drawing visual representations.