Working with myNet.Office Cloud Office myNet.Dbase. How to build Enterprise Relational Web Database System (RDBMS) using Cloud Office myNet.Dbase.
Enterprise Database Management System Case Study.

Click here go to Home page.

- We are the pioneers.

To run a successful and efficient business, organization in the Modern Economy, in the Information Technology and Knowledge Based Economy, required a lot of knowledge, manage, and process data and information. Business, organization mange and process data and information every day in the office. To design and build these RDBMS Database System costs thousands and thousands of dollars.

- If it costs you a lot of money to build these RDBMS, contact us. You need professional Data Scientist train and help you build and design your database. Data problems, garbage in, garbage out, cost business a lot of time and money. Having people not trained, no database skills to build and design company's database will cause a lot of serious problems, and damages, and integrity for business later on.

- If you want to work as Information System Analyst on these database application projects, contact us. You will learn a lot by working with our Computer Scientist, Software Engineer, Information System Database Developer. Any one, grade 12 can learn to design schema. We help a lot big and medium size non-profit Organizations, charity Organizations with thousands of employees.

Investor Relation: If you want any thing, please contact us. Thank you very much. We are both benefit. We invest almost our revenue into our R&D fund (Research & Development Fund). We already invested a lot of time & money in Product Development. Funding is very important for us to continue building best product. We can tell that the current product right now is like MS DOS version 1.1. If we had good resources, we can focus on R&D. We will bring this product from current level like MS DOS to more advanced level like Windows 8 in few years.

=> How best product if got funding? Confidential. But we can tell you that we want to build an Office that does not limit for ONE system, but for ALL systems. An Office is for every one, big, medium, small.

This project is big, not for a small team. We just want to build great product. Without adequate funding and resources, it is hardly to achieve big thing.

=> Funding also helps us bring the business to the next level of Business Development. We need to hire a lot of talented Business Development Managers, Sales and Marketing Managers.
This is the area we don't have experience and resource. We are new kids on the block. We want to bring Offices and build Offices around the world. Contact Us. Our job is to focus on Product Development. We know for sure that Cloud Database is very much easier to sell than to sell Oracle because Cloud Database is not expensive, and doesn't have complex IT Infrastructure hardware, server, network like Oracle. If Oracle Sales and Marketing people sold billions their Oracle products, then we will have no problems to sell Cloud Database. CEO Intel said: " - Many decades ago, we sold Intel CPU price more than 10,000$ / CPU for few thousands of customers. Today we sell Intel CPU price less than 100$ for millions of customers. And we still make more money."  You got the ideas.

Huge demand for Relational Database Market, Oracle is leading with 37 Billion revenue in 2012, then Microsoft SQL Server 27 B, then IBM DB2, SAP.. following. Cloud Databases, simple and affordable, easy to use, started step by step slowly taking away market share of databases. Big and small businesses are shifting in to Cloud Computing Infrastructure and Cloud Databases. Why? Because businesses will not spend huge budget and a lot of headaches for databases that use complex IT Infrastructure, hardware, servers, networks, disks, nodes...
Just 1% share of database market could translate revenue in hundreds of millions of dollars. Do the math, 2% - 3% share of database market could mean revenue in Billion of dollars.

- Contact us send email both addresses: info@NetthruOffice.com and ddanpros@hotmail.com. Thank you.


Having database is always better than having no database.

We had the Schema, Design of Database Information System Case Study for all types of businesses and organizations. We will add more Case Study. Click on the link below to see. Click here to learn How to implement Enterprise Relational Database.

Relational Databases or also called Schema Database, or SQL Databases, or Table based Databases, such as: Oracle, MS SQL Server, IBM DB2, SAP, Sybase, Cloud Office myNet.Dbase.. A lot Database Experts are talking about designing Database Management System, Database Software Application. But can't design schema. Don't even understand Database Schema. It is like, hire to the (wrong) Architect, who said can build the building, but can't design the architecture blue print, did not understand the drawing architecture of the building. As a result, company got A messy and chaos Enterprise Management Information System - A disorganized warehouse. Waste a lot of time to fix & maintain.

