WOULD LIKE TO GIVE TIP ON THIS IF POSSIBLE. dO YOU ACCEPT TIPS? Unit 5 Final Pro

Question

WOULD LIKE TO GIVE TIP ON THIS IF POSSIBLE. dO YOU ACCEPT TIPS?

Unit 5 Final Project Part 2

For the second part of this project you will take the business information, normalized data in 3NF and finalize the database design process:

Complete MS Visio Entity-Relationship Diagram (ERD) for the database design. Include all maximum and minimum cardinalities on your diagram. Be sure to identify all primary and foreign key fields. The ERD CANNOT be hand-drawn; you must use MS Visio via the XenDesktop to create this diagram.

You must include all business rules that will affect your database design. Business rules are constraints, or restrictions that limit how you develop your database. For example, in a sales-oriented database, quantities purchased cannot be negative. Identify all business rules that you believe will affect your database design. Also, decipher the relationships in your ER diagram in written form.

Access DBMS – Create an Access database structure using the normalized data found in your 3NF dependency diagrams and your Visio ER diagram.

Build tables including primary and foreign keys, data fields with specific data types, and notes in each field in design view explaining the purpose of the data. For instance, you have a table named EMPLOYEES, one field is named EMPLOYEE_ID, its data type is number, and its description is primary key unique number given to each new employee.

Add at least five records to each table using the datasheet view.

Create relationships between tables. Remember when creating a 1:M relationship between two tables you need to enter the primary key field of the parent into the child table as a foreign key field. If you have a M:N relationship, you need to create a linking table containing a composite primary key field with two 1:M relationships connecting to it.

Create at least two queries that contain constraints.

Design at least one form.

Create at least two reports. One of these reports must be based upon one of your queries.

Deliverables:

Assignment Upload: Visio ER diagram, written business rules, Access DBMS containing all items as seen in the project instructions. You will submit a .vsd or .vsdx file for your ERD, Word document for your business rules, and .accdb for your Access DBMS.

Explanation / Answer

You can folliow below points for solution:

1. ER diagram: An ER (Entity-Relationship) diagram graphically shows the entities and their relationships with respect to a given database or system. An entity is something which has its own unique properties(attributes) and existence. Various instances of an entity share common traits. For example - for an organisation, an employee is an entity, for a business, a customer is an entity. Even organisation and business itself are entities. For a given system, there will be more than one entities usually. These entities are related (associations) to each other in one way or other. These associations can be 1:1, 1:M, M:1 etc. You can use following guidelines to prepare ER diagram:

a) First try to completly understand the domain, its business rules and scenarios, context of requirements etc.

b) Identify all possible business entities and their corresponding relationships. Different business scenarios may have different set of entities. Hence, it is important to understand the scenarion fully. For example, purchase order management is different from accounts management.

c) Also try to identify the the level at which ER diagram is to be drawn - conceptual -> logical -> physical. Conceptual being the first set and physical being the most detailed set ready for implementation.

d) Among the entities, it is possible to have weak entites (entities not uniquely identifiable their own properties). Such entities have foreign key relationship with another entity.

e) Once all entities, their properties and relationships are defined, then start drawing ER diagram. Note an entity should appear once in the diagram. Every entity, property and relationship should have its own name in the diagram. There should be no duplicate relationships neither no relationship be missing in the diagram.

2. ER diagram in MS Visio: In MS Visio, you can create ER Diagram -

     a) by going to File->New->Software and Database->Database Model Diagram.

     b) To define diagram option, goto Database->Options->Document. This will open the Database Document Options dialog box. In this dialog box, you can specify options like symbol set, relationship options etc.

However, overall sequence may vary depending on the version of Visio you are using.

3. For creating database in MS Access, you can use database wizard through File -> New -> New File -> Templates -> On My Computer -> Databases -><select database type> -> OK. This will open File New Database dialog box. In the dialog box, provide name and locaiton of database and click on Create. This will launch database wizard. Follow the instructions of the wizard.

Hope, these point will help you.

Related Questions

Navigate

• Browse (All)
• Browse W
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.