3024-Chap12 - 12. CREATING AND POPULATING DATABASES WITH...

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

View Full Document Right Arrow Icon
12. CREATING AND POPULATING DATABASES WITH ACCESS We’ve now seen how to translate E-R diagrams (conceptual schema) into relational schema and ormalize table structures normalize table structures. Final step in building a database: create the database. e do this based upon ? We do this based upon ? Once the database has been created, we must add data opulate he database) before we can use it. 2010 John P. Shewchuk ISE 3024 Course Notes 12 – 1 (popu ate t e database) be o e e ca use t
Background image of page 1

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

View Full DocumentRight Arrow Icon
any database software products and vendors e g Many database software products and vendors, e.g., • Access, SQL Server (Microsoft). •O rac le 11g (Oracle). • Advantage Database Server v8.1 (Sybase). • Informix 11.5 (IBM). We will employ Microsoft Access in this course, due to its widespread availability and use. Other Access advantages: •g raphical user interface. • same interface/tools as other MS Office applications. an create databases useable with other DB servers 2010 John P. Shewchuk ISE 3024 Course Notes 12 – 2 • can create databases useable with other DB servers.
Background image of page 2
o keep things simple we will work with a subset of the To keep things simple, we will work with a subset of the full relational schema for Anna’s Books. We first introduced this subset in Chapter 10 (p. 37), when we introduced relational schema diagrams. lational chema diagram and data dictionary: next • relational schema diagram and data dictionary: next two pages. The completed Access 2007 database for this scenario ( AnnaSubset.accdb ), can be downloaded from Scholar: Scholar: Resources Application Files Chapters 12-14: MS Access 2010 John P. Shewchuk ISE 3024 Course Notes 12 – 3
Background image of page 3

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

View Full DocumentRight Arrow Icon
Order orderId rderDate 1 orderDate purchaseId MediaType ISBN Customer ustomerId Purchase urchaseId UsedBook ISBN 1 1 1 title customerId lastName firstName purchaseId saleDate customerId bookNum condition price 1 M M purchaseId M 2010 John P. Shewchuk ISE 3024 Course Notes 12 – 4
Background image of page 4
Range Value Index Foreign Key Attribute or PK FK Req’d (Dupl Referenced Name Description Type Length Format Choices ? ? ? Values) ?T a b l e Order orderId Cust. order # VCHAR 4 PK orderDate Order date DATE 8 dd/mm/yy Y N purchaseId Customer PO INT 5 FK Y Y (N) Purchase Customer customerId Customer ID INT 3 PK lastName Last name VCHAR 30 Y Y (Y) firstName First name VCHAR 30 Y N Purchase purchaseId Cust. purch. # INT 5 PK saleDate Purchase date 8 dd/mm/yy N N customerId Customer ID INT 3 FK Y Y (Y) Customer UsedBook ISBN BookID FCHAR 13 x-xxxx-xxxx-x PK FK MediaType bookNum e.g., 1 = 1 st INT 3 PK condition Book condition VCHAR 9 "Good", "Very Good", Y N "Excellent", "Like New" price Unit price CURRENCY 5 $xx.xx Y N purchaseId CustomerPO INT 5 FK N N Purchase MediaType 2010 John P. Shewchuk ISE 3024 Course Notes 12 – 5 ISBN Book ID FCHAR 13 x-xxxx-xxxx-x PK title Book title VCHAR 80 Y N
Background image of page 5

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

View Full DocumentRight Arrow Icon
12.1 Creating an Access Database 12.1.1 Getting Started Start Access 2007, then click the Office button and select New . The Blank Database task pane will appear at the ght right.
Background image of page 6
Image of page 7
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 02/14/2010 for the course ISE 3024 taught by Professor Staff during the Spring '08 term at Virginia Tech.

Page1 / 70

3024-Chap12 - 12. CREATING AND POPULATING DATABASES WITH...

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

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