Database Design and Development (CIS 305)

Data Modeling a Necessity for Information Quality {5}

In this article, the author talks about how conceptual data modeling is a necessity. That it is impossible to have good data quality without first understanding what the data is supposed to represent. He goes on saying that if you don’t understand what the relationship thoroughly. He even uses the analogy that it’s kind of [...]

Developing a Successful Conceptual Model {3}

This article talks about how databases are a backbone to any information system. Since that is the case it is very important that the conceptual modeling of a database is done correctly. The author also says how much effort when dealing with the the conceptual design will be spent in communicating to the stakeholders. However [...]

Potential Foreshadowing?: An Analytical Perspective on Student Database Projects in the Name of Academia {3}

Here’s something I’m sure we can all relate to – upcoming database projects! Even when it comes to our own majors, a school project rarely feels like a useful exercise benefiting us as students. If you have yet to outgrow this notion, look no further than this article. Sharon M. Tuttle has been conducting an [...]

Extension of ER Model {2}

This article talks about how to manage data quality and context semantics by using the approach extension of the Entity Relationship Model. In context semantics there is a problem call “Inter-attribute Relationship”.  By using the approach of Entity Relationship Model, it can solve the problem. In addition, Dr. Steven and Dr. Richard Wang also talk [...]

Using ER Models for RFID {8}

In this article, the author talks about how RFIDs (Radio Frequency Identification) uses Entity-Relation models to manage its data. With the use of RFIDs, it allows objects to automatically collect information so it makes things easier and more efficient for those who use it. The data for the RFIDs changes frequently and it requires the [...]

SQL and Google get closer together {2}

Back in 2010 Google had a project called App Engine and incorporating SQL to that project’s features were part of it.  Now, at the end of 2011, they have started to add a free beta service for using a relational database system called Google Cloud SQL.  With the new App Engine program from Google, an [...]

Which one should be taught for data modeling, UML or ER? {1}

The article I read this week was about how data modeling can best be taught to students. The two main methods the authors focused on were Entity relationship (ER) modeling and the Unified Modeling Language (UML). The article talks about the history of ER modeling, which essentially came before the object oriented “movement,” when UML [...]

Seven common Data Modeling mistakes to watch out for {2}

The article briefly describes the benefits of data modeling and how it helps a company and its projects. It then immediately jumps into the seven common mistakes that occur. The First mistake is thinking that the data model is a final structure. This kind of thinking is incorrect, since the data model should be thought [...]

Three Things the Data Team Wishes You Knew About Data Modeling {1}

Loraine Lawson blogs about the importance of data modeling and the three things that data team’s wish their CIO, IT manager, or even business manager knew about data modeling.  She writes that data modeling is very important and it’s different than application development.  She points out that application development looks to solve a problem quickly, [...]

A Model for Models: Data Modeling Basics {0}

Data modeling is a vital aspect of database creation and management. The ER diagrams lay the logical framework for an entire system, upon which so many people and other systems will be relying. Fundamentals, as with every other academia subject, are a complete necessity. Luckily, articles such as this one exist which aid in understanding. [...]

3 Things about Data Modeling {1}

Summary: In this article it pointed out that data modeling is highly technical so most people might not be in interested in learning more about data modeling, but it is a powerful tool to have when handling and dealing with database (Loraine Lawson, 2012). There are few important tips and facts about data modeling. First [...]

Data Modeling in the Medical Industry {0}

The main topic of my article included how Teradata a, “world leader in enterprise intelligence and analytics” is committed to the health care industry,with hopes of having one of the worlds most comprehensive health care industry logical data model (LDM). By having an LDM to establish a data structure, made it a common practice for [...]

Advantages of Relational Databases {5}

This article talks about the several key advantages that relational database has over other database models. Relational database is probably those most popular database models being used. It provides a declarative method for specification of data and queries. Information in  a relational database can be retrieved based on what the users want without having to [...]

Is Data Modeling a waste of time? {5}

The article, “Why does Data Modeling Take so Long”, by Jonathan G. Geiger, is an answer to the question asked by one of the attendees at a conference. The author explains that data modeling is used for designing data structures for businesses. Also, he mentions that when we begin building data modeling work, we should [...]

Two-level Variability Analysis {0}

I found this article while searching for E-R diagrams for common business situations. This article discusses the transition away from a silo application approach to a more flexible process focused information system. This article makes emphasis towards carefully analyzing business processes. Prior to reading this article, I had never heard of a silo system before. [...]

Data Modeling for Big Businesses {2}

How has Mu Sigma, a data analytics company, become such a major player in today’s economy? With the vast amount of “big data” that fortune 500 companies are forced to deal with, companies are forced to either try to untangle their vast amounts of data by themselves or hire third party companies, such as Mu [...]

The importance of data modeling {1}

This article talks about the importance of primary key in data modeling. Selecting a unique primary key is very important because without a unique primary key or a weak key an attribute might share the same value .The article also talks about the importance of cardinality. Cardinality is a critical aspect of database design. Cardinality [...]

Green Servers {1}

The software development life cycle (SDLC) that is known focuses on the software and the system itsself and does not take into account of environmental factors normally associated with SDLC. Huang states that recycling at the end of the SDLC is not enough to negate the environmental impact. He include how IT has helped the [...]

Managing and monitoring server log data {1}

As data center keeping on growing in this technology fill business world. The important of maintaining correct and consistent server log is even more important than ever. It can help IT administrators and engineers create a proactive environment that protects it from current and future problems.  Tips to maintaining a safe and clean server is [...]