Name the main steps in database design. What is the goal of each step? In which step is the ER model mainly used? (Section 2.1)

Define these terms: entity, entity set, attribute, key. (Section 2.2)

Define these terms: relationship, relationship set, descriptive attributes. (Section 2.3)

Define the following kinds of constraints, and give an example of each: key constraint, participation constraint. What is a weak entity? What are class hierarchies? What is aggregation? Give an example scenario motivating the use of each of these ER model design constructs. (Section 2.4)

What guidelines would you use for each of these choices when doing ER design: Whether to use an attribute or an entity set, an entity or a relationship set, a binary or ternary relationship, or aggregation. (Section 2.5)

Why is designing a database for a large enterprise especially hard? (Section 2.6)

What is UML? How does database design fit into the overall design of a data-intensive software system? How is UML related to ER diagrams? (Section 2.7)

What is a relation? Differentiate between a relation schema and a relation instance. Define the terms arity and degree of a relation. What are domain constraints? (Section 3.1)

What SQL construct enables the definition of a relation? What constructs allow modification of relation instances? (Section 3.1.1)

What are integrity constraints? Define the terms primary key constraint and foreign key constraint. How are these constraints expressed in SQL? What other kinds of constraints can we express in SQL? (Section 3.2)

When are integrity constraints enforced by a DBMS? How can an application programmer control the time that constraint violations are checked during transaction execution? (Section 3.3.1)

What is a relational database query? (Section 3.4)

How can we translate an ER diagram into SQL statements to create tables? How are entity sets mapped into relations? How are relationship sets mapped? How are constraints in the ER model, weak entity sets, class hierarchies, and aggregation handled? (Section 3.5)

 

 

• 1495612381-Assinment 2.docx

ComputerScienceExpert

(11)

Status NEW Posted 24 May 2017 07:05 AM My Price 9.00

-----------

Attachments

file 1495612385-Solutions file 2.docx preview (51 words )

H-----------ell-----------o S-----------ir/-----------Mad-----------am ----------- Th-----------ank----------- yo-----------u f-----------or -----------you-----------r i-----------nte-----------res-----------t a-----------nd -----------buy-----------ing----------- my----------- po-----------ste-----------d s-----------olu-----------tio-----------n. -----------Ple-----------ase----------- pi-----------ng -----------me -----------on -----------cha-----------t I----------- am----------- on-----------lin-----------e o-----------r i-----------nbo-----------x m-----------e a----------- me-----------ssa-----------ge -----------I w-----------ill----------- be----------- qu-----------ick-----------ly -----------onl-----------ine----------- an-----------d g-----------ive----------- yo-----------u e-----------xac-----------t f-----------ile----------- an-----------d t-----------he -----------sam-----------e f-----------ile----------- is----------- al-----------so -----------sen-----------t t-----------o y-----------our----------- em-----------ail----------- th-----------at -----------is -----------reg-----------ist-----------ere-----------d o-----------n -----------THI-----------S W-----------EBS-----------ITE-----------. ----------- Th-----------ank----------- yo-----------u -----------

Not Rated(0)

• Buy Answer