database assignment 1459171 2
Part 1: Database Design
This week, you will begin by defining the entities, attributes and keys required for your database. After you have defined them, you will create the appropriate entities in MS Access and create forms in Access so that the database can be populated with information.
Using the free program Dia, (you may use another program to create your ERDs if you like, as long as they conform to the Crow’s foot model), create Entity-Relationship Diagrams that represent the underlying structure of the database. After you have created the ERDs, you will use MS Access to accomplish the following tasks.
Create an ER diagram for the entities and relationships listed below, including all keys.
Using parent email addresses as the primary key, create entities and relationships that contain relevant student information and information about status with regard to each of the following areas:
Class type (Science, Art, Music, Language, etc)
Class activities Alumni
Part 2: Database & form creation
In Access, use the ERD and relationships from Part 1 to create and populate a database with entities and attributes for all relevant entities database components
In Access, create forms so that users can add entries to the participant, instructor and class groups.
Criteria: If you complete all parts of the assignment, document them properly and upload documentation to the assignments section of Blackboard, you will receive full credit.
Looking for solution of this Assignment?
WHY CHOOSE US?
We deliver quality original papers
|Our experts write quality original papers using academic databases.|
|We offer our clients multiple free revisions just to ensure you get what you want.|
|All our prices are discounted which makes it affordable to you. Use code FIRST15 to get your discount|
|We deliver papers that are written from scratch to deliver 100% originality. Our papers are free from plagiarism and NO similarity|
|We will deliver your paper on time even on short notice or short deadline, overnight essay or even an urgent essay|