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




Have Programming Question? Ask it here!
 
 
 


kamoga
Entity relationship model
0 Answer(s)      4 years and 5 months 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
hibernate entity
In this section, you will learn about entity in Hibernate
entity hibernate
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
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
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
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
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
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
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
Hibernate Native Entity Query
This section contains detail about Hibernate Native Entity Query with example code
Presentation-Model Structure
Java NotesPresentation-Model Structure Previous - Big Blob, Next - MVC... interface from the model (business logic, domain, ...). This provides a huge... of the complications by simply sticking to the Presentation-Model organization
In Struts What is Model?
In Struts What is Model? This tutorial explains you What is Model in Struts..., Model, View and Controller. In MVC design pattern there are three kinds of components: Model View and Controller Struts is also based
Explain the relationship among database, tablespace and data file.
Explain the relationship among database, tablespace and data file.  Explain the relationship among database, tablespace and data file.   Hi, Here is the answer of your question, Database : Database is the Collection
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
How to convert entity character to html character
How to convert entity character to html character  How to convert entity character to html character
Entity DB design pattern - Java Interview Questions
Entity DB design pattern  I want the information for Entity DB design pattern
creating entity bean in eclipse europa - EJB
creating entity bean in eclipse europa  how to create a entity bean in eclipse europa
Java: Rainfall Model
Java NotesRainfall Model 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42
Persistent Fields and Properties in Entity Classes
in Entity Classes. Here we will learn about the field types supported in the JPA. As explained in the earlier sections the Entity is managed... an entity and then access its state through variables or properties. In JPA
alias_to_entity_map
In this section, you will learn about attribute 'alias_to_entity_map' of method 'setResultTransformer' which converts each row of result into a Map
JSP Architecture, JSP Model 1 architecture, JSP Model 2 architecture
of the architecture is used. These architectures are known as Model 1 and Model 2 architectures. So, in JSP there are two types of architecture of the JSP: Model 1 Architecture Model 2 Architecture JSP Model 1 Architecture In case
Customer Relationship Management
the success of any organization in its efforts. Thus relationship with the customer... for the company. Customer relationship management (CRM) is the process by which a company or organization interacts with its customer, clients etc for a long relationship
How to convert entity character to html character
How to convert entity character to html character  Please help me to "convert entity character to html character" in java. If possible please provide source code which take String as input and return as String
Document Object Model(DOM)
Document Object Model(DOM)       The Document Object Model (DOM) is a an standard object model that represents HTML or XML and related formats. Document Object Model is platform
What is OSI Model?
What is OSI Model? The OSI Model is used to describe networks... Model : OSI Layer Diagram:    7)  Application Layer..., voltages etc. How to remember the layer of OSI model? The easiest way
Identify correct and incorrect statements or examples about persistent relationships, remove protocols, and about the abstract schema type of a CMP entity bean.
among entity beans within the same LOCAL relationship scope, as defined.... A unidirectional relationship is implemented with a cmr-field on the entity bean... on the entity bean instance that is the target of the relationship
Advertisements
 

 

 

DMCA.com