Start Discovering Solved Questions and Your Course Assignments
TextBooks Included
Active Tutors
Asked Questions
Answered Questions
list the drawbacks of relational database systema repetition of datab inability to s certain
define boyce codd normal forma relation schema r is in bcnf with respect to a set f of functional dependencies if for all functional dependencies in
what does authentication referauthentication refers to the task of verifying the uniqueness of a
give some encryption techniquesa des b aes c public key
give the limitations of sql authorizationthe code for checking authorization becomes intermixed with the rest of the application codeimplementing
mention the various user privileges all privileges directly granted to the user or roleall privileges granted to roles that have been granted to the
name the various privileges in sqla deleteb selectc insertd
mention the several levels in security measuresa database systemb operating systemc networkd physical
what are audit trailsan audit trail is a log of all alters to the database along with information like which user performed the change and when the
list out various user authorization to modify the database schema a index authorizationb resource authorizationc alteration
what is authorization graphpassing of authorization from single user to another can be shown by an authorization
list the types of authorization a read authorizationb write authorizationc update authorizationd drop
list some security violations or name any forms of malicious accessa unauthorized reading of datab unauthorized modification of datac unauthorized
give the forms of triggersthe triggering event can be insert or deletefor updated the trigger can state columnsthe referencing old row as clausethe
list the requirements needed to design a triggerthe requirements are-specifying when a trigger is to be implementedstate the actions to be taken when
what is the need for triggerstriggers are useful mechanisms for alerting humans or for starting particular tasks automatically when particular
what is assertion mention the forms availablean assertion is a predicate expressing a condition that we wish the database always to satisfydomain
what are referential integrity constraintsa value that appears in single relation for a given set of attributes also appears for a particular set of
what are domain constraintsa domain is a set of values that might be assigned to an attribute all values that appear in a column of a relation must
what is triggertriggers are statements that are implemented automatically by the system as the side effect of a change to the
what is the use of integrity constraintsintegrity constraints make sure that changes made to the database by authorized users do not result in a loss
list the sql domain typessql supports the following domain types1 charn2 varcharn3 int4 numericpd5 floatn6
what is transactiontransaction is a unit of program implementation that accesses and possibly updated several data
list the table modification commands in sqla deletionb updatesc insertiond update of a
what is the use of with clause in sqlthe with clause gives a way of defining a temporary view whose explanation is available only to the query in