{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

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 normalize table structures normalize table structures. Final step in building a database: create the database. We do this based upon ? We do this based upon ? Once the database has been created, we must add data (populate the database) before we can use it. 2010 John P. Shewchuk ISE 3024 Course Notes 12 – 1
Background image of page 1

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

View Full Document Right Arrow Icon
Many database software products and vendors e g Many database software products and vendors, e.g., Access, SQL Server (Microsoft). Oracle 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: hi l i t f graphical user interface. same interface/tools as other MS Office applications. • can 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
To 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. W fi t i t d d thi b t i Ch t 10 ( 37) h We first introduced this subset in Chapter 10 (p. 37), when we introduced relational schema diagrams. • relational schema 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 Document Right Arrow Icon
Order orderId orderDate 1 purchaseId MediaType ISBN Customer customerId Purchase purchaseId UsedBook ISBN 1 1 M 1 title lastName firstName saleDate customerId bookNum condition price 1 M purchaseId M 2010 John P. Shewchuk ISE 3024 Course Notes 12 – 4
Background image of page 4