Course details
In this course, students will design and create a relational database.
Course Outline
1 - Analyzing Client Requirements
- Analyze Current Data Storage Systems
- Identify New Client Requirements
- Determine the Required Data Fields
- Group Fields into Tables
- Identify Key Fields
2 - Creating a Preliminary Design
- Create a Preliminary Entity Relationship Diagram
- Apply the First Normal Form
- Apply the Second Normal Form
- Apply the Third Normal Form
- Apply the Higher Normal Forms
- Denormalize Tables
- Incorporate Client Feedback
3 - Implementing the Database Design
- Translate Business Rules into Constraints
- Create Tables
- Create Indexes
4 - Generating Reports
- Manipulate Data
- Generate Reports Using Conditions
- Generate Reports from Multiple Tables
- Generate Summary Reports
- Create Views
5 - Customizing a Database
- Modify Constraints
- Modify Fields
- Modify Tables
Target Audience: Inpiduals who are able to write simple queries or run queries that someone else has designed.
Updated on 08 November, 2015Course Location
About New Horizons Ireland
With a very convenient location next to Jervis street in Dublin 1, we offer a wide range of IT and business skills courses and we can also send our instructors to your location.
We are 100% Irish owned, but we are also part of the largest independent IT Training Provider, New Horizons Computer Learning Centres who deliver more courses than any other IT training company.
Because we're local, we understand the needs of business and individuals in our community. Whether you choose to take classes in person or online, you're always welcome to call or stop by.
See all New Horizons Ireland courses- JavaScript Full stack web developer virtual internship Virtual Bootcamp + Internship at LaimoonAED 1,449Duration: Upto 30 Hours
- ESP32 + Databases to Control Anything Global CoursesEUR 20
EUR 193Duration: 2 Hours - Data Bundle Complete Diploma Level 3 Alpha AcademyEUR 24
EUR 386Duration: Upto 22 Hours