Course Title: Database Design I

(1)

Course Title: Database Design I Unit: 1 Software Development

Content Standard(s) and

Depth of Knowledge

Level(s):

The Student will:

1. Explain the history of computing and database development. 2. Design conceptual and physical models to create a database. 3. Prepare visual and written documentation of a database model 4. Compare SQL and basic select statements to determine results.

5. Evaluate system and software requirements to meet the needs of a database. 6. Explain the restricting and sorting of data.

• Examples: functions, average, minimum, maximum

7. Use basics of single row functions to query information in a database. 8. Explain steps of the software development process.

9. Design a database software application that includes mathematics.

Learning Objective(s) and

Level(s):

The Student will:

1. Understand and discuss the history of computing and database development. 2. Create a conceptual and physical model from a business concept.

3. Prepare and present visual and written documentation of a database model.

4. Set up, download, and prepare a computer system and software requirements to meet the needs of a database. 5. Compare and run SQL and basic select statements to determine and explain results.

6. Explain and demonstrate the restricting and sorting of data in a SQL statement. 7. Demonstrate and use single row functions to query information in a database. 8. List and utilize the steps of the software development process.

9. Design and present a database design for a business application that includes mathematical operations. Essential

Question(s):

What is the importance of building a database conceptually before a physical model? Why is a relational database needed for business over other options?

Content Knowledge Suggested Instructional Activities Rigor & Relevance Framework (Quadrant)

Suggested Materials, Equipment and Technology Resources

1. Explain the history of computing and database development.

a. Introduction

b. Data verses Information c. Historical

d. Transformation in Computing

Introduction on Computer/Listening Demonstration/Discuss, Note taking Brainstorming

Guided Practice, Lead Questions Problem- Based Learning

Activity: Create Timeline

(The following list of resources is needed in all Unit Instruction)

Computer/Monitor/Mouse Projector/Screen

Headphones Printer

(2)

2. Design conceptual and physical models to create database.

a. Entity Relationship Modeling b. Entity Relationship

Diagram(ERDs)

c. Entities, Instance, Attributes and Identifiers

d.

3. Prepare visual and written documentation of a database model. a. Identifying Relationships b. Diagramming/Drawing Relationships c. Speaking ERDish d. Relationship Transferability/Types e. Matrix Diagrams

f. Understanding ERD Requirements

g.

4. Compare SQL and basic select statements to determine results.

a. Introduction to database applications

5. Evaluate system and software requirements to meet the needs of a database.

a. Introduction to relational database concepts

b. Mapping types

6. Explain the restricting and sorting of data. a. Basic Table modifications

Examples: functions, average, minimum, maximum

7. Use basics of single row functions to query information in a database

a. Anatomy of a SQL(Structured

Query Language) Statement b. Basic Table Modifications

Inquiry Activity, Research E-businesses Applications,

Create Steps of Transaction: Credit Card Memorization

Lead Questions

Lecture, Brainstorming for Conceptual Modeling

Demonstration/Discuss, Note taking Guided Practice

Problem- Based Learning

Cooperative Learning:

Construct/label ER diagrams from Business Scenarios

Create Portfolio of Examples

Simulation Project: Document Business Requirements, Validate your ER model by performing a CRUD analysis Modifications, and Rules of Normalization.

Create ERD, Presentation of ERD Business Examples

Create Business Designs: Animal Shelter Project, Global Fast Foods, And Video Store Project.

Lecture, Brainstorming for Conceptual Modeling

Problem-Based Learning

Guided Practice/Introduction to Database, query and building tables in database.

Demonstration/Discuss, Note taking, Guided Practice

Identify and label row, column, primary key,

Internet Access

Curriculum (Internet Access)

Selftestsoftware.com: Practice software Database (Internet or Local access) Optional: Active Board

Microsoft Office Programs: Word, PowerPoint, Excel

Reference Books

Flash drive for file storage Scanner

(3)

8. Explain steps of the software development process.

a. System Development Life Cycle

9. Design a database software application that includes mathematics.

a. Introduction to Functions

unique key, and foreign key given a diagram of a table containing these elements and violations.

Transform an entity into a table diagram: including relationship/subtype mapping. Problem-Based Learning.

Define and give an example of a relational database

Lecture, Demonstration/Discuss, Note taking Guided Practice, Lead Questions

Construct a query to evaluate logical comparisons to restrict the rows

Guided Practice: Identify table-key terms, including row, column, field, primary key and foreign key

Edit, execute, and save SQL statements, using functions in Database

Anatomy of a SQL Statement: Create a statement, use correct syntax, to display, modify, or perform calculations.

Demonstration/Discuss, Note taking Lead Questions

Identify the role of data modeling in the system-development life cycle

Problems: Apply SQL syntax to restrict the rows returned from a query and apply the proper comparison operator.

Unit

Assessment:

Section Testing on Internet: Multiple Choice and Discussion questions, Database problems, Participation in curriculum discussion, Projects (Team and Individual), Reports, Section Activities, Practice testing, and Project Presentations.

Unit/Course CTSO Activity:

Students participate in developing the following CTSO Activities. Leadership Involvement (member /and or Officer), Personal Skills, Development of Chapter Program of Work, including community service projects, fund raising, attend meetings, help develop computer application needs of organization, network with local business for speakers and occupational information, and prepare for personal preparation for chosen competitive events.

(4)

Unit/Course Culminating Product:

Students design an ERD for a business scenario or real business situation. Create and execute a database design based on the customer needs for the relational database. Create and name tables in a database.

Course/Program Credential(s): Credential Certificate

Other: Course Certificate of Completion Database Programming Certification test after completion of Database I and II. Postsecondary Degree University Degree

