Question

E/R diagram:

Draw a complete Doctors office system E-R diagram using UML or crow’s foot notation that includes all of the entities, attributes, identifiers. Relationships should be appropriately labeled with verb phrases. Make it neat.

Once the E-R model has created, convert the E-R model to a set of relations by using rules. We will call this set of relations the initial set of relations derived from the E-R model. You use to implement your database application in MS Access. Preferably use a charting tool to draw you E/R diagram. Visio is recommended.

Your relational database schema Include relation names and their attributes Write out the SQL CREATE TABLE and ALTER TABLE statements to create each table and then apply primary and foreign key constraints. An example, showing bare minimum follows. Feel free to expand it:

CREATE TABLE SUPPLIER (

SNO CHAR (9) NOT NULL,

SNAME VARCHAR (20)

CITY VARCHAR (10)

STATUS NUMBER (5) )

ALTER TABLE SUPPLIER ADD CONSTRAINT pk_SNO PRIMARY KEY (SNO); Your GUI design – the menus Forms Reports E/R to relational translation. I will accept your relational database as it is, i.e., the initial set of relations. Apply the normalization rules to normalize the set of relations to 3rd normal form. Do not implement in Access; just show them in your report. Prepare a user manual for your database application.