ER Assistant Exercise - ERAssistantExercise 1....

Info iconThis preview shows pages 1–4. Sign up to view the full content.

View Full Document Right Arrow Icon
ER Assistant Exercise 1. Select new from the file menu. 2. Select entities from the insert menu. 3. Click on New button 4. Type DBST651_Students in the Name text box 5. Click attributes button, and you will get the screen below. Click new.
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
6. Type StudentID in the name text box, check the primary key check box, and select numeric for the  data ype.   7. Click on new again, and create an attribute FirstName. Set the datatype to varchar, and length to 10.  Make sure that the primary key text box is unchecked.
Background image of page 2
Follow the same steps to create a LastName varchar attribute, and set  the length to 20. 9. Create birthday attribute, and set the data type to date. Create grade attribute of type char length  with length=1. 10. This is what you have.    11. Click close in the attribute window, and click new in the entity window. 12. Create an entity named instructor with the following attributes:
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 4
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 5

ER Assistant Exercise - ERAssistantExercise 1....

This preview shows document pages 1 - 4. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online