Start Discovering Solved Questions and Your Course Assignments
TextBooks Included
Active Tutors
Asked Questions
Answered Questions
1 define the terms parent and child as they apply to tables in a database design and give an example of each2 show how
for your answer to question 515 describe a method for obtaining data for all the children given the key of the parent
1 explain how entities are transformed into tables2 explain how attributes are transformed into columns what column
1 what is denormalization2 when is denormalization justified3 explain the problems that unnormalized tables have for
1 explain how supertype and subtype entities are transformed into tables2 list the three types of binary relationships
for your answer to question 515 code an sql statement that creates a table that has all data from both tablesquestion
1 explain the meaning of the term intersection table2 explain how the terms parent table and child table relate to the
1 why is it not possible to represent nm relationships with the same strategy used to represent 1n relationships2 what
code an sql statement that creates a table with all columns from the parent and child tables in your answer to question
consider the following relation that holds data about employee assignmentsassignment employeenumber projectnumber
create a relational database design for the data model you developed for question 431question 431develop a data model
1 explain what read uncommitted isolation level is give an example of its use2 explain what read committed isolation
1explain the meaning of the expression acid transaction2 describe statement-level consistency3 describe
1 what is deadlock how can it be avoided how can it be resolved when it occurs2 explain the difference between
1 what is lock granularity2 explain the difference between an exclusive lock and a shared lock3 explain two-phase
1 explain the difference between concurrent transactions and simultaneous transactions how many cpus are required for
1 what is the goal of a database security system2 explain the meaning of the word inappropriately in the phrase one
1 what is the purpose of database administration2 explain how database administration tasks vary with the size and
1 describe how you have represented weak entities if any exist2 describe how you have represented supertype and subtype
suppose garden glory identifies three groups of users managers administrative personnel and system administrators
1 what types of cursors if any does microsoft sql server 2012 use2 how does the security model for microsoft sql server
1 summarize a dbas responsibilities for documentation2 use the microsoft sql server 2012 online documentation to answer
1 describe the rollforward process under what conditions should rollforward be used2 what is the advantage of making
1 explain how a database could be recovered via reprocessing why is this generally not feasible2 define the terms
1 explain the necessity of defining processing rights and responsibilities how are such responsibilities enforced2