Answered: Part 1 – Database Design (if covered…

Computer Networking: A Top-Down Approach (7th Edition)

7th Edition

ISBN:9780133594140

Author:James Kurose, Keith Ross

Publisher:James Kurose, Keith Ross

Chapter1: Computer Networks And The Internet

Section: Chapter Questions

Problem R1RQ: What is the difference between a host and an end system? List several different types of end...

See similar textbooks

Related questions

Concept explainers

Question

Part 1 – Database Design (if covered Chapters 2 and 3)

Step 1: Create a set of requirements that will be used to create the ER Diagram in Step 2.

Step 2: Create an ER diagram (using ERDPlus) that contains at least five entities and at least four binary relationships. At least one of the relationships should be many to many. Show all attributes of all entities.

Step 3: Map the ER diagram you created in Step 2 into a relational schema containing the relations (with their attributes) and the referential integrity constraints (i.e. arrows pointing from foreign keys into their sources). Use ERDPlus to draw the mapped relational schema.

Part 2 - Database Implementation (if covered Chapter 5 and/or use MS Access)

Step 1: Examine the Relational Schema that was created during the Part 1 of the project.

Step 2: Based on that schema, create a set of tables for using a DBMS (such as MS Access, Oracle, PostgreSQL, My SQL or similar). Name the database and its tables appropriately. Make sure to specify primary keys for all tables. Make sure all referential integrity constraints are enforced.

Step 3: Create all the necessary relationships between the tables.

Step 4: Populate the tables with initial data (no less than two no more than ten records per table).

(Optional) Step 5: Create a front-end interface containing several forms and reports of your choice for the created database.

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 3 steps with 1 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-engineering and related others by exploring similar questions and additional content below.

Recommended textbooks for you

Computer Networking: A Top-Down Approach (7th Edi…

Computer Engineering

ISBN:

9780133594140

Author:

James Kurose, Keith Ross

Publisher:

PEARSON