What is the Database Schema? The database schema or the diagram is like the blueprint of architecture. It describes the design of tables, their relationships, their keys...
These diagram are the Schema databases that had been designed using myNet.Dbase. myNet.Dbase
helped different sizes of businesses, big, medium, small sizes, and different kinds of businesses build EDBMS.

- Who are the customers, the businesses that are using myNet.Office, Office myNet.Dbase?
They are: Day Care Center, Schools, Colleges, Training Classes Center, Small Businesses, Mom and Pop's stores, Food Restaurants, Super Markets, Doctors Clinics Centers and Offices, Dentist Offices, Medical Centres, Rehab Treatment Centre, Football, Golf Clubs, Car Dealerships, Computer Stores, Video Rental Stores, Manufactures, Marketing Agencies, Music, Media & Entertainment Companies, Research Agencies, Global Technology Companies, Charity Organizations, Hi-tech Companies, E-Commerce, Online Businesses, Big, Medium, Small sized businesses...

 
- E-Commerce Website
- E-Commence and Customer ECampaign Information System
- Pizza Foods, Restaurants Delivery System
- Business Food Catering Services Management System
- A Mom & Pop Shop, Restaurant Customer Delivery System
- Church, Temple, Donation, Charity Organization System
- Nails, Salon, Hairdresser Appointment and Payment System
- Tutor Class, Training System
- Small Training Centre Students, Teachers, Courses System
- High Schools Database Information System
- College Teachers, Students, Classes Attendants, Behaviours  Tracking System
- College Student, Courses, Grades, Department System
- Another College Management System
- Another School, Technology College Management System
- Manufacture Document Management System
- Warehouse Parts and Distributors Information System
- Business, Store Management Work Flow with Products, Orders, Customers Information System
- Business Order Management System
- Business Product Catalog Database Management System
- Track Customer Order System
- Time Sheet Table Database Management System
- Accounting, Invoices, Sales, Customers Inventory Retail Store
- Social Case Worker Management
-  Agent, Customers, Leads, Activities Management System
- Day Care Centre Database System
- Medical Centre, Rehab, Treatment Centre System
- Doctor, Patients Visit Medical Clinic Centre System
- Medical Lab Database Information System
- Small Business Store Sales Management System
- Supper Market Store: Customer, Product, Order System
- Supermarket Inventory Control System
- Company Production, Inventory Management System
- CRM Marketing Data Database System
- Consulting, Clients, Projects, Resources Management System
- Organizer Project Events Information System
- Research Agency, Advertising Agency Database System
- Golf Club, Social Club Information System
- Football Club Management System
- Contract, Outsourcing Company Database System
- Car Sales Dealership Information System
- Help Desk, Problems Tracking Database Management System
- Accident Report and Tickets Management System
- Hotel Room and Access Booking Reservation Database
- Rental Apartment Company System
- Car Rental Management System
- Travel, Tour Event Registration, Booking, Payment System
- Ticket Master System
- Corporate Sales and Marketing Department Customers, Leads Management System
- Employee Tracking Schedule System
- Employee Data Mart
- Mechanic Body Shop, Car Service Center System
- Business Customer Service Management System
- Fundraising, Donation Charity Organization System
- Video Rental Store Database System
- Publisher Information System
- Library System
- Web Blog System
- Company Contact Management Database System
- Mom and Pop's Shop Vendor Stores System
- Small Business Vendor Information System
- Business Product, Invoice Order Inventory Management System
- Business Warehouse Inventory Management System.
- Business micro supply chain management system in a medium-sized manufacturer
- Parts Order, Items & Inventory Control System
- Vehicle Parts Manufacture' Database Management System
- Member Project Collaboration Management System
- Computer Hardware and Software Company System
- Computer Store PC Support Management System
- Car Parts Suppliers Database System
- Electronic Manufacture Products Bill of Materials System
- Paper Manufacture Bill of Material
- Manufacture's Product Problems and Issues Tracking Database Management System
- Global Technology Company Time Sheet 's Employee, Project
- Customer Data Warehouse Management System
- Customer And Campaign Management System
- Customer And Invoice Management System
- Customer And Order Model Management System
- Tracking Order Model System
- Customers and Products Management System
- Student Information Management System
- E-Commerce Shopping cart System
- Nursing Home Physical Data Model Database Application
- North City Community Medical Center Database Application
- Key Tec Manufacture Database Application