(5)

Course Title: Database Design I Unit: 2 Customer Service

Level(s):

The Student will:

10.Interpret an entity relationship diagram (ERD) to match the business model.

11.Demonstrate different relationship types and transferability to match the business model. 12.Design an ERD for a business concept.

13.Implement the basic mapping of an ERD to meet customer needs. 14.Analyze quality assurance tasks to produce quality products.

Level(s):

The Student will:

1. Create an entity relationship diagram (ERD) to match the business model from a business idea.

2. Utilize knowledge in creating an ERD with different relationship types and transferability to match the business model. 3. Create a working design of an ERD for a business concept.

4. Listen to the customer and apply the basic mapping of an ERD to meet the business needs. 5. Evaluate Database creation for quality assurance, meeting customer needs.

Essential Question(s):

Why is the customer the foundation of a Database?

How does change apply to developing a relational database for a business?

1. Interpret an entity relationship diagram (ERD) to match the business model.

a. Effective Questioning of Business b. Identifying Relationships/Business

Rules

c. Historical Data

2. Demonstrate different relationship types and transferability to match the business model.

a. Unique Identifiers(UIDs)

Identify Business rules for different kinds of business in local area: Brainstorm Process Questioning: Simulation/Role Playing Cooperative Learning: Design business ERD with business rules.

Analyze business rules and choose the suitable primary UID and recognize the issues of identification in the real world

(The following list of resources is needed for all Unit Instruction)

Computer/Monitor/Mouse Projector/Screen

Headphones Printer

Internet Access

(6)

3. Design an ERD for a business concept. a. Readability

b. Generic Modeling

4. Implement the basic mapping of an ERD to meet customer needs.

a. Modeling: Time and Price

b. Nature of change

c. Presentation of product, written and visual.

d. Analyze quality assurance tasks to produce quality products.

Illustrate relationships on ERDs, diagram an arc constraint to represent an exclusive or

relationship, distinguish between the use of an arc and a subtype in the data model.

Diagram business examples of recursive and hierarchies relationships.

Research example of generic models and how they are useful in the database design process. Create a general ERD Model.

Identify and define time-related constraints in a time-sensitive model: Guided Practice

Solve problems: that track the business

requirement of tracking changes in price/values. Identify/design possible reports that can be produced from the data; explain how the

information from these reports could be useful to the business

Identify a data-modeling project to solve a business information need

Demonstrate solving business problems using skills and professionally presenting these solutions using technology

Present the final presentation project

demonstrating use of arguments to persuade the client.

PowerPoint, Excel Reference Books

Flash drive for file storage Scanner

Unit

Assessment:

Section Testing on Internet: Multiple Choice and Discussion questions, Database problems, Participation in curriculum discussion, Projects (Team and Individual), Reports, Section Activities, Practice testing, and Project Presentations.

(7)

Students participate in developing the following CTSO Activities. Leadership Involvement (member /and or Officer), Personal Skills, Development of Chapter Program of Work, including community service projects, fund raising, attend meetings, help develop computer application needs of organization, network with local business for speakers and occupational information, and prepare for personal preparation for chosen competitive events.

Students design an ERD for a business scenario or real business situation. Create and execute a database design based on the customer needs for the relational database. Create and name tables in a database.

Course/Program Credential(s): Credential Certificate Postsecondary Degree University Degree

(8)

Course Title: Database Design I Unit: 3 Career Opportunities

Level(s):

The Student will:

15. Determine the nature of work, responsibilities, and educational and credentialing requirements related to entry-level database design career opportunities.

Level(s):

The Student will:

1. Evaluate through resources the nature of work, responsibilities, and educational and credentialing requirements related to entry-level database design career opportunities.

2. Access personal career interests and learn to identify a career path.

Essential Question(s):

What is a Database Consultant and designer occupation? What are the opportunities available in the database industry? How is this important to my personal goals?

1. Determine the nature of work, responsibilities, and educational and credentialing requirements related to entry-level database design career opportunities.

a. Careers: Database Consultant

b. Requirements

c. Leaders in the Industry d. Personal Career Goals

e. Teaming Up

f. Interviewing

Create Portfolio of Examples: Document personal work experience and community involvement activities.

Lead Questions

Use the Internet to conduct research on individuals who have achieved success in the information-technology field.

Analyze the career path of successful individuals. Identify personality traits, skills, and habits of successful individuals.

Create a functional resume that highlights skills and experiences earned in class.

Cooperative Learning: Demonstrate effective team-building skills.

Compose a job description of related careers.

(The following list of resources is needed all Unit Instruction) Computer/Monitor/Mouse Projector/Screen Headphones Printer Internet Access

Microsoft Office Programs: Word, PowerPoint, Excel

Reference Books

(9)

Demonstrate effective techniques for public speaking and evaluate a presentation.

Cooperative Learning: Use internet resources to identify list of interview questions for a business interview.

Scanner

Unit

Assessment:

Section Testing on Internet: Multiple Choice and Discussion questions, Participation in curriculum discussion, Projects (Team and Individual), Reports, Section Activities, Practice testing, and Project Presentations.

Students participate in developing the following CTSO Activities. Leadership Involvement (member /and or officer), Personal Skills, Development of Chapter Program of Work, including community service projects, fund raising, attend meetings, help develop computer application needs of organization, network with local business for speakers and occupational information, and prepare for personal preparation for chosen competitive events.

Students design an ERD for a business scenario or real business situation. Create and execute a database design based on the customer needs for the relational database. Create and name tables in a database. Student’s research and presentation on careers in the Database Design Area.

Course/Program Credential(s): Credential Certificate Postsecondary Degree University Degree