Tuesday
October 21, 2014

Homework Help: systems analysis design

Posted by lacour on Monday, November 24, 2008 at 3:34pm.

Task: Draw an ERD that shows cardinality relationships among the entities.
When you create your ERD, you'll need to consider the training courses, trainers, corporate clients, students, test results, class schedules, and probably a few more. You'll find it easier if you follow these steps:
1. Identify all the entities. Review your DFDs and verify that we know the people, places, things, or events for which data is collected and maintained.
2. Determine all significant events or activities for two or more entities. You'll need to analyze the business operations and identify the entities and the nature of the relationship between them.
3. Analyze the nature of the interaction. Does the interaction involve one instance of the entity or many? Is the pattern always the same or does it depend on some factor?
4. Prepare the ERD diagram using Microsoft Visio. Study the diagram carefully to ensure that all entities and relationships are shown accurately. Use cardinality notation and include the correct symbols to indicate the nature of each relationship.

Phase IV System Design

Task: Database Design and Input/output Design

1. Review the ERD created in Phase III of the project. Refine the ERD by creating a new entity for each many-to-many relationship.
2. For each entity, Jesse wants to see table designs in 3NF. Use standard notation format (schema) to show the primary key and the other fields in each table.
3. Create tables using Microsoft Access by following the design of step 2 and enforce the relationships among entities.
4. Use sample data to populate fields for at least three records in each table.
Ok i did phase 2. Now i dont have a clue how to do the above task. Can anybody help me get started or recomend what to do?

Answer this Question

First Name:
School Subject:
Answer:

Related Questions

Systems Analysis Design Repost - Draw an ERD that shows cardinality ...
Computer - Draw an ERD that shows cardinality relationships among the entities, ...
DBM 381 - Create a detailed ERD using the Entities and Attributes document ...
dbm 380 - Create a detailed ERD using the Entities and Attributes for Driver's...
systems analysis design task - Tasks: 1. Jesse wants to see a context diagram ...
systems analysis task - 1.Jesse wants to see a context diagram and a diagram 0 ...
System Analysis and Designs - IT460 - I need help really bad since I am majorly...
System Analysis &Design - What should my entities be? Consider the following ...
college systems analysis and design (visio 2007) - I need help on this data flow...
IT - I need to create a sample plan on remodeling a bathroom this is for class ...

Search
Members