Easy Design RDBMS Model:
Most RDMS Systems here had not over 15 tables. So it is simple to design, to input data, easy to manage , easy to run.
NOTE: Database Application is also called Database Management Information System or DBMS.
- EDBMS or also called Enterprise Database Management System is an information system that is made by many Database Applications (= DBMS).

NOTE:
Almost Database Relationship here One-to-Many, symbol=
- PK
= Primary Key = The main key of a table. For example, OrderID is Primary Key of table Orders in E-Commerce website RDBMS.
- FK = Foreign Key = When you put the Primary Key into another table to create the relationship, that key is Foreign Key. For example, in table Orders, the CustomerID is the Foreign Key of table Orders, but it is also the Primary Key of table Customers.

Even after RDBMS already designed, in used, data input in, you can always add more fields like PHONE, TITLE, and change name, data type of fields, add more tables, more relationships without any effect to your RDBMS, without effecting that table. In order words, to meet your business's needs and grow on demand, you can always change tables, change fields in RDBMS any time without effecting data, table, RDBMS. RDBMS is always changing, growing, extending more tables more relationships on demand of your business.

To design RDBMS, the hard part is Data Modelling like architecture blue print. You can draw database diagram on white board or on paper.
The diagram doesn't create the code, the table, the relationship. To create Tables, the Relationships, you must write code to Create Table. We show you how to in this material: How to build an enterprise Relational Database Management System (RDBMS). Look at example Husbands and Wives RDBMS including SQL code to create tables and relationships. After you have designed Data Model, you will do Data Collection, Data Type, change, add, or modify table fields to fit your needs.. Finally Insert data, Data entry. These RDBMS here, most of them not complex and very easy to design. You just need a right tool. Every one can build it. A lot of fun because you are designing and building something big, An Information System, A Database Management System.

Here are steps to design RDBMS: 1) Analyze: What your business needs for database -> 2) Draw diagram of RDBMS Model: Like the architecture blue print -> 3) Data Collections: Including Data Type, what field is VARCHAR or INTEGER -> Then Create Table -> Then do Data Entry... 4) Use it: Write SQL Programs, Search, Queries...do what ever your business's needs.
- For the Maintenance Issues,
not to worry because the Cloud Data Center had IT people take care 24/7 the Hardware, the Network, the Backup, the Virus... a piece of mind. This maintenance worries most people if using database on Local Area Network (LAN) and PCs.

- myNet.Dbase has feature Save SQL Query lets you save the SQL programs. Then open it, modify it, change it, use it, run SQL programs many time again. Click see
Save Query

=> Click here to learn what you can do with myNet.Dbase in 30s

You can't compare what you design and build RDBMS here with business software used in office.
Database Management Information System
is what businesses, companies, corporations have invested tens of thousands to build their company's RDBMS. That's why Companies like Microsoft, Oracle have sold tens of billions their RDBMS software like MS SQL Server, Oracle.
RDBMS is not a business software. It is an Information System. A big difference between a software and an Information System. That's why businesses invested tens of thousands to build RDBMS.

You can also design and build many sub RDBMS into one big Corporate RDBMS.
For example, you build a Customer Order Delivery System RDBMS + a Customer Service and Appointment System + a Customer Relationship Marketing System + A Supply Part Dealer System + An Inventory Management System...

