wasnt nate

CMGT410: Responding to Project Scope Change

How should a project manager respond to a change request from a sponsor that is clearly beyond the scope of the project? From time to time the sponsors or leadership team will want to make a wild change to the deliverable. The project manager’s first thought might be to blindly stand their ground. This can [...]

CMGT/410: What is Integration Project Management

What is meant by an integrative project management process and why is this so important? What are the pitfalls if such an approach is not taken? As a project transitions through the various phases between inception and completion, there are a lot of entity management tasks to complete along the way. Entities would include people, [...]

How to Get Entry Level IT Positions

The easiest way to get an entry level position to be active in the professional community. Also consider: – Join open source projects – Create a web presence for your church, club, or friend – Find the professional groups that have chapters in your city; a few big ones that are everywhere include: – .NET/Linux/Computer (NUG/LUG/CUG) – Cloud [...]

DBM380: Roles of Database Administration

Describe the differences between a database administrator and a database architect? Database Administrator This person that is responsible for the DBMS software installation. After installation they are also handle the “Maintenance” phase of the SDLC, which would include: – Patching/Upgrading – Ensuring Failover clustering works – Backups and Recovery Plans Database Architect This person functions as [...]

DBM380: Database Recovery Models

Suppose that the database system within your organization has failed. Describe the database recovery process? There are many database systems within my organization, each one has a Backup and Recover (B/R) process that is associated with its level of criticality. For instance our test team’s IaaS database keeps track of where automation is presently be [...]

DBM380: What is an Object Relational Mapper (ORM)

50,000 foot view an ORM is basically a library that will maps code objects against database objects. This allows the developer to write their code with no knowledge of the underlying database. Instead the ORM library will dynamically generate SQL commands for any retrieve or persist operation. To provide a specific example using .NET and LINQ; [...]

DBM380: Purpose of Denormalization of Schema

In what business database environments is denormalization appropriate and why? If all of the data is stored in one long continuous row, then retrieval of all its attributes happens in constant time. However this long continuous row will is more likely to have data anomalies, waste disk space, and consume more memory on read accesses. [...]

DBM380: Easily Working with Highly Normalized Tables

If an entity is broken into 5 or more tables it can still be easily worked with through the Sql primitives called Views and Functions. Lets say that there is a database for keeping track of who is wearing what right now. The person entity might be normalized as such: Person (PID, Name, CurrentShirtId, CurrentPantsId, CurrentShoesId, [...]

DBM380: Purpose of Normalization

Describe the nature and purpose of the normalization process? When dealing with tiny data sets, or single user databases normalization seems like more of a hassle than a benefit. Why not just add an extra column here or there, there is no reason to create separate schema to hold this additional information. Then a little [...]

DBM380: Common Schema Issues of New Database Students

When database students first start out, it is common for them to not implement entities correctly. Here is a before and after comparison to help out… Example Before Imagine we are creating a schema for an auto repair shop and defined it something like: fleet ( type of cars ) maintenance_history ( date, fname, lname, address, [...]

Previous Posts