Latest Tutorials| Questions and Answers|Ask Questions?|Site Map



Login         

View Questions and Answers by Category

Advertisements


 
Have Programming Question? Ask it here!
 
 
 


kamoga
Entity relationship model
0 Answer(s)      5 years and a month 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.

Advertisement
View Answers

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
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
Model in struts
Model in struts  what is a model in struts
Hibernate Entity
This section contains the concept of hibernate Entity
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
entity hibernate
In this section, you will learn about entity in Hibernate
hibernate entity
In this section, you will learn about entity in Hibernate
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 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
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 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
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
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
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
Java event-delegation model
Java event-delegation model  What is the advantage of the event-delegation model over the earlier eventinheritance model
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
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
delegation event model
delegation event model  What is delegation event model?   delegation event model In the event-delegation model, specific objects...-listener interfaces. Advantages of event-delegation model: 1)It enables
Java event delegation model
Java event delegation model  What is the highest-level event class of the event-delegation model
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
spring Model class
spring Model class  how to connect database in spring MVC ,sample model class and diplay results from database   Have a look at the following link: http://www.roseindia.net/spring/jdbc-template-batch-update.shtml
Java single threaded model
Java single threaded model  How single threaded model works after implementation in class, basically architecture point of view
Networking with OSI model
Networking with OSI model  What is networking and it's how to work with OSI model?   Please visit the following links: http://www.roseindia.net/java/network/index.shtml http://www.roseindia.net/technology/networking
Single thread model - Struts
Single thread model  Hi Friedns , thank u in advance 1)I need sample code to find and remove duplicates in arraylist and hashmap. 2) In struts, ow to implement singlthread model and threadsafe
Advertisements
 

 

 

DMCA.com