All your company RDBMS 's needs is approximately 15 SQL Programs that will satisfy all the daily needs.

How to input data in company's RDBMS? There are 3 different ways to input data in RDBMS:

1) Staff login myNet.Office website as Admin -> Open myNet.Dbase -> Click Browse Table on top left menu to list all tables. Click a table to open -> Click Data Entry / Insert also on the top let menu to enter data.
Click see myNet.Dbase Data Entry, Insert (Click picture enlarge).

2) Use myNet.Office Member Collaboration Form to create data entry form for tables in RDBMS -> Staff login Member Home as Member not as Admin -> Click on the Member Left Menu and enter data. This way, the company limit access to some staff by not let them login as Admin to access database RDBMS. You can setup to select table fields on the data entry form.
- Also use myNet.Office Member Collaboration, you can let staff, customers, members run reports, run pre-written SQL Programs, share and collaborate on RDBMS's data.
- Other databases, it is hard to do this because no built-in Member Collaboration. Need to hire developers to write programs to do these tasks. Thus cost a lot of money.
-
See How myNet.Office Member Collaboration to Create Member Collaboration Data Entry Form for your RDBMS.

3) Use myNet.Office Smart Form Builder to create smart form data entry for tables in RDBMS and post data entry form on the website so that customers, staff will enter data at websites. Or send the email embedding the data entry form Url link to the table in RDBMS if company doesn't want to post data entry form on website in public. Staff, customers open email -> Click on the form link to open the form to enter data.
You can setup to select table fields on the data entry form.
- Click see: *** How to create a Webpage with dynamic Menu, a Web Database of My_Support_Center, a Smart Form with Email Notification, an Upload Files Form, Resume Database without database programming, no web skills, all in 15 minutes ***


- Learn SQL. What is SQL? is Structured Query Language, Database Programming. It is used to communicate with database. It is a database language for Relational Database Managements (RDBMS). SQL is the ultimate power for database software because SQL database programming can do from simple tasks to complex database tasks that no step-by-step UI (User Interface), Windows interface can do. Databases like ORACLE, Ms SQL Server built in SQL.
- Learn SQL. Become myNet.Dbase Database Administrator:
Google Search for words: Learn basic SQL
-
SQL is, English-like language, easier to learn than learn database using interface. People grade 12 can learn SQL easily.
- Click here to learn SQL: http://www.infogoal.com/sql/sql-basic.htm
- myNet.Dbase has feature Save SQL Query lets you save the SQL program. Then open it, modify it, change it, use it, run SQL programs many time again. See
Save Query  
 

- ACME's E-Commerce Website and its Database RDBMS

- Top Menu
 
- EMT, World Wide Inc, Electronics Manufacture Products Bill of Materials Database Management System RDBMS


- Top Menu

 
A Finch Street Pizza Delivery Store 's Database management System - NOTE: This RDBMS can be modified for other Foods, Restaurant Delivery Information System.



- Top Menu

 
- A Finch Mom & Pop Shop, Restaurant Customer Delivery Database Management System


- Top Menu
 
NOT_AVAIL

Dezign Data Model for a Games/Video Purchase Store

- Top Menu
 
- A Video Rentals Store Database Management System - RDBMS  - NOT_AVAIL



- Top Menu
 
- East York Movie Video Store Rental Database Management System - RDBMS

- Top Menu

 

- MFP Industries Document Management System's Database Management System - RDBMS

- Top Menu

 

- St. Paul Church Donation Database Management System

- Used myNet.Dbase + myNet.Office eCampaigner + myNet.Office Smart Form Builder + myNet.Office Member Collaboration for table Users Login to see their history of donation if they want.


- Top Menu

 
- A King Street Mom and Pop Shop, Hairdresser Appointment Database Management System. 



- Top Menu

 
- A National Institute Organization Fundraising Database Management System - Used myNet.Dbase + myNet.Office eCampaigner + myNet.Office Smart Form Builder


