Online Training Spring Hibernate Training in Delhi R Programming Training Course Big Data and Hadoop Training Java Training  
 

Entity relationship model

Ads

 
 

Share on Google+Share on Google+

kamoga
Entity relationship model
0 Answer(s)      7 years ago
Posted in : Design concepts & design patterns
For each of the projects, do the following:
a. Draw an ER diagram. Make sure each entity type has at least one key attribute. Document any assumptions you make. Avoid diagrams with a single entity.
b. For each attribute, determine its domain of values, whether null is an acceptable value, and, if acceptable, what null indicates.
c. If you think the description is incomplete, list other data the database should store.
d. Adjust your design to incorporate these additions.
1. A chemistry department wants to have a database of all chemicals in the stockroom. The information includes the name, molecular formula, amount on hand, date purchased, supplier, and supplier contact information.

2. A space agency wants to develop a database of all satellites that humans have launched into space. Data includes the satellite identification, date of launch, destruction date, purpose, maximum orbital altitude, launching location, launching agency, and contact information for agency.

3. An environmental agency wants to catalogue all the plants in an area that is susceptible to acid rain. Data should include genus, species, quantity, date, quadrant identification number, quadrant location, average altitude of quadrant, and botanist.

4. A psychological study requires participants to answer a number of questions related to personality. The database should store the multiple choice answers (A, B, C, D) to the questions and information about each participant, such as participant id, age, and sex. The database should compute a score based on the individual's answers. The score indicates one of 8 personality categories. Each category has an identifying name and specifies that each of three qualities is either true or false.
Ads
View Answers
Ads









Related Tutorials/Questions & Answers:
Entity relationship model - Design concepts & design patterns
Entity relationship model  For each of the projects, do the following: a. Draw an ER diagram. Make sure each entity type has at least one key attribute. Document any assumptions you make. Avoid diagrams with a single entity
Entity Relationship
Entity Relationship  Draw entity relationship diagram for the following scenario. A university has many departments whereas each department belongs to that particular uni.That uni has also many buildings whereas each building
Advertisements
Entity Relationship Diagram
Entity Relationship Diagram  Draw only entity relationship diagrams for the following scenario. Include any attributes you think should be represented. . Each engineer works on a number of projects. For every engineer a record
Entity Relationship Diagram 3
Entity Relationship Diagram 3  Task 3 Activities: Identify all entities and attributes from the given scenario. Draw entity relationship diagram of the given from scenario. Determine primary key and foreign keys from given
Version of com.mtnfog>entity-model dependency
List of Version of com.mtnfog>entity-model dependency
RelationShip
RelationShip  i have 2 table with one to many relationship how to add in these tables with hibernate please provide me, sample example. example:- one person have many address, when adding person will simply add, and for address
JPA One-to-One Relationship
JPA One-to-One Relationship   ... will learn  about the one-to-one relationship. In the one-to-one relation mapping a single value association to another entity.  One-to-One: In one-to-one
JPA Relationship
JPA Relationship      ... relationship. JPA supports the relationship between entities. There are following types of relationship: One-to-one One-to-many Many-to-one Many-to-many Many
entity bean
entity bean  can any one tell me how to develop and execute ---------- j2ee entity beans (cmp,bmp) example in weblogic server with (netbeans.../ejb/entity-bean-example.shtml
Hibernate Entity
This section contains the concept of hibernate Entity
entity hibernate
In this section, you will learn about entity in Hibernate
hibernate entity
In this section, you will learn about entity in Hibernate
Resultset with one to many relationship
Resultset with one to many relationship   Suppose there are 5 tables in database named A,B,C,D and E. A has one to many relationship with B,C,D and D has one to many relationship with E. Beam class of A contains array of Class B
An Entity Bean Example
. The EJB 3.0 entity beans are used to model and access relational...; Entity: An entity can be considered as a lightweight persistence domain object. An entity defines a table in a relational database and each
JPA One-to-Many Relationship
JPA One-to-Many Relationship     ... the one-to-many relationship and how to develop a one-to-many relation in your JPA Application. One-to-Many: In this relationship each record in Table-A may have
JPA Many-to-Many Relationship
JPA Many-to-Many Relationship     ... the many-to-many relationship and how to develop a many-to-many relation in your JPA Application. Many-to-many: In this relationship each record in Table-A may
JPA Many-to-one Relationship
JPA Many-to-one Relationship   ... about the many-to-one relationship and how to develop a many-to-one relation in your JPA Application. Many-to-One: In this relationship many related records
what is an entity in hibernate?
what is an entity in hibernate?  what is an entity in hibernate?   Entity: In general entity is an object that has some distinct value. In a persistent storage mechanism, an entity is a business object. Each entity has
What is Digital Relationship?
and expanse of the term digital relationship. But as we are immersed already... of digital relationship. Digital means concerning digits or numbers and it refers... with. A relationship across the digital framework of communication without being known to each
Successful Outsourcing Relationship,Managing Successful Outsourcing Relationship
How to Have a Successful Outsourcing Relationship Introduction The first... to be a long-term arrangement. The foundation to a successful relationship has... relationship. These practices are favored by companies from major outsourcing
Working with Entity bean using JPA
Working with Entity bean using JPA           Working with Entity bean using JPA An entity defines a table (consisting of rows and columns) in a relational
Design and develop entity EJBs
Design and develop entity EJBs... components Next    Design and develop entity EJBs Creating entity beans with container-managed persistence (CMP
Building a Parent Child relationship XML
Building a Parent Child relationship XML   PARENT CHILD 10788009 10788003 10788003 10788004 10788004 10788010 10788004 10788011 10788003 10788005 10788005 10788012 10788012 10788013 10788013
Identify correct and incorrect statements or examples about the rules and semantics for relationship assignment and relationship updating in a CMP bean.
the rules and semantics for relationship assignment and relationship updating... for relationship assignment and relationship updating in a CMP bean. The assignment... for the relationship multiplicity. In the case of a one
XML error message: The reference to entity
XML error message: The reference to entity   XML error message: The reference to entity "ai" must end with the ';' delimiter. Im getting this error when i gotta edit my blogger template Please advice manjunath
Hibernate Native Entity Query
This section contains detail about Hibernate Native Entity Query with example code
Chapter 8. Entity Beans
Chapter 8. Entity BeansPrev Part I. Exam Objectives Next    Chapter 8. Entity... method responsible for that behavior. A CONTAINER provides the entity bean
Model in struts
Model in struts  what is a model in struts
Chapter 5. Client View of an Entity
of an entity bean's local and remote home interface, including viewing the code used to locate an entity bean's home interface and the home interface methods provided to the client. The client of an entity bean
What is Digital Relationship Marketing?
Digital relationship marketing is increasingly becoming the focus of marketing... relationship holds some key clues to how we can response to marketing initiatives and campaigns in the new era and thus digital relationship marketing became
creating entity bean in eclipse europa - EJB
creating entity bean in eclipse europa  how to create a entity bean in eclipse europa