• importance of a good database 
  • the five stages of a database 
  • requirements gathering
  • implementation 
    • it needs the special storage related constructs to house the end user 
  • conceptual vs logical 
    • enteties and atributes 
    • relationship between each table with a primary key and a secondary/foreign key 
















































Comments

Post a Comment

Popular posts from this blog

Image
Cloud Computer - The Elastic leasing of pooled computer resources over the internet Elastic because it can flex Computer resources cause you Pooled -Virtualization Virtualization - process by which one computer hosts the appearance of many computers. Operates as if installed on one’s own computer Leasing - don’t own the program, you own a license/right to use the program Over the internet SaaS Software as a service, you don’t install these yet they’re considered software PaaS (platform as a service; for big project managers and creators/developer IaaS Infrastructure as a service, Most commonly used Virtual Private Network(VPN) Lots of question on it How do Organizations use Cloud Services Securely? VPN client software that encodes messages Click on the software, input the key, then it creates a tunnel. Whenever you need to send something, that VPN encrypts your message, making readable data unreadable. Once it ge...
Read more
Image
How Do CRM, ERP, and EAI Support Enterprise Systems Help organizations rethink how they do work. Inherent processes Prebuilt procedures based upon “industry best practices.” Save money and time in business process reengineering. Eliminate costs of developing complex applications in-house. Customer Relationship Management Suite of applications, a database, set of inherent processes Could adopt as a stand alone system, or one of the modules within an ERP package. But the CRM system only affects the Customer Service Department, nothing else. Manage all interactions with customer through four phases of customer life cycle: –Marketing, Customer Acquisition, Relationship Management, Loss/Churn Every contact and transaction with customer is recorded in CRM database Solicitation and Lead management Application Sales Applications Relationship management applications Customer Support Applications ERP Everything above and Huma...
Read more

database

what is the purpose of a database organize and keep track of things table = file columns = field records = rows components of database tables or files and relationship among rows in tables and metadata = database field = primary key in one table and secondary key in another table what is database management system ( dbms) program used to create, process, and administer a database licensed from vendors such as IBM, Microsoft, oracle and others DB2 from IBM, access and SQL sever from Microsoft, oracle database from oracle corporation MySQL - open source, license- free for applications 3 types of database models relational data base student file student CIN last name middle initial and first name major address street city state zip code faculty file CIN last name middle initial first name department city state zip schedule of class class number class name section date time instructor object oriented database name of object = l...
Read more