- Top Menu
 
- International Media Solution's CRM Marketing Data Database Management System - Used myNet.Dbase + myNet.Office eCampaigner + myNet.Office Smart Form Builder


- Top Menu
 
- North York Toronto Car Sales Dealership Database Management System

- Top Menu
 
- A Finch Street Computer Business Help Desk, Problem History Database Management System


- Top Menu
 
- Compass Marketing Research Agency 's Advertising Database Management System


- Top Menu
 
- TMA Solutions, Outsourcing, Services, Consulting 's Clients and Fees Database management System - RDBMS



- Top Menu
 
- Northern Wood Community Day Care Centre Database Management System - RDBMS



- Top Menu
 
- EVN Auto Mechanic Car Service Centre Database Management System



- Top Menu
 
- Toronto North Community Medical Centre Database Management System - RDBMS


- Top Menu
 

SG Paragon Department Store' Database Management System

- Top Menu
 

Wendy Nails Salon Hairdresser 's Database Management System - RDBMS

- Top Menu
 
- Net Thru, Inc Contact Database Management System - RDBMS


- Top Menu
 
NT Manufacture, Inc  Physical Data Model for Bill of Materials Paper Warehouse


- Top Menu
 
- A NSAT, Inc Tutors Students Training Class Database Management System

Microsoft Access Relationships diagram showing one to many relationships between the Tutor table and the Tutorial table; between the Tutorial table and the Student table; between the Student table and the Result table and between the Assessment table and the Result table.  Each table has its own attributes listed and the one to many relationships directly link the primary key of the table on the one side of the relationship to the foreign key in the realted table on the many side of the relationship.

- Top Menu
 
 - A Store Vendors, Customers, Products Database Management System
  


- Top Menu
 
- Small Business  Accounting, Customers, Invoice, Sales, Inventory Database Management System



- Top Menu
 
- A Dundas Restaurant's Customer Order Tracking Database Management System - RDBMS



- Top Menu
 
- Brampton Toyota's Car Part Suppliers Database Management System - RDBMS



- Top Menu
 
- A Lawrence Business Stores Database Management System
The ER diagram shows the attributes of each table, in conjunction with many to many relationships decomposed into new (associative) entities which in turn have one to many relationships between them and the other entities previosuly joined by a many to many relationship.  The diagram shows one order lists many order-lines and one product exists on many order-lines.  Additionally, it shows a product exists in many product-locations and one warehouse stores many product locations.

- Top Menu
 
- North Golf, Club Database Management System - RDBMS



- Top Menu
 
- A HCN, Inc 's Customers Campaign and E-Commerce Database Management System - RDBMS



- Top Menu
 
- AVT's Accident Report, Tickets Database Management System - RDBMS



- Top Menu
 
- A Hi-Tech Grandma Pc, Inc Computer Store PC Support Database Management System - RDBMS



- Top Menu
 
- VNBTS Supermarket Customers Orders Shipments Database Management System

- Top Menu
 
- A Mississauga Warehouse Distributors Management's Database Information System



- Top Menu
 
- A City Medical Centre Doctor Patient Visit's Database Management System



- Top Menu
 
- A Finch Store Sales Database Management System - RDBMS

 

- Top Menu
 
- CBNI Agency Rentals Car Database Management System


- Top Menu
 
- Cross Country 's Parts and Distributors Database Management System



- Top Menu
 
- SCT Consulting, Inc Clients, Projects, Resources Database Management System RDBMS

Entity Relationship diagram used for storing timesheets

- Top Menu
 
- A York High School Database Management System - RDBMS


- Top Menu
 
- Global Services Company 's  Customer Services Database management System



- Top Menu
 
- A Medical Clinic Database Management System


- Top Menu
 
A Publisher Database Management System



- Top Menu
 
- Library Application database schema



- Top Menu
 
 - Member Working Project Database RDBMS



- Top Menu
 
- A HB College's STUDENT GRADING SYSTEM Database RDBMS

- Top Menu
 

 
 A HB College's STUDENT, Teacher, Classes INFORMATION SYSTEM


- Top Menu
 
 
- Teacher and Students Database Application RDBMS


- Top Menu
 
 - Western Glass Productions Inc, Inventory Management System RDBMS



- Top Menu
 
- BLOG Database RDBMS

Entity-Relation Diagram of the Blog Database
- Top Menu
 
- Buskro Ltd 's Sales Vendor Database Application
Entities: types of informationdata model after normalization
- Top Menu
 
- East Valley Furniture Company Database Management System RDBMS

-

- Top Menu
 
- A Private College Database Database Management System RDBMS

SARA database entity diagram
- Top Menu
 
- A Real-estate Apartment Rental Company's Database Management System DBMS


- Top Menu
 
- APT Hardware and Software Computer Inc Database Management System RDBMS       

- Top Menu
            
- Parts, Items & Inventory Control for ConAgra Grocery Products Database Management System DBMS



- Top Menu
 

- Hotel Sun Rise Inc, Room and Access Booking Database
RDBMS

Remodelled Booking System Entity-Relationship Diagram

- Top Menu
 
- The implementation and evaluation of a micro supply chain management system in a medium-sized manufacturer



- Top Menu
 
- A Lawrence Catering Services Database Management System RDBMS

   

- Top Menu
 
- Employee Project's Events Information System Database Management System DBMS
ERD

- Top Menu
 
- Northville School College Database Database Management System RDMS



- Top Menu
 
- Business Products, Orders, Customers Database Management System RDBMS




- Top Menu
 
-  Mississauga Football Assistant Database Management System RDBMS

FFA_ERD.png

- Top Menu
 
- A Personal Resource Planning Database Management System.


 

- Time Sheet Table Database Management System RDBMS



- Top Menu
 

- Assets Management Database RDBMS
- Transgear Manufacturing Vehicle Parts Manufacture' Database Management System



- Top Menu
 
- Vaughn Manufacture's Product Problems and Issues Tracking Database Management System


- Top Menu
 
- A Mississauga Supermarket Inventory Control



- Top Menu
 
- Business Product Catalog Database Management System



- Top Menu
 
 - Asia Tour Event Registration


- Top Menu
 
- Canadian International Entertainments and Productions, Inc Ticket Master System


- Top Menu
 
- Corporate Agency's Sales and Marketing Department Customers, Leads Management System


- Top Menu
 
- North Community Social Worker Case Management


- Top Menu
- Tracking Employee Schedule


- Top Menu

- Employee Data Mart

- Top Menu
- Agent, Customers, Leads, Activities Management System


- Top Menu
- FPT Global Technology's Time Sheet for Employees, Projects


- Top Menu
 
- Company's Customer Ware House Management System


- Top Menu
 
- Company's Customers and Campaigns Data Model


- Top Menu
 
- Company Customers and Invoices Data Model Management System


- Top Menu
- Company's Customers And Orders Model Management System
 

- Top Menu 
- Company Tracking Customer Orders Physical Model Management System


- Top Menu 
 
- Customers and Products Management System

- Top Menu 
- District 10 School Management Information System


- Top Menu 
- Net thru E-Commerce Shopping cart System

- Top Menu
 
- Nursing Home Physical Data Model


- Top Menu
 
- North City Community Medical Center Database Application


- Top Menu
 

- Key Tec Manufacture Management System Database Application
 
- Key Tec Manufacture's General Physical Data Model (only a part of whole Key Tec Manufacture Architecture)
 



- Key Tec Manufacture Product Area Data Model Database Application

- Key Tec Manufacture Financial Area Database Application

- Key Tec Manufacture Customers Orders Area Data Model Database Application

- Key Tec Manufacturing Area Data Model Database Application

- Top Menu