Working with myNet.Office, Net.Office Cloud Database. How to build A Cloud Enterprise Database Management System (EDBMS) using Net.Office Database.

Using myNet.Office, not only you can build the high-end E-Commerce Ecosystem, but also you can build the Enterprise Database Management Information System, Cloud Business Database Application Software as a Service website. All-in-one Net.Office solutions.

- Level: Grade 12, Web Designer, Web Developer, Software Engineer, Database Administrator. People with no web skill, should not worry because we will make it simple, so that you can build your own EDBMS. We had moms and pops 's store with no database skills build their own EDBMS. If you are corporate employees, managers then you should have no problem to understand.

Businesses and Organizations are governed by Data and Information.
Businesses, organization spend tens of thousands, even hundred of thousands to buy SQL Database System, like MS SQL Server, Oracle, IBM DB2... in order to solve their business problems because they understand cheaper business software package is not powerful to solve business problems. Database helps businesses, organizations solve simple and complex problems fast and efficient. =>That's why database costs a lot more than software. For example, an Oracle database could cost hundreds of thousands while a software costs few hundreds.

- All database applications, its data integrated into one centric database. Thus is easy for sharing, collaborating data. No silos. No back & forth.

- Silos means: In a company, there are different Managers in different departments run, use, manage many different software application in different places, different locations. These software don't integrated, communicate, and share data each other. Back & forth, time consuming.
- See in What's new.

- We are the pioneers in smart web.
- Good products got started humble in the beginning.
 

- In one Cloud Net.Office Database, Net.Office Database, company can build many different software applications for: HR, SALES, FINANCE, MARKETING, SERVICE, CRM,  MANUFACTURING, SUPPLY CHAIN, PROCUREMENT, EMAIL MARKETING SYSTEM, ECOMMERCE..
See:
EDBMS Case Study

- All-in-One Net.Office Solutions for all kinds of Businesses, for all kinds of Departments, for all kinds of Applications.

- myNet.Office is not only the high-end E-Commerce Ecosystem, but is also the Enterprise Database Management Information System, Cloud Database Application Software as a Service website.


- - Net.Office Database is the first generation of photo and social web database.
- Click on photo to view enlarge.  
What will you expect from this How to tutorial?

=> We show you how to build an Enterprise Relational Database Management System (EDBMS). How Data and Information are collecting, processing, and analyzing?

A Relational Database Management System (EDBMS) is a Database Management System (DBMS) that is based on The Relational Model as introduced by Computer Scientist E. F. Codd.

EDBMS allows business to build large enterprise database made up by hundreds of tables that are linked and related each others.

The technology required in order to build and manage Relational Database Management System (EDBMS) is SQL Database Programming Language.

Building EDBMS using MS SQL Server is very expensive. For example, let’s say you have an x86 server with two eight-core Intel Xeon processors. Previously, you would pay for two processor licenses at $27,495 per processor. Final cost: $54,990. But if you upgrade to SQL Server 2012, you’ll be paying for 16 processor cores at $6,874 per core. Final cost: $109,984, or about twice as much. MS SQL Server Database and Server Tools, 20 years in the making, generated 27.10 billions of dollars, up 11% in sales in 2011.

If you want to learn, please be patient because this material is a bit harder than other material. But mind opening.. We will try our best to navigate and explain the difficult topic.  
 

After this tutorial, you will know:

1) Not only you know how to build A large Enterprise Database Management System (EDBMS), with hundred of tables, using SQL Database Programming built-in Net.Office Database.

2) But also you know how to build databases for your big online business, big e-commerce website. Database empowered website.

3) EDBMS Case Study. Click here to learn
EDBMS Case Study Examples. => Used Net.Office Database to design and build all these EDBMS in Case Study.

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 Net.Office. To design and build these EDBMS Database System costs thousands and thousands of dollars. If it costs you a lot of money to build these EDBMS, contact us: info@NetthruOffice.com.

Don't waste your time, your energy, and money to manage data and information. No more back and forth.


-
Without Technology and the Internet, small business doesn't leverage all its potential, and it is very hard to grow business to next level.

-
To modernize economy should begin with bottom up small business. Invest in small business Innovation. And encourage small business investing in Innovation.

 

- In any country, 90% of businesses are small businesses. There are millions of small businesses, mom and pop's stores. Small business is the foundation of the economy, and the pillar of the middle class. If each small business is modernize, innovative, efficient, reaching out more customers, global, and growing. Thus each small business will create just 1 job. Which means millions of jobs created.

- Wang Lu, CTO of an Internet company, also
an Internet business adviser, a Tech Evangelist, is talking at a Chinese Business Conference.

- People, like Wang Lu, played very important roles in helping to transform China from Economic Revolution to Innovation Revolution, and modernize China Economy.

- Corporations, Organizations, Government, Venture Capitals should invest in Cloud Based Technologies, the next big thing, that help small & mid sized businesses increase revenue, productivity and efficiency. Every one would benefit from this investment.
 
In the Internet age, in the new Economy, to run a global company, you don't need to travel the world, and your local business still can reach people anywhere, and sell products and services 24/7 any where, and around the world. All you need is Cloud.

Without the Technology and the Internet, small business doesn't leverage all its potential, and it is very hard to grow business to next level.


Do we need to have database and EDBMS for online business website, e-commerce website?

Small simple online business, small simple e-commerce templates, or small simple e-commerce websites may not need database, and EDBMS. But not recommended because database is the foundation of business website, e-commerce websites.

Database empowered website. Website no built-in database, no EDBMS, is hard to do serious online business. Will be a waste of time and money later on in order to re-design.

Let's say your company is building an e-commerce or a serious business website. EDBMS database chart is the blue print, the architect, the foundation of your website. It is like building an Net.Office building without the architect, the blue print.

Picture:
This diagram courtesy from Net.Office Database EDBMS for an e-commerce website.

- This is example of a simple E-Commerce website and its Enterprise Database Management System (EDBMS).
NOTE: Complex e-commerce website will have more tables and more relationships as online business grow.

Click here see Net.Office Database search into multi 6 tables: Orders, OrderDetails, Customers, Products, Suppliers, Employees. Then return all values. This is an example we said that e-commerce website without database EDBMS is not leverage all its potential, hard to manipulate data collecting from website. It is hard to do serious e-commerce website without EDBMS. Therefore, E-commerce website should be built on a EDBMS structure as we proposed.

For example, e-Commerce question. For sure your e-commerce website must have tables in order to store Orders, Order Details, Products, Suppliers, Shipping...
- The question is: Can your e-commerce website do a simple basic JOIN multi table query in order to gate data like this example?
- Every day,
businesses have to deal with Orders, Products, Suppliers, Shipping, Customers, Employees. These are the based components of business.
-
How can staff get a lot more data and information
, so quick and so fast, time efficient of each Order, each Product Stock Inventory, Unit on Order..., the Supplier of each Product, each Shipping, each Customer, each Employee by just 5 seconds hovering the mouse on each key, like CustomerID, EmployeeID? There is no wasting time, days of back and forth, Email, Phone, asking for : - When will be shipping? How many products in stock inventory, its supplier? Who is customer more detail info? Who is employee responsible for this order? Can your e-commerce website doing like this? All about Data Collaboration and using database EDBMS as a centric data updating instantly, sharing and collaborating.
- How long does it take your company, staff to gather all detail information updated instantly about: Order, Product, Shipping, Supplier, Total Sales, Tax, Employee responsible for this order?  Click here.

 

- A lot of businesses, organizations, because lack of knowledge, and having web designers, web developers, also lack of knowledge, as a result, they built e-commerce website, business website that have no tools, no SQL, no EDBMS. As a result, the business kept depending completely on the web designers, web developers for the maintain. And when businesses can't afford web developers no more, as a result the website is abandoned, left alone, static. No one maintained. ** Not only businesses lost money, lost time, but also lost businesses because they can't sell products and provide services **
This is the reason to stop businesses to go next level.

-
Click here to learn EDBMS Case Study Examples. => Used Net.Office Database to design and build all EDBMS in Case Study.

Ask the developers, the web designers, the web company: Show the construction of website database and tables. Good luck.
In business, every thing is about data. If database tables are not linked or not related according to the Enterprise Model (EDBMS), then it will be the big problem for your business because the business database are not properly designed. It will cause a lot of problems to process data and information later.

Do you trust that developer to build the site? Can you do business with website without EDBMS?


Depending on whom you talked, every IT, developer had their own ideas and tools they used and recommend. Usually people will recommend their own tools.

Database is the foundation for business website.
Can't do serious online business, e-commerce with website without database.

- Rather than simply refraining from cheating customers or lying to them, a company that wants to enjoy the trust of customers in the future must proactively respect the customer's interest - suggesting ways to save money or get better service even when the company might not profit as much. A trustable company, for instance, would warn customers if they're about to make a mistake and order more than they need, or if they could save money on a different plan or pricing program.

-
Some companies, web consultants misled people, consumers, businesses by trying to make their products and services so easy and simple for people to buy. They advertised using their products and services will help you build business website no need to learn or to do anything. Such as:

"- Few clicks then you have e-commerce websites to sell online. Simple!" . -> Gook luck.

"-Your business just needs nice basic static information website."  -> Tell the web consultants upgrade skill to learn myNet.Office so that they can give good advice.

"- We build for you business web site, e-commerce and you don't need to learn or to do anything." 

-> Which means the web designers will take control every thing. Right. Don't let any one control your business. When you paid they will be there. When you can't pay. No one there. Gook luck.

As a result, either business will get static do nothing nice web site or depend on others to take care. Either one is no good. Cost even more time and money to pay for people to maintain.

In this modern economy, smart phone is not enough, people also need smart web.

- Click here to learn what you can do with myNet.Office in 30s

- Click here to learn what you can do with Net.Office Database in 30s
 


- How is your website doing?

" We don't want to talk badly our web consultants. We trusted our web consultants who recommended: Your business just needs nice basic info website. As a result, for many years our nice website has been doing nothing. Website should help our business do a lot of things in this New Economy, the Internet Age...But our static website is still doing nothing. We can't even update and maintain our basic website. Where are the web consultants now? When you paid they will be there. When you can't pay. No one there. What a lost for our business many years using static website. "

- Now using myNet.Office, not only we can build E-commerce website, sell our products and services, build Database EDBMS for our business, Email Marketing, Online Marketing, Collaborate with people, and do a lot other online things, but also we can update and maintain our website.
Our philosophy: We designed myNet.Office simple for people with no web skills can build and maintain productive smartweb. That's why we design myNet.Office Cloud Commerce so easy so that you can build and maintain e-commerce website by yourself without web developers, without any web skills.
NOTE: We said without any web skills but we didn't said that you don't need to do or to learn.

However, when building enterprise Database and EDBMS,
we try to make everything simple, but we can't make EDBMS simpler. Compared to other databases like Ms SQL Server, ORACLE, even Ms ACCESS, Net.Office Database is still very easy to learn and to use. Net.Office Database and Ms SQL Server both used EDBMS, and SQL as their database programming languages.

We already build database EDBMS in myNet.Office Cloud Commerce, so you don't need to know EDBMS if you just want e-commerce website. Ofcouse, you can always extend myNet.Office Cloud Commerce's database EDBMS more tables and more relationships.

- We all agreed: Everything should be made as simple as possible. But there are things we can't make simpler then we need to learn.

For example, the Customer database of myNet.Office Cloud Commerce has primary key = CUSTOMERID. Then you create a table CouponPromotion database in order to give customers coupon and promotion. Since this relationship is One-to-Many. So you just need to put the primary key of table customer = CUSTOMERID in table CouponPromotion. That's is it. See How to create One-to-Many Relationship, click here.

Case study.

MyRestaurant.com is online restaurant that provides services and online delivery to more than 100 cities in the country.
A company MyRestaurant.com needs a database system used for both online website and offline Net.Office integrated.


The database is used to store data and information of Suppliers, Categories, Products, Orders, Invoice Order Details, Employees, Customers, and more...
The same database is used for both order online e-commerce website, and offline Net.Office used. No separation.
If you are their employee, how can you build?

Compared to other databases like Ms SQL Server, ORACLE, even Ms ACCESS, Net.Office Database is still very easy to learn and to use.


Company needs a database system.

TOP 10 why business choose Cloud Net.Office Database for EDBMS over other databases.
1) ** The Cost ** Net.Office Database is no licenses, unlimited Users.  
Business, specially small businesses less than 30 employees, and mid-sized businesses, don't need heavy duty big name databases that cost too much, and the headache of the complexity of IT infrastructure, the complexity of Software Installation and Deployment, IT people, PC File Server, Network LAN, Backup, Viruses, PC Server hardware malfunction, Lost data...
     
2) Net.Office Database lets you send email, Texting, Email Marketing from database. People Opt-in / out. Built-in Auto Reminder feature send email, Texting to remind customers appointment, payment, customer services...
- For example, you build a EDBMS for your store, your company, and you want to send out email to all customers based on criteria, such as: email a coupon promotion  5% OFF to all customers who bough over 100$, in your business Customers and Contacts database. Bring customers back to store. People can opt-in, opt-out.  You can setup an Auto Reminder to send email or Texting to customers on that day, remind them to return video rentals, see appointment, do a customer service, or pay invoice. This is hard to do for other databases.

3) Net.Office Database inserts Photos, Files, Videos in table. Searching, Sharing Photos, Files. A picture worth a thousand words.
- For example, you want your Product database, Resume database, or Document Management database, or Customer Invoice, Order database having table fields embedded with PDF, Word, Excel, Videos, so that when you search, you can see its related documents and its photos. Click to open files, share files like a File Cabinet. This is hard to do with other databases. For example:
- A Resume Database Information System that stored Resume Files submitted from website, or uploaded files from PC in database.
- A College Database Information System stored student's assignments, exams, related scan papers uploaded from PC, or submitted from website in database.

- A Video store, Mom and Pop Retail stores, Nails Salon Store Database Information System that stored scan invoice papers, documents submitted from website, or uploaded from PC in database.

4) Net.Office Database lets you access, work, share database from anywhere. Access anywhere from Internet. Work, share EDBMS any where at home, in the Net.Office, in warehouse, any location around the world. No need to setup networks, cable wired.

5) Use  Net.Office Database, no worry about computer file server's IT back up, maintain, virus protection, computer server hardware broken, malfunction. Because database is in Cloud Data Center where there are IT people 24/7 to take care, back up your database.

6) Net.Office Database worked with online stuff, such as with e-Commerce, Web Collaboration, Smart form, submit register online, donation online,  pay online, email. 
- For example, you use Net.Office Smart Form Builder to create a Donor form, then launch an Net.Office eCampaigner to all Donors in Donor table, in Contact table as well. People donate using credit card or Pay Pal. They can also update their info such as: phone, address in Donor table. This is hard for other databases, specially PC database software. Because PC is not file server, can't use as file server. And PC does not allow people outside update data of its database on PC.
- Data Entry Smart form, another example, your Database Management Information System needs input data from customers, members. So you use myNet.Office Smart Form Builder to create forms as table data entry for your EDBMS at website so that customers, members can use website forms to input data. This is hard to do with other databases because don't have Smart Form Builder  tool built-in.

- Security, another example, some times, you don't want some staff to login as Admin and access your EDBMS. So you use myNet.Office Smart Form Builder to create many forms as Data Entry for your EDBMS. Staff then login as members in Member Home area of your database system website, not as admin in Admin area. Then do the data entry. This is hard to do with other databases because no Member Collaboration Tool built in.
NOTE:
Security is implemented using myNet.Office Web Collaboration as well. Other databases didn't build in Member Collaboration tool in their databases. Please see myNet.Office Member Collaboration Tool.
Use myNet.Office Member Collaboration Tool, you can create as many as Data Entry Form as you want for staff to login as Member to input data.
- You also can create many collaborations, such as: See Listing Order Invoice, for your staff, your members, your customers to collaborate, to work on company's EDBMS without login as Admin.

- See example, How to use myNet.Office Member Collaboration to Create Member Collaboration Data Entry Form for your EDBMS. 
- See How to Create Member Collaboration Login Update Account Info, such as: Name, Phone, Address, Password...
- See How to Create Member Collaboration Order Status History List.

- See myNet.Net.Office Login Member Collaboration Home Account
myNet.Office Member Collaboration brings your company's EDBMS to next level. Sharing and collaborating data and information with people.
From Database Management Information System that is used within company only, to next level, that is used company's EDBMS in order to provide services, to share data, and collaboration with customers, with members, with staff. In Member Collaboration, the business, the red one, is the Master of Collaboration.
It is all up to your company if wanted to collaborate company's EDBMS with other people, with customers.
What is myNet.Office Member Collaboration? It lets business map or connect to any table in EDBMS, and to create collaboration tasks for Customers, Members, Staff to act or collaborate on its data and information of tables in EDBMS. More?
See Member Collaboration. Click here

For example, you build a EDBMS for a Company's Rental Video, for a Mechanic Body Shop Services Center, for a Business, School, Organization Information System, for a Mom and Pop's Store Customer Order Management System. This Database Management Information System so far has been used within the company in order to manage data and information. But then the company wanted to shared this EDBMS with customers for better customer service, and better operation, time efficient...The company then designed many Member Collaborations. As a result, the customers of that Video store now can login as Member to view their invoices, view their profile, the date to return the rent movies. Update their Account, phone, email.. What movies they had rented. How much they still owed. Get coupon or check promotion. Recommended them new Movies, Videos just released. Pay online. Remind members, customers an appointment, a payment...The Mechanic Auto Service Center can update their service with customers online. Let them know when to bring car back for change oil filter, other services, or pick up car, service already done. Business engaged with people.. So on... ** The collaboration of customer services is unlimited. The collaboration with people is powerful. The collaboration helps business automation and productivity. **
The company's EDBMS now expanded more tables, more relationship...Love it.
myNet.Net.Office Member Collaboration is used and applied in any EDBMS Case Study Examples.


7) Use Net.Office Database for your data in one centric database location. Thus your data is not stored in every where, in different places, hard to control.

8) Use Net.Office Database for all database purposes like: for
e-Commerce, for website database, for Email Marketing database, for business's Database Information System EDBMS...

9)
Unlike most other databases are standing alone as a database. Net.Office Database, not standing alone, but together with myNet.Office Smart Form, myNet.Office Cloud Commerce, myNet.Office Email Marketing eCampaigner, myNet.Office Web Collaboration, myNet.Page Webpage Builder, myNet.Word, all integrated in one, give you a complete Net Net.Office solutions for your business.

10) Net.Office Database, like MS SQL Server, run, exec SQL and EDBMS. You can do anything database with SQL. The ultimate power for database software.


- Learn SQL. What is SQL? is Structured Query Language, Database Programming. It is used to communicate with database. It is a database language for Enterprise Database Managements (EDBMS). 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 Net.Office Database 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
- Net.Office Database 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. Click see
Save Query (Click enlarge). 



Cloud Database and PC Database - What are the differences? Let's explain it easy to understand.


Picture: Cloud database like Net.Office Database runs on Cloud Data Center. PC Database runs on LAN.
See:
Video of A Cloud Data Center

Picture: Big Cloud Computing Servers hosting and running Net.Office Database.
Cloud Databases. VS. PC Computer Servers running PC Databases.

- Cloud Databases and PC Databases, although big differences in infrastructure, each served different benefits to consumers.

 
1) Web database can do stuff, work online. Businesses use web database for Electronic Campaign, Email Marketing, eCampaigner, for Submit Form, Register online, Pay online.
- But, PC Database can't do online stuff. Example, PC Databases can't do electronic campaign. Can't register, can't submit form online. Can't process payment online.

- Because web database runs online in Cloud, thus it can do online stuff. Because web database uses the big Internet, mother of all networks, as its network, it can be accessed anywhere, out of the limited physical boundary of Net.Office. Only web database can send emails to customers. Let them fill the smart form, register online, and pay online. People can update their data, info stored in web database, but not on PC databases. They can opt-in / opt-out on web database, not on PC database.
- PC database runs on PC in LAN, limited, protected in small area of local Net.Office network of company. Thus can't do online stuff. Can't reach, can't work anywhere. People can't update data on database from outside.
PC databases on small PC computers can't server thousands of people around the world, but good for server local people in local Net.Office.

For example, you have database Contact List, Customer, Donation database storing on PC Software, PC Databases. You want to send email, eCampaign to all people, to customers in database Contact List. And you want them to register, submit form, order and pay online. You can't do it on PC Software, PC Databases because people can't opt-in, opt out, as required by Electronic Email Campaign Act that people must be allowed to opt-in or opt out to receiving email. People can't update their info, such as address, credit card number, phone, email... in your Contact List on PC Software, PC databases. They can't submit form, can't register online, can't pay online if your Contact List in PC Databases. PC Database Server is not powerful enough to server many people, and around the world.
2) New young Cloud Computing Infrastructure VS. Decades old LAN, PC Computing Infrastructure.
Web databases are built on the new young infrastructure Cloud Computing while the PC databases were built on the old infrastructure of LAN, PC Computing, decades old before Cloud Computing.
That's why we can see the philosophy of software between Web databases and PC databases is BIG difference because of their differences in infrastructure.
Each has its own benefits for consumers.


NOTE:
Database Software Market is tens of billions of dollars in sales / year. It is a very big software industry. Database MS SQL Server has generated in billions / year in revenue for Microsoft.
*** Businesses in different sizes all used database. Ask why my business doesn't have database ***

3) Web databases: Access from any where out side the limited small local Net.Office network (LAN). PC Databases can't.

- Web database runs on the Internet, used the Internet, Mother of all Networks, as its Network. Thus can access, work, share, collaborate from any where. All you need is Internet connection.
- PC database on PC, in LAN can't access from any where. People must be in the Net.Office Network (LAN) to use PC database.

4) Web databases run on big Servers from Cloud Data Center had more power, can serve more users. PC Databases run on PC computers, Local Area Network (LAN).
- Web database runs on big computer servers from the Cloud Host Data Center, and used Internet, the Mothers of all Networks, as the Network. Thus, it can server for thousands of users.
- PC database runs on small PC server in LAN. It can provides service to small limited users who can access and work on PC database

5) Use web database no need IT staffing to back up, maintenance, virus protection. But PC database needs IT staffing. 
- Because web databases run in the Cloud. There is already IT staffing at the Data Center Network 24/7 take care the computer servers, networks. They daily back up data, maintain, virus protection... Your company has a peace of mind running web database servers on their Cloud Data Center.
- Using PC database servers, company needs IT people back up daily, maintain, virus protection PC server running database server software.

6) Use PC database sever, easily hardware broken, mall function, easy defect by small PC computers, by small PC servers. But that is not happening for big Cloud Computer Servers at Cloud Data Network Center.
- Hardware broken, defect, malfunction, infected by virus happened all the time
to PC Computers, PC servers running PC database software. If you had a PC computer, Laptop, you know it is true, happened many times: viruses, mal functions, broken...
- Big computer servers of Cloud Data Center never had hardware broken, defect or mal function. Another peace of mind for your database.

7) Web database can be used for as online database, as website database, and as replacement of offline database, centric database for all offices, all locations. PC database can't be used for online, and not for website.
- Web database, you can use for both online, database for website as well as for in-house database. No need two different databases because it is hard to control and manage data in different places.

8) The ultimate cost. Web Database virtually cost 0$. A fraction cost paid for Cloud Data Center.
- Use PC database cost hundreds of thousands dollars to set up networks, and buy a lot PC database servers, and licences for 1000 users.
For example, MS SQL Server is very expensive. Let’s say you have an x86 server with two eight-core Intel Xeon processors. Previously, you would pay for two processor licenses at $27,495 per processor. Final cost: $54,990. But if you upgrade to SQL Server 2012, you’ll be paying for 16 processor cores at $6,874 per core. Final cost: $109,984, or about twice as much.
-
Use web database like Net.Office Database. Cost virtually = 0$
. Cost only a small hosting fee paid for Cloud Host Data Center.
Because the Cloud Data Center already provided its big computer database servers, and networks. Business doesn't need to buy big computer servers and set up big network for 1000 users.

Cloud Computing has reduced the cost. "- The economics of cloud computing are driving down the cost structure of business so far and so fast that it’s scary.."  Google CIO Ben Fried says. Read:  Google CIO Ben Fried Says Cloud Tipping Point Is At Hand.

9) The big Banks, the big Financial Institutions already used and stored their data and information in their big Cloud Data Center, for their hundreds of billions of dollars businesses. The big corporations already used, worked and shared  databases online, corporate database, customer database, contact list, invoice database... online, serving millions of customers around the world. Businesses in different sizes also backup their data and information in Cloud Data Center. Data is Safe and secure on Cloud than on PC, LAN.

In the new Economy, it is hard to become big business, hard to expand business, hard to compete with global, hard to expand business global, if your business are not seriously online.
 

- IT staffing at Cloud Data Center, 24/7 take care and maintain servers, networks of Data Center.


- The big corporations, the big banks, the big financial institutions already used and stored data and information in their big Cloud Data Center, for their hundreds of billions of dollars businesses.

- Web database are used for
online database, website database, and offline database, centric database for all offices, all locations. All data is in one location, not every where, not in different places.

- Businesses are shifting on Cloud.
What is the difference between database software using Database Programming SQL, and database software application using UI (User Interface), Windows Interface?

- Database Software using database programming SQL, like Net.Office Database, MS SQL, Oracle... gave you the ultimate power to do from simple database tasks to complex database tasks. You can build a big Enterprise Enterprise Database Management System (ERDBMS). You can write SQL database programming code to operate, manipulate, and search data deeply in to multi tables, nested hundred of tables.
You can also change, alter the table structure. Back up tables. Drop table fields. Add keys. Add more table fields. Change table data type. Without SQL, database software had to design UI Interfaces for users to do these tasks.
YOU CAN DO ANY THING DATABASE WITH SQL... All depends on your knowledge of SQL. GOOGLE for SQL syntax if you don't know.
However, database software using SQL doesn't have nice UI and interfaces. So it is hard to learn. SQL IS FOR SERIOUS AND COMPLEX DATABASE DEVELOPMENT.

- While, Database Application Software using step by step UI, Windows Interfaces is easy to use, nice pop up UI, nice screens, nice Windows interfaces. But it doesn't have a lot of power like programming code. You can only do simple or average database tasks. But you can not do the complex database tasks that required a lot of database programming.


Only SQL database programming can do from simple database tasks to extreme complex database tasks that no step-by-step UI, Windows interfaces can do.

Think clean and short code SQL is like database programs that can do very complex database task. It is true that 1 SQL Programs equals to 10 UI interfaces in order to accomplish the same tasks. To write 10 short SQL Programs is easier than to design 100 GUIs  Windows Interfaces to do the same tasks. If using UI, Windows interfaces users will require so many steps, many UI, took long time in order to do complex database tasks.
Using SQL, after you get the short SQL program running OK, you saved the code. Next time, when you need to run again these database tasks, you re-use the short SQL programs, run over and over again. This is so much faster than repeat many UIs steps that will take long time.
- Net.Office Database 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

Net.Office Database and MS SQL Server both used and relied on SQL to communicate with database. No UI, Windows, interfaces only a big SQL Code Area box.

Why we need database? Business without data and database is blind business. Database is huge demand market, hundreds of billions. Businesses big, small already used database. Ask why only my business had no database.

We are living in the new economy, in the new world, that all connected and operated by data and information.

Can't imagine any businesses in this modern age, in the new economy, in the digital information age, that can run and operate business efficiency without database.
 

- Can't see far ahead. Can't see bigger picture.
- Back and forth every day.
Think database like warehouse. Imagine your company has a disorganized warehouse. Thousands of items, parts... stored every where.
Every time staff need something, they spent hours and hours in warehouse, back and forth to look, to search for parts, for things. Then the company organized warehouse in order, named, labelled stuffs, categorized parts, arranged parts in different folders, containers. When staff need parts, need some thing, they know exactly where to go and get stuff in second.

The same analogy,
data and information are like warehouse's parts, stuffs. Organizations, Businesses overloaded with data and information of customers, products, suppliers, employees, invoices, orders...Year by year, the data and information keep bigger and bigger. As a result, business was waste a lot of time to search for data, lost data. Sometimes, took business many hours, back and forth, just to find phone number, address of customers, suppliers, invoices... even lost data. Sometimes, because overloaded with data and information, staff ignored, didn't care, didn't collect, didn't analyze data and information. For example, not many businesses collect data, analyze data of their invoices.
That's why business needs database in order to organize and process data and information fast in second.


We know that you are going to say, who is going to need database? We don't need it. We are OK the way it is. Yes, we don't need technology and still run efficient.
This is business backward talking. Wrong. Look at this sales number of MS SQL Server.

MS SQL Server Database and Server Tools generated 27.10 billions of dollars, up 11%, in sales / year in 2011 for Microsoft. This tells you that businesses every where are using database. Only your business has no database. Small businesses few customers may not need database.

Organizations, Businesses spent a lot of time to process data and information. The chaos and the insanity, the inefficiency and the unproductivity. The quest for automation begins..

- Warehouse disorganized, chaos insanity. But not too late to organize.

- Take hours to find stuff. Data is like warehouse.

- Organize soon or too late to change the insanity: Do the same thing over and over again.

- No time for business. Too much time ask for data back and forth.

- Take hours to answer simple data, simple info questions. Look around. Files and Data stored in many places.

- Not online file sharing. Not sharing data centric. This could be done easily with Net.Office Database.


- Can't share files, data & information. Email files back and forth many times.

- Paper is not database. Can't Search, Analyze, Process data buried on static paper.

-  Business used paper a lot in order to store data & info. As a result, take long time or can't process data on paper. Spent hours to search for data on paper.

- Don't have database of Contact List, of Customers. Can't CRM (Customer Relationship Management).

- Can't targeted e-marketing. Can't send email to customers to inform new products and services.

- Can't compile or analyze data on paper.
Ask this simple question: - Can you find from thousands of paper, who is your top 10 VIP customers that spent or bought the most? OR, What are the hot products and services that generated the most revenue? OR, How many customers that we should remind them the services for this month?
- CAN'T or TAKE A LOT OF TIME TO ANSWER.

- Business grows. Data grow as well. Can't keep track all data and info of business. 

- Can't remember. Can't provide information solutions. Can't find data. Data disconnected, un-related. Lost data and information.

- Very busy, spent hours to search data on papers, file folders.

- Very busy with data consuming. On phone hours for data.

- Wait hours for round trips emails back and forth to answer simple data question. Overloaded with data and information.

- Can't send email to customers to submit form CTA (Call To Action) for : Register, Coupon Promotion, Feedback, Donation, Pay online...

- Lost invoices, lost products, lost parts, lost money...

As a result, organizations, businesses invested tens of thousands of dollars for Information System Database.

Spread sheet is better than paper but not Database.

A lot of businesses, specially Manufactures, used a lot of spread sheets because have no database, so they use Excel spread sheet as database. You can't create Relationship between spreadsheets like EDBMS. They dump all data and information in so many separated, stand alone spreadsheets. Data disintegrated, disconnected, unrelated, duplicated. As a result, they even spend more time, more hours to connect data, and process data, to search and look for data, information on so many disintegrated spreadsheets.

Net.Office Database imports data from Excel into database tables in seconds. And it exports data from tables to Excel as well.

Net.Office Database [Save As Query] lets you Save SQL programs so that you don't have to type SQL code again next time. See Save Query


What Net.Office Database can help your business? In 30 seconds

Make it simple to understand. In business is all about data and information. Business without data and information, without database is blind business. Business spent a lot of time and money for getting customers, hundreds of leads before getting few customers. When they had customer, they don't know how to nurture them, stay in touch, Customer Relationship Management. Your customers are the one who will refer, bring their friends and family to your business, words of mouth... Here is what Net.Office Database can do for your business, and we also tell you what Net.Office Database can do but other database software CAN'T DO.

1) Use Net.Office Database to build Database Information Management System for your business, simple database or complex enterprise database EDBMS. Most important. See:
EDBMS Case Study Examples. Like MS SQL Server, Net.Office Database is built in SQL and EDBMS. Now, the question is about your SQL Database Programming.

-> All database software built-in SQL, EDBMS like MS SQL Server, Oracle, Net.Office Database, can do this.

2) Use Net.Office Database to Store, Analyze, and Process data and information.
Data and information of Customers, Contact Lists, Leads Management, Products, Suppliers...

-> All database software built-in SQL, EDBMS like MS SQL Server, Oracle, Net.Office Database, can do this.

3) Use Net.Office Database to Instantly Update data. Work, Collaborate, Share database of Customers, Invoices, Contact List, Leads centric Management and Intelligence in one place... with employees, with staff, with customers any locations, in Net.Office, in warehouse, in hotel, in any country.
For example, Create a database Contact List and Leads Management and Intelligence tracking how often your sales team gets in contact with those leads and customers, and what those conversations were about. Every staff, the Managers, the Boss any where can access to this database. How to design this Customer Leads Management Database System? You can design one stand alone table, then expand more tables later. Read this:
EDBMS Case Study Examples.

-> Net.Office Database can do this because it is Cloud Web Database, not stored in PC. Staff from any where, thought the Internet, can access, work, and collaborate on database. PC Software can't do this because PC is not a file server. PC do not allow people from outside access to its database. Thus PC software can't do online stuff.


4) Use Net.Office Database to Collaborate data with Customers for better services, automation using myNet.Office Collaboration Tool.
For example, collaboration of  Invoice Order List.

-> Not all database software can do this unless businesses hire web developers to program. Net.Office Database can do this because it is integrated with myNet.Office Member Collaboration Tool. People with no web skill can create even a complex Member Collaboration like Order Status (or Invoice History Order List)

5) Use Net.Office Database for CRM, Email Marketing eCampaigner.
Send email promotion, coupon, update products and services, PR.. to all people, customers in database Contact List, Customer, Leads... People can update their phone, address, info on your Contact List database. People can opt-in / out. PC Database Software, PC Software CRM can't let people from outside to update data opt in / opt out, change their email, address,  in database Customer, Contact List. Therefore, people can't opt in or opt out.

-> Can't do this if using PC database because PC software can't do online stuff. Can't let people from outside update, register inside database. PC is not a file server. Net.Office Database can do this because it is integrated with myNet.Office eCampaigner.

6
) Use Net.Office Database for Marketing, Submit form online. Process Payment online.
For example, Send email to all people in Contact List, Member, Customer database to Register online, or to fill Feedback form, or fill Donation form, or to Fill Payment Form, Make Appointment, Seat Reservation, Seminar Reservation, Polling..

-> Can't do this if using PC database because PC software can't do online stuff. Can't let people from outside update, register inside database. Net.Office Database can do this because it is integrated with myNet.Office Smart form Builder.

7) Use Net.Office Database for Sales and Marketing.
Leverage your customer's words of mouth. Customer's referrals. Cross/Up Selling Products and Services
. Sell, register, reserve seats, products and services priority in advance for your existing Customers in database.
-
For example, Send Credit card Payment Form to sell Tickets. Sell new Products and Services to all Customers in Customer, Contact List table. They open email. Click on the form link. Fill form and Pay online.
- For example, business wanted to up selling, cross selling IPhone Accessories to all customers in Customer table, who already bought iPhone. Or, targeted customers in customer database who already traveled Europe last year for Asia travel this year...The customers in database if not interested may refer this to their friends, family...

-> Can't do this if using PC database because PC software can't do online stuff. Can't let people from outside update, register inside database. Can't process payment online. Net.Office Database can do this because it is integrated with myNet.Office Smart form Builder, myNet.Office Cloud Commerce.

Customer 's word of mouth, referrals is good marketing. But because no database, business can't leverage this power of Customer 's word of mouth, referrals. As a result, kept looking for new customers.

- WHAT IS CRM in short ? Is Customer Relationship Management. In business is all about Relationship. CRM is a marketing method of attracting and retaining customers. Can you give a very simple example of CRM ?  This is example of simple CRM that every one, every business, small or big, does every day. Say Thank You. You don't need to see every customers and said thank you. Just send email to all customers in database a thank you note, or give them a small gifts, a coupon, a promotion. This is how Net.Office Database helps you do a simple CRM, and connect to your customers.

NOTE: 
The probability of selling to an existing customer is 60 – 70%. The probability of selling to a new prospect is 5-20% – Marketing Metrics.
 

- Targeted true customers, who are already customers. Because true customers already used your products and services.
- NOTE: The probability of selling to an existing customer is 60 – 70%. The probability of selling to a new prospect is 5 -20% – Marketing Metrics.

- Net.Office Database is not just for storing and processing data and information, but also for nurturing, marketing and selling.
- NOTE: eCommerce spending for new customers is on average $24.50, compared to $52.50 for repeat customers
– McKinsey.

- Net.Office Database helped business target truly customers in database for word of mouth, for nurture relationship, CRM, for up selling, cross selling, eCampaigner, for submit form, register, reservation, feedback, appointment, fast order, pay online...
- NOTE:  It costs 6–7 times more to acquire a new customer than retain an existing one
– Bain & Company
 

8) Use Net.Office Database to Expand E-Commerce website. Add on more tables in e-Commerce Database EDBMS.
For example, you create more tables, such as: Suppliers table, Coupon Promotion, RMA table, Contact List table.. then add these tables in your E-Commerce website.

-> Can't do this if using PC database software because PC software can't do online stuff. Net.Office Database can do this because it is integrated with myNet.Office Cloud Commerce.

9) Use Net.Office Database for Business Intelligence. Data Analyst. Data Warehouse. Targeted Marketing, CRM
For example, run simple and complex SQL programs on table Customer, table Invoice in order to know more about customers, their profiles, their buy habits. Analyse data of products and services so that business can make good decision. Keep track total sales, products inventory. Who are customers? Big businesses even know the color of underwear of customers. What products and Services were bought the most? And target customers by promoting, up/ cross selling fit with their profile. In business is all about data and information.

-> All database software built-in SQL, EDBMS like MS SQL Server, Oracle, Net.Office Database, can do this.

10) THE COST. All came down to this number 10.

-> Database software built-in SQL, EDBMS cost too much. Need pro DBA. Cost a lot to pay for DBA (Database Administrator) to maintain 60K/year. Small businesses can't afford it. This is why so many small businesses still can't have database.

NOTE: MS ACCESS is Database Software NOT a Database Server. It is database for end users. Can't do online stuff. Can't do eCampaign. It is not powerful. That's why it runs on Common User PC Computer. While MS SQL Server required heavy duty PC File Server. Or Net.Office Database runs on big Cloud File Server. A BIG difference between a Database Software, like ACT, MS ACCESS.. and a Database Server like MS SQL Server, Oracle, Net.Office Database. MS ACCESS, UI Database Software, is used for end users database application, for simple database application, for less serious database development. Net.Office Database is in the middle of MS ACCESS and MS SQL Server because it is user friendly like MS ACCESS, and has all the server power like MS SQL Server.

- Database is huge huge market. Any database software just needs 1% share market of MS ACCESS and MS SQL Server. This translates hundreds of millions of dollars in revenue. Businesses, organization are shifting to Cloud for cloud database, and backup their data in Cloud.

- Click here to learn what you can do with myNet.Net.Office in 30s
 


- What can I do with Net.Office Database in 30s




- Net.Office Database is part of myNet.Office. Unlimited users and licences. Simple to use.

- Enterprise customers have been locked into overpriced, underperforming software and equipment for a decade or more, and they've been loath to spend money to change things. But now it seems a huge transformation is about to occur, driven by mobile devices, cloud platforms and the software-as-a-service business model.


- Net.Office Database is SQL and EDBMS database. All depends on how good is your SQL programming and understand EDBMS?

-
Net.Office Database and MS SQL Server, although big differences in infrastructure, each served different benefits for consumers. It is like driving your car and Ferrari car go to work. Each although has huge difference in price, but each for sure will drive you to work at 100 KM/h and you are still productive, not late at work. Still better than no database, no car go to work. Right?

If you want more then prepare for more money, more cost, more resources but also prepare for more headache. Don't go for simple UI Database like MS ACCESS. We recommend MS SQL Server. Good luck.

-
Net.Office Database helped business target customers in database for word of mouth, for up selling, cross selling, CRM, eCampaigner, for submit form, register, reservation, feedback, appointment, fast order, pay online, e-Commerce, Collaboration... It is hard to do this with other databases because Net.Office Database, not stand alone, has advantages of built in Smart Form, e-Collaboration, e-Campaigner, e-Commerce Tools. And you can do all of this without hard coding or without developers.




 

Why Web Database Cloud Net.Office Database?


Cloud Net.Office Database is a good database solution for organizations, manufactures, schools, small and mid-sized businesses that can not afford a big budget, IT complexity, and IT people for its databases.  But not last, it does not stand alone.

Net.Office Database, not standing alone, but together with myNet.Office Smart Form, myNet.Office Cloud Commerce, myNet.Page Webpage Builder, myNet.Office Email Marketing eCampaigner, myNet.Office Web Collaboration, myNet.Word, all integrated in one, will give you a complete Net Net.Office solutions of your website for your business.

Since Net.Office Database is built in myNet.Office. Unlimited users, unlimited licenses. 

The cost of using Net.Office Database is only the small cost included in fee for hosting your website.

NOTE: Click & see Cloud Hosting Data Center Servers VS PCs View Video of a Cloud Data Network Center.

Cloud Computing has reduced the cost. "- The economics of cloud computing are driving down the cost structure of business so far and so fast that it’s scary.."  Google CIO Ben Fried says.
Read:  Google CIO Ben Fried Says Cloud Tipping Point Is At Hand.


** What a huge lost if businesses don't take advantage of Cloud Web Database **


- Net.Office Database, new generation of web database for all sizes of businesses and organizations, is easy to learn compared to other databases, like ORACLE, Ms SQL Server.. These big databases required DBA (Database Administrator) that could cost 60K / year to take care and maintain. This cost is not including the cost of software, licences, hardware, servers, network.

- In a recent study, the Y Generation, in 25-35 years old, that grew up with Social Media, live online, will run their business more digital, more online business, more online presence. Which is different business philosophy and mind-set with their parent who are the X Generation ran and believed in traditional business.

Like MS SQL Server, Net.Office Database is built in SQL and EDBMS. Now, the question is how good is your SQL Database Programming?

- Web databases built on the new young infrastructure of Cloud Computing while the PC databases built on decades old infrastructure of PC Computing before Cloud Computing. Businesses begin shift to cloud. Reduce cost. Take time.

- MS SQL Server Database and Server Tools, 20 years in the making, generated annually 27.10  billions of dollars, up 11% in sales in just 2011.
We like Microsoft. Microsoft's direct database competitors are Oracle, SAP, IBM. Huge huge demand of businesses for SQL and EDBMS database software. To generate such a huge revenue, Microsoft must have invested millions and millions in MS SQL Server 's R&D. 

- Unlike Ms ACCESS, other GUIs Databases, Ms SQL Server, more advanced, used completely SQL Database Languages, and EDBMS.


To create a web database, you need to understand important web database Data Types

In order to design new table, you need to collect data. In order to collect data properly, you need to understand web database Data Type. This process called DATA COLLECTION.
In order to store data, the table needs to know what kind of data it stores for example, NAME, ADDRESS. Is it a Number, or a Date, or  Words, Characters, Text? This is called Data Type.
Here are most commonly used Data Type of Web Database that you need to understand.

CREATE TABLE my_support_center
(
ID
int not null auto_increment primary key,
NAME
varchar (50),
Email varchar (50) not null,
Phone varchar (50) ,
Company varchar (50),
Submit_Date
Date ,
SUBJECT
Enum ( 'Question', 'Feedback/Ask', 'Help', 'Others Interest' ) default 'Help',
LIST_PRODUCTS_SERVICES
Set ( 'Hosting Server', 'Note Book', 'Hardware Product', 'Software Product', 'E-Development Services', 'Consulting Services', '
Training Services', 'Sales Inquiries'),
Description
Text,
Staff_name varchar(50),
Photo varchar(30),
Staff_Email varchar(50),
Staff_Phone varchar(50),
Support_Time
Datetime,
Office_Notes Text

DATA TYPE EXAMPLE DESCRIPTION
Varchar
(Words, String, characters up to maximum 250 characters)
NAME, EMAIL, ADDRESS, PHONE ..
Syntax = NAME varchar (50)
Used for people NAME, ADDRESS, EMAIL.. It represents for the data of text, words, characters.. that is not Number, nor Date...For example, EMAIL = jsmith@ibm.com = 14 characters.
Int
(INTEGER number)
Age, Number of Employees, Quantity...
Syntax =  age int
Used for even Number that can't be divided into decimal.
For example, to collect data of how many employees of a company, you name COMPANY_SIZE is a Integer = 50. Not 50.5 employees. 
Float, Double
( Number of decimal)
Salary, Revenues, Sub_Total, Price Used for Decimal Number. Float or Double is the same but Double can hold bigger values.
Date
(yyyy-mm-dd)
Meeting_Date, Start_Date ...
Syntax = Start_Date date
Used for Date. For example, Meeting_Date = 2009-12-25
Datetime
(yyyy-mm-dd hh:mm)
 
Appoitment_Date, Meeting_Date, Support_Time...
Syntax =  Support_Time  Datetime
Used for Datetime. For example, Meeting_Date = 2009-12-25 16:30
ENUM
(Select 1 choice in many choices selection)
SUBJECT Enum ( 'Question', 'Feedback/Ask', 'Help', 'Others Interest' )
Syntax =  SUBJECT Enum ( 'Question', 'Feedback/Ask', 'Help', 'Others Interest' ),
When there are many options, but choose only one. myNet.Office Form Builder will create an option list interface for user to pickup one choice.
Example, Let users to select only one the SUBJECT_INTEREST from the pull down option list.
SET
(Select many choices in many options selection)
LIST_PRODUCTS_SERVICES Set ( 'Cryptopology', 'Compaq Server XP 35', 'Perfect Mail', 'Cryptocard', 'Ebusiness Development Services',
'Online Consulting Services')
Syntax =
LIST_PRODUCTS_SERVICES Set ( 'Hosting Server', 'Note Book', 'Hardware Product', 'Software Product', 'E-Development Services',
'Consulting Services', 'Training Services', 'Sales Inquiries'),

 
This is data type used for when users can select many choices in a set of many options.  myNet.Office Form Builder will create many check boxes interface for user to check many choices.

Example, you have a LIST_PRODUCTS_SERVICES of many products and services you want users to select as many as they wanted by click on the check boxes [v]
TEXT, BLOB
(A text container up to 65K of characters )
Office_notes, DESCRIPTION, COMMENTS, RESUME...

Syntax = Office_Notes Text
Used for when you want to hold up to 65 thousands characters. A lot of words.

Example, you have a field RESUME for users to paste and submit their resumes.
BLOB is similar to TEXT but case sensitive when searching.

For example, use BLOB when you want to hold text that can see and search the different between John Smith and john smith. In TEXT John Smith and john smith is the same, no case sensitive.
Net.Office Database and Ms SQL Server both used EDBMS, and SQL as their database programming language.

Unlike MS ACCESS, to use MS SQL, you must lean SQL. It is for serious and complex database development.

Net.Office Database and MS SQL Server, although big differences in infrastructure, each served different benefits for consumers. It is like driving your car and Ferrari car go to work. Each although has huge difference in price, but each for sure will drive you to work at 100 KM/h and you are still productive, not late at work. Still much much better than no car go to work. Right?

Like MS SQL Server, Net.Office Database is built in SQL and EDBMS. What ever businesses and organizations can do with MS SQL Server can do with myNet.Office Database. The only big difference is one on PC, and the other one on Cloud. Now, the question is how good is your SQL Database Programming?

- Learn SQL. What is SQL? is Structured Query Language, Database Programming. It is used to communicate with database. It is a database language for Enterprise Database Managements (EDBMS). 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, Windows interface can do.
Databases like ORACLE, Ms SQL Server built in SQL.
- Learn SQL. Become Net.Office Database 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
- Net.Office Database 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. Click see
Save Query (Click picture enlarge).



MS SQL Server Create Table - Oracle and Net.Office Database Create Table - All the same.


Picture: MS SQL Server CREATE TABLE.

ORACLE Create Table


Picture: Oracle Create Table cars

Picture: MS SQL Server: CREATE TABLE Customer -> INSERT DATA -> LIST TABLE
NOTE: It is not easy to put photos, videos, files in database tables in Ms SQL because of its PC Computing Infrastructure. Can't send email to all customer database

Picture: Database Oracle list employees

Net.Office Database Create Table. Upload Files, Videos, Photos into tables. And Send Email.

Building database begins with table. Let's get started to create a simple table called Customer.
- To Insert data into table, you can use SQL command INSERT INTO CUSTOMER =  INSERT IN CUSTOMER ('John Smith', '416-219-1900', 'john@yahoo.com','1235 Finch street, Toronto');
- Or use Net.Office Database Easy Data Entry Form.
Click see Net.Office Database Data Entry Form in table: Click here
- S
ee Data Type like Varchar, Double...Click here

Create Table customer
(
Customer_ID int Not Null,
Name varchar (30) not null,
Photo varchar (25),
EmployeeID int ,
Phone varchar (40),
Email varchar (40),
Address varchar (140),
primary key (Customer_ID)
)

- To create this table Customer, copy the blue code Create Table -> Paste into code area -> Click button [Submit SQL]
- You can also Create Table and Populate data from spreadsheet Excel to Database Tables without SQL code. Click here.


Picture: Create a table Customer. Then enter data in its table. This table has 7 rows or 7 records. Each contains data of table.

=> Net.Office Database is a first generation of
photo, social web database. A picture adds a thousand words.

=> Net.Office Database is constantly improving and evolving.

Like MS SQL Server, Oracle, Net.Office Database is built in SQL and EDBMS. Now, the question is about your SQL Database Programming?

- Use myNet.Office, Net.Office Database to build your company's EDBMS or too late to change.
 
Net.Office Database is constantly improving, and evolving its features and product

Net.Office Database is less than 2 years in the making. So It has a lot of rooms to grow. It is always improving, and evolving.

Net.Office Database Quick Description

- SQL Code Area boxes. Allows you to run, exe SQL Programs. After exec, you share SQL programs for later use.
- Data Entry. You can enter data in table in 3 different ways. See photo. Click to open Data Entry Form. Click see: Data Entry Form
- Save As Query. Share this SQL programs for later use.
- Sort column. Click on any column heading, such as: Email, Phone, Name.. to sort ASC (down) or DESC (up)
- Click on [X]
on the column heading not to display that column, such as column Address, because that column may not need to display. Click on [Browse Table] or [Reset] to re-display.
- Column Title:
Display field size. Let's you know the Data Type and Structure of a database field. For example, look at field = NAME (30), you know that it is VARCHAR type.
- Quick Search:
Quick search without SQL query. For example, to search all Phone number = 905. At Search By Category box, type: 905 -> At the pull down list Select A Category of all table fields of the opening table, select field = Phone. Then click [Submit] button. This will list all people with phone = 905.
- Go to record:
Type 45 with jump to the record ID = 45.
- Select a Table:
Click on a Table Listing at the left hand side.
- Resize the frame of 3 columns:
You can always resize the display screen. Thus give more space for the table display area.
- Resize the photo:
Hover the mouse over the photo will resize the photo to its original size.
- Mouse hover Foreign Key = EmployeeID of table relationship Employees will show relationship record: Table Customer has relationship 1-to-Many with table Employees. Use Net.Office Database Table Relationship Tool to setup which column of table Employees, such as: LastName, FirstName, Photo.., will show. Otherwise database users look at EmployeeID = 2 will not understand anything about this employee.
-
CLOSE/EXPANSE ADMIN AREA. : Click this icon to open / close the top section SQL Code Area. Thus give more space for the table display area.
- Action:
A database is made up by hundreds of tables, each table is made up by thousands of row or records. Record is where database stored data and information. So a record is a nuclear, a cell of database. Thus, what ever you want database do, you must go down to deep level of each single cell or record and act on it. It is what ACTION is doing.
For example, What ever you want John Smith do for you, you have to go to  down to John Smith row or record and setup what ever you want him to do.
What do you want him to do? Such as, Setup and Texting to Remind not only him but also you an appointment. Pay this invoice. Bring his car to dealer for services. Fill this Registration form. Make a donation. Send a Happy Birthday note. Inform him new Products and Services. Give him a coupon, a promotion. Invite him to a party. Remind him this Invoice, this Payment repeatedly as many times as you want.
-
Upload files, photos icon to upload your photos, files, documents, excel, Pdf files from your laptop, or PC, then insert into table.

Some features

-
Databases: Allows to create new database.
-
Data Entry  / Insert: Open a Data Entry to Insert data into the open table.  Click see Data Entry, Insert (Click picture enlarge). More Data Entry, click here.
- Browse or List or Display Table: List table. For example, you are open Data Entry to insert data. Click Browse will bring you back to table listing.
See picture above in Browse mode.
- Table Relationship: Open the Database Relationship Manager. Manage table relationship.
- Net.Office eCampaigner: Open myNet.Office eCampaigner, and lets you launch an Email Marketing or eCampaign on tables or based on simple or complex criteria of SQL query. Net.Office Database is BIG difference with simple manual building lists used in other electronic campaigners tools. For example, you use Net.Office Database to create complex campaign's segment lists. Such as use JOIN command to join all people, contacts, customers from different tables, then send them News Letter, Coupon, Promotion, or launch a Fundraising, Donation campaign.
- Net.Office Smart Form: Smart Form is used as Data Entry form for your EDBMS. Open myNet.Office Smart Form Builder to create smart form for database.
- For example, create a Fundraising, Donation form, Registration form, and Data Entry form for your EDBMS.
- Data Entry Smart form, another example, your Database Management Information System (EDBMS) needs some input from customers, members. So you use myNet.Office Smart Form Builder to create some forms like table data entry at website so that customers, members can input data.
- Security, another example, some times, you don't want some staff to login as Admin and access company EDBMS. So you use myNet.Office Smart Form Builder to create many forms as Data Entry for your EDBMS. Staff then login as members in Member Home area of your database system website, not as admin in admin area. Then do the data entry. This is hard to do with other databases.
NOTE: Security is implemented using myNet.Office Web Collaboration. Other databases didn't build in Member Collaboration tool in their databases.

Use myNet.Office Member Collaboration Tool, you can create as many as Data Entry Form as you want for staff to login as Member to input data.
- You also can create many collaborations, such as: See Listing Order Invoice, for your staff, your members, your customers to collaborate, to work on company's EDBMS without login as Admin

-  See How myNet.Office Member Collaboration to Create Member Collaboration Data Entry Form for your EDBMS.  You can create as many Data Entry Forms as you want for your staff login as Member in to enter data without login as Admin in Admin area.
- See How to Create Member Collaboration Login Update Account Info, such as: Name, Phone, Address, Password...
- See How to Create Member Collaboration Order Status History List.

- See
myNet.Net.Office Login Member Collaboration Home Account
myNet.Office Member Collaboration brings company's EDBMS to next level for sharing and collaborating data and information with people. From Database Management Information System that is used within company's collaboration only, to next level, that is used company's EDBMS in order to provide services, and collaboration with customers, members, staff. In Member Collaboration, the business, the red one, is the Master of Collaboration.

What is myNet.Office Member Collaboration? It lets business create collaboration tasks for Customers, Members, Staff to act or collaborate on data and information of tables in EDBMS.

- Social Collaboration Network is the solution for the huge gap in productivity and lack of web automation in Businesses, in Organizations.

While small businesses, moms and pops shops spend almost their time, very busy all day, on the phone hours for one-on-one services, and in person-to-person services,
big corporations, banks can't. They build web based collaboration, online banking to serve thousands of people anywhere. While your business is closed, web collaboration is still served 24/7, anywhere, faster, convenient, efficient.
People, customers, every one loved one-to-one service. If businesses, organizations continue providing these VIP services, then people, customers will continue asking for them. But when time and human resources are limited, business should pass some business tasks as online services.

- In Social Collaboration Network, people are collaborating on data. EDBMS is the main source of all collaborations.

- Is it possible to build a Social Collaboration Network in Social Media Network? The power of the Internet is Connect and Collaborate. Social Media Network is already leveraging the power of Connect. It would be so powerful if Social Media Network leverages another power of the Net, the Collaboration.

- What Social Collaboration Network is doing for collaborating Business Enterprises with people, is what Social Media Network is doing for connecting people with people.

For example, you build a EDBMS for a Company's Rental Video, for a Mechanic Body Shop Services Center, for a Business, School, Organization Information System, for a Mom and Pop's Store Customer Order Management System. This Database Management Information System so far has been used within the company in order to manage data and information. But then the company wanted to shared this EDBMS with customers for better customer service, and better operation, time efficient...The company then designed many Member Collaborations. As a result, the customers of that Video store now can login as Member to view their invoices, view their profile, the date to return the rent movies. Update their Account, phone, email.. What movies they had rented. How much they still owed. Remind members, customers an appointment, a payment. Get coupon or check promotion. Cross / Up selling. Introduce customers new Products and Services may interest them. Recommended them new Movies, Videos just released. Pay online...The Mechanic Auto Service Center can update their service with customers. Let them know when to bring car back for change oil filter, or do other services, or pick up car, service already done. Customers can view and list all services they have done - The History List of Services, like the History List of Invoices. Business engaged with people.. So on... ** The collaboration with customers for Services and Marketing is unlimited. The collaboration with people is powerful. The collaboration helps business automation and productivity**

The company's EDBMS now expanded more tables, more relationships...Love it.
-
How to? For example, the company wants to give their customers, their members promotion, coupon, and introduce customers new Products and Services may interest them. In order to do this 2 different collaborations: One is Give Coupon and Promotion. The other one is Introduce new Products and Services may interest customers. The company will do this:
1) The company creates a new table called: tb_CouponPromotion , and tb_NewProductsServices. Then add these new 2 tables in company EDBMS.
2) Then create 2 new relationship Many-to-Many Relationship with the existing table tb_Customers.
- tb_Customers: Many-to-Many <=> tb_CouponPromotion. Which means each customer can have many coupon or promotion. And coupon ( = 10$ OFF) or promotion ( = Free Shipping) can be shared by many customers or members.
- tb_Customers: Many-to-Many <=> tb_NewProductServices. Which means each customer can buy these new Products and Services if they interest. And each new Product and new Services, Movies, Videos just released may interest many customers.
3) Finally, create Member Collaboration so that members, customers login their Member Home Account will receive coupon or promotion. And see new Products and Services may interest them. Each customer has different Coupon or Promotion, and different Products and Services depending the company enter data in tables.
-
To get them login account more often: Send email let them know they have coupon, or promotion, or service is done, or update their service status, delivery, product return status... To learn creating Many-to-Many Relationship, click here.

It is up to the business wanted to provide Member Collaboration, sharing and collaborating company's EDBMS with members, customers, staff. 
myNet.Net.Office Member Collaboration is used and applied in any EDBMS Case Study Examples.
- Open SQL Query: Let you save the SQL Programs. Then re-open SQL Programs to run. For example, you have created SQL programs. You save this code. Next time you or staff can open and run this SQL program again, or modify the code. Click see Query Feature
-
Table Structure: Let you open the table' s structure. And change, alter its data type of column, change column name... For example, you re-name column NAME = CUSTOMER_NAME, resize varchar = 40. Then move this column after EMAIL column. And move EMAIL column after CUSTOMER_ID. Or drop the column.
NOTE: You can do all of this tasks using SQL code.
- Import / Export: Import data from an Excel spread sheet into table. And Export data from table to an Excel spread sheet.
 

Security -> Use myNet.Office Member Collaboration with Net.Office Database

- The Security concerned. There are staff, members that your company didn't want to access and login company's EDBMS as Admin in admin area. But staff are part of the company, they must use company EDBMS. They must enter data every day. So what can you do if they can't login as Admin working on company's EDBMS?

- The solution is myNet.Net.Office Member Collaboration Tool built in.

- How to provide security for company's EDBMS?
Use myNet.Office Member Collaboration Tool, you can create as many as Data Entry Form as you want. You also can create many collaborations, such as: See Listing Order Invoice, for your staff, your members to collaborate, to work on company's EDBMS login as member in Member Account or Member Home, without login as Admin.

- See example, How to use myNet.Office Member Collaboration to Create Member Collaboration Data Entry Form for your EDBMS. 



Email Marketing built in Net.Office Database - Launch eCampaign using Net.Office Database

Do Online Marketing, Email Marketing, eCampaigner. The main App is: myNet.Email Marketing eCampaigner.

When you launch a campaign, it is not the Email, or the News Letters, but the Email List is the most time consuming and challenging because you want to target the right group of customers.
To launch an Email Marketing campaign, eCampaign using myNet.Office, you will do 3 steps:
1)
Use Net.Office Database to create an email Contact List, email segment List for Email Marketing. Big difference between Net.Office Database and the simple Email List Builder used in other Email Marketing tools.

Because the simple Email List Builder of other eCampaign software is not Database.
- Therefore, using Email List Builder of other eCampaign Software Tool, you can't do complex SQL, can't complex query, can't complex segment your list. The Email List Builder can't complex search into multi tables, can't joint multi tables. Can't complex filter your database to target people, criteria email conditions you want.

- For example, simple Email List Builder CAN NOT DO THIS CAMPAIGN. Only Database like Net.Office Database can query this campaign condition.
"- Launch A Bringing Customer Back Store Campaign to send coupon, or gift, or promotion, to update new Products and Services for all customers who have not come to our store, not contacted us for over 6 months already. To calculate how long, in Invoice database, minus the Current Date with the Last Date Ordered Field, will tell you how long the customers had not ordered since the last order. Let them fill a Feedback / Wish List form. The form ask: Why not ordering from us because of Price, or Customer Service, or Product Quality? Fill in comment box. What can we do for you? Customer wish list? "

- Let's do another very much simpler campaign that Email List Builder can't do:
"- Search or query 2 tables, the Invoice database, Customer database. Select all customers who bought more than 500$ and give them a 5$ coupon. And bring coupon to store. Or launch a promotion. Or send a notes. Or update new Products and Services."
-
Using Net.Office Database, all you need to do is run the query -> Got the list of all customers who satisfied the condition -> Use myNet.Office eCampaigner to launch email campaign.
This is the query:
SELECT invoice.invoice_id, invoice.invoice_date, sum(invoice.sub_total) as Total, customer.customer_id, customer.name, customer.photo, customer.phone, customer.email, customer.address
FROM customer
INNER JOIN invoice
ON customer.customer_id = invoice.customer_id
GROUP BY customer_id 
// -> GROUP BY: Prevents duplication of a customer who may appear many times on list. Thus receive multi emails. And also sum total all invoices bought by a customer.
HAVING SUM(invoice.sub_total) >= 500

NOTE: Net.Office Database is also let you
save the Email List of customers got from this Query in a new Table for future eCampaign target repeatedly many times on this customer's group.


Picture: A typical Manual Email List Builder used by other Email Marketing eCampaigner Tools to email to people in Email List. Very simple List -> Take long time to build Email List.

NOTE:
Because the eCampaign launched from database like Net.Office Database, not from Email List, you can do data analytic, such as:
- Who contributed the most? Who click the most? Who opt out? - Who didn't click yet so that we target again? - What demographic, such as: City, Population, Gender, Group, Community, Ethnicity... contributed the most? -  Calculate Total amount of donation? ...Then export database to Excel for Email, Print, Graph...

In general, YOU CAN’T DO DATA ANALYSIS OF CAMPAIGN RESULT FROM SIMPLE EMAIL LIST BUILDER.
- EMAIL LIST BUILDER CAN'T LET PEOPLE INSERT CREDIT CARD NUMBER, UPDATE THEIR INFO LIKE ADDRESS, EMAIL BECAUSE EMAIL LIST BUILDER IS NOT A DATABASE SERVER.

- EMAIL LIST BUILDER HOSTED BY ANOTHER COMPANY. DON'T PUT YOUR CUSTOMER CREDIT CARD INFO IN THEIR EMAIL LIST BUILDER.


See photo of the Email Contact List created by Net.Office Database for Email Marketing using by myNet.Office eCampaign



Photo: Launch eCampaign using myNet.Office eCampaign + myNet.Office Smart Form + Net.Office Database. Net.Office Database is a powerful tool to search, segment data, and do Campaign Data Analytics.

-
myNet.Net.Office eCampaigner new Features tracks Email when people opened their emails sent from myNet.Office eCampaign...
- When
people open their email will automatically update Net.Office Database always available on the Cloud. And how many times, and the time people opened email.
- Track How Many Times Customers have opened your Email, or not open email. And when the Last Time they opened.
- Track How Many Times customers click on email the URL Link, such as: Click here to register for this event, or, Click here to pay for this invoice, embedded in email. And when the Last Time they clicked. See picture of database.
- For example, in this Donation Contribution database, member David Smith did open the eCampaign 's email 2 times ( IS_EMAIL_OPEN = 2), and last time he opened is: 2012-05-10 at 2:45 PM (LAST_DATE_EMAIL_OPENED). There is an email embedded the URL link = Click here to open the Donation Form, and make a donation, David click opened this link Donation Form 2 times (EMAIL CLICK VIEW COUNTER =2). Last time he clicked on this link is 2012-05-10 at 2:45 PM (=LAST DATE CLICK). Then he did make a donation = 850$ on that date.
- Member Peter H didn't open email (IS EMAIL OPEN = 0). Made no donation. Brian W is donated but then opt out don't want to receive email.
- Member Tester did open email 1 time (IS_EMAIL_OPEN = 1) at 2012-05-16, 6:29 PM, but didn't click on the Url Link Donation Form (EMAIL CLICK VIEW COUNTER = 0). Thus didn't make any donation.

- myNet.Office lets you launch eCampaign from Sql, query search. And do all kinds of Campaign Data Analytics.
- For example, to re-launch Donation Campaign for people in database that had not yet open email. You run this query:
- Select * from donation_contribution_db where IS_EMAIL_OPEN = 0  => This query will give the list of donors not yet open email. Now launch campaign on this group.
=> To send all emails beginning with 500 people used primary key ID from 1 to 500:
- Select * from donation_contribution_db where ID >= 1 AND ID <= 500
=> To send thank you notes to donors already made donation more than 100$. You run this query search to get the list of donors:
- Select * from donation_contribution_db where  AMOUNT >= 100
=> To know who did open emails but no click on the Url link Donation Form. You run this query search to get the list of donors:
- Select * from donation_contribution_db where  IS_EMAIL_OPEN > 0  AND EMAIL_CLICK_VIEW_COUNTER = 0
=> To get the list of top 10 donors, just click on column heading AMOUNT to sort in UP or DOWN in order.
=> If your database had data of Gender, Geographic, Ethnicity, City, Company... you can do all kinds of Campaign Data Analytics. Such as: Gender, Ethnicity, who contributed the most, the least...
=> Do Campaign Data Analytics so that you re-target, nurture relationship with people, CRM later...

2) Use
myNet.Word to create Email Marketing file = My Africa Vacation: myNet.Word to create Email Marketing My Africa Vacation file . 

3) Finally, launch
myNet.Net.Office Email Marketing eCampaigner.
- See result of email received by customer the My Africa Vacation marketing =
Email My Africa Vacation - The result email customer received of an eCampaigner Flower Promotion .

IMPORTANT NOTE: As required by Law, Electronic Email Campaign must have option to allow people opt in / opt out of receiving email, just like you made Cold Calls to your customers. Launch eCampaign from a database in PC, people can't opt in / out. Can't update their info like Address, Credit card...Because PC can't let people from outside to do this.
Can't do eCampaign with software, database running on PC, Laptop
.

IN CONCLUSION: To launch an eCampaign using myNet.Office, you do these steps:
1) Use myNet.Word to create an Email or News Letters. Make nice simple letter, simple email like email you send to your customers, your friends.
2) Use myNet.Office Smart Form Builder to create Forms like:
Register Form, Donation Form, Sell Ticket Form, Sell Product Form, Pay Invoice Form.
Then embed the Url link form in email. Or you can also embed URL link to Product Catalog Sale Item of website. Such as: Click here to order this Product Catalog Chicken Soup Item.
3) Use Net.Office Database to create Contact List, Customer database. Do search, query to segment list, get list of targeted customers you want to receive emails, and not target every one. Then save the query result as a new table used for this email campaign so that you don't mess up with the original Customer, Contact List table. You can named new table as: August Campaign, or September Campaign, or Donation Campaign...You can always delete the table after campaign is done.
4) myNet.Office eCampaign will automatically add all fields used by eCampaign like: OPTIN (= Continue to receive email or not), IS_EMAIL_OPEN, LAST_DATE_EMAIL_OPENED, LAST_DATE_CLICK, EMAIL_CLICK_VIEW_COUNTER (= Times of click on URL form) to the eCampaign table. These fields are used to help you track the result of your campaign. You can always delete the table or delete these fields after this Email Campaign no longer needed.
5) Finally launch your eCampaign. This eCampaign is saved so that you can re-query and re-launch many times.
- For example, the above table: Donation_Contribution_Db contained the list of Donors who were collected from many tables: Customers, Contact Lists... You then use this table to launch Donation and Contribution Campaign. Using the same table Donation_Contribution_Db repeatedly many time, you do different search, query in order to segment for targeted groups, different criteria, such as: query for: Who didn't open email or Opened email but not make donation. Or send thank you notes to Donors donated > 100$.. and re-send emails to people selected by criteria in table Donation_Contribution_Db.
 
- First, create empty table donation_contribution_db
- Enter data into this table. You can add more fields like: Address, Company...We just try to make a simple table.

CREATE TABLE donation_contribution_db
(
ID int not null auto_increment primary key,
Name varchar(20) ,
Amount double,
Email varchar(30) ,
Title varchar(30),
Phone varchar(30),
Staff_Followup_Note text
);
- Copy the list of donors data of Name, Email, Phone, Title  from other tables: Customers, Contact List, Leads, Website Submit Form table... in table Donation. Now you should have donation_contribution_db table with hundreds of donors data copy from other tables. This way, you don't mess up data the original tables: Customers, Contact List, Leads, Accounts, Opportunities table..

INSERT INTO donation_contribution_db (Name, Email, Title, Phone) SELECT Name, Email, Phone, Title
FROM Customers


INSERT INTO donation_contribution_db (Name, Email, Title, Phone) SELECT Name, Email, Phone, Title
FROM Contact_List
- Add extra field = Address after field = Phone into table donation_contribution_db, you run this SQL:

Alter table donation_contribution_db add address varchar (250) after Phone

To add extra field Option List (pull down list to choose) of Group or Ethnicity after field NAME, run this SQL scrip:

Alter table donation_contribution_db  add Groups
Enum ( 'White', 'Blacks', 'Asian', 'Latino', 'Others' ) default 'White' after Name

- Other fields used for tracking the eCampaign results like: OPTIN, IS_EMAIL_OPEN... are automatically added by myNet.Office eCampaign when you launch the campaign.

NOTE: As you see, there are hundreds of different needs that only SQL programs can quickly solve. We can't design hundreds of UIs (User Interfaces) that will satisfy all your needs, hep solve problems like this example. => SQL is short script. Syntax is like English, very easy to learn. You GOOGLE search for SQL script.
- For example, to find duplicate EMAIL, NAME or any duplicate value in table, you GOOGLE this: SQL find duplicate value in table. You get a lot of SQL code examples, like this:
SELECT email, COUNT(*) FROM
donation_contribution_db
GROUP BY email
HAVING COUNT(*) > 1  


=> This is hard for traditional eCampaign software to do all kinds of SQL tasks, move data, copy data from table to another table, because they launch eCampaign from Email List Builder. They don't build in database like Net.Office Database.

=> Do Email Marketing eCampaign to inform people first. Then make phone calls to people who didn't open email. A combination of eCampaign + Phone call will make effective marketing campaign, and help save a lot of time and money

.More campaigns? Click here  | Why Email Marketing, eCampaign is the king: affordable, easy steps, targeted, segment, tracking. More Click here
 


To join multi tables in Database Relationship, use JOIN command. It is very important command in EDBMS

What Join? Why Join?

In Enterprise Database Management (EDBMS)
with a lot of tables having the relationship, and you want to search, to know, to connect their data and information of these relative tables, we used JOIN command. The JOIN command is probably the most important command, and it is used a lot in EDBMS.


Join represented shapes in colours. Example, LEFT JOIN = blue shape (A - B) + brown shape (A Ω B).
A = table 1 or left table. B = table 2 or right table.
Example, Customers (table 1, or table A) and Orders table (table 2, or table B).
The relationship: Customers: 1-to-Many Orders
A customer ordered many orders. An order belongs to a customer.

LEFT JOIN: Returns all rows from the left table (table_name1), even if there are no matches in the right table (table_name2).
Example: SELECT Customers.LastName, Customers.FirstName, Orders.OrderNo
FROM Customers
LEFT JOIN Orders
ON Customers.P_Id=Orders.P_Id
ORDER BY Customers.LastName


RIGHT JOIN: Returns all the rows from the right table (table_name2), even if there are no matches in the left table (table_name1).
Example: SELECT Customers.LastName, Customers.FirstName, Orders.OrderNo
FROM Customers
RIGHT JOIN Orders
ON Customers.P_Id=Orders.P_Id
ORDER BY Customers.LastName

INNER JOIN: Return rows when there is at least one match in both tables.
Example: SELECT Customers.LastName, Customers.FirstName, Orders.OrderNo
FROM Customers
INNER JOIN Orders
ON Customers.P_Id=Orders.P_Id
ORDER BY Customers.LastNam
e

FULL JOIN: Returns all rows from both the tables, ignoring the row(s) of one table is matching with the row(s) of another table.
Example: SELECT Customers.LastName, Customers.FirstName, Orders.OrderNo
FROM Customers
FULL JOIN Orders
ON Customers.P_Id=Orders.P_Id
ORDER BY Customers.LastName

Net.Office Database Files, Photos in database. MS SQL Server and Net.Office Database use JOIN to join tables in EDBMS.

A picture is worth a thousand words, will help enhance database a lot.

Look at these pictures. Net.Office Database and MS SQL Server both did the same JOIN tasks but had different look and feel. With embedding photos, Net.Office Database look and feel is enhanced and more likeable. For example, the restaurant menu. One menu is all words, no photo. The other menu is words + photo. Which menu is more attractive to customers?


Picture
: MS SQL Server JOIN 3 tables of a school: table Grant, table Employee, table Location

---- MS SQL Server code ---
SELECT GrantName, Amount, FirstName, LastName, loc.LocationID, loc.city
FROM [Grant] as gr
INNER JOIN Employee as em
ON gr.EmpID = em.EmpID
INNER JOIN Location loc
ON em.LocationID = loc.LocationID

- Because MS SQL Server is PC based database, because of its PC infrastructure, it is very hard to insert files, images, photos in its database and display photos.
 

Picture: Net.Office Database JOIN 5 tables: Wives, Food_Hobbies, Wives_food_hobbies, Husbands, Contacts. A picture is worth a thousand words.

Only Net.Office Database can easily insert photos and display photos like this without any hard coding.

- It is very easy to put photos, pictures, files in database with no hard coding. For example, adding column Food_Photo in table Food_hobbies, you will do:
1) Add a new column called: Food_Photo in table Food_Hobbies using this SQL = Alter table Food_Hobbies add Food_Photo varchar (40)
2) Next, click this icon to upload photos, files from laptop, PC into the column Food_Hobbies.

---- SQL  code ---
SELECT contacts.email, husbands.husband_name, husbands.husband_photo, wives.wife_name , wives.wife_photo, food_hobbies.food_hobby_name as Food_Name, food_hobbies.food_hobby_photo as Food_Photo, contacts.address, contacts.house_photo
FROM wives_food_hobbies
INNER JOIN wives ON wives_food_hobbies.wive_id = wives.wive_id
RIGHT JOIN food_hobbies ON wives_food_hobbies.food_hobby_id = food_hobbies.food_hobby_id
LEFT JOIN husbands ON husbands.hb_id = wives.hb_id
LEFT JOIN contacts ON husbands.contact_id = contacts.contact_id
ORDER BY husband_name DESC 

Let's get started

Build Enterprise Enterprise Databases linking hundred of tables using Database Relationship

What is Database Relationship?

Database Relationship is the relation between tables in database that defines the way how we organize and process data and information. It is so important that a small error from bad design can lead to misinformation, data integrity. And thus your business who depends on that database. On the other hand, if designed properly, it will help your business a lot in term of processing, collecting and sharing data and information:
GARBAGE IN => GARBAGE OUT.
In
real business life, data, database table will not stand alone, not one table, but have the relationship with one or more tables, hundreds of tables. This database relationship helps database link a lot of tables, even hundred of tables together. And thus, Database Relationship helps make database enterprise, bigger, extended to many tables, hundred of tables.

Begin with Database
Is like a big warehouse. A Database can contain hundreds of tables. A database can also contain many different Database Applications built in the database. For example,
Database Application = Child Care / Day Care Management System contains 15 tables in
Database_ABC_Inc, having relationship each other.


What you can do with Big Enterprise Databases using Net.Office Database? The Architect and Design
 
Net.Office Database is architect, designed and built for Large Enterprise Databases that contain many Databases -> Each Database can contain hundreds of Tables -> Each Table contains millions rows of records.
 Each Database also can contain lot of EDBMIS (Enterprise Database Management Information System) + Share Data, Read Data,
Integrate Data (= Data Centric), Collaborate Data, Search Data, and JOIN Data across Databases in Enterprise Databases + Easy to use, UI / UX.
- Office Database, the first database can store, process, display Photos, as see.
- Net.Office Database is designed simple for grade 12. No need Developers, no DBAs
. No Programming but only SQL.

- Like Oracle, MS SQL Server, IBM DB2, Cloud Net.Office Database is architect, designed around Schema, Table, and SQL, three pillars of database.

=> You can create as many as 50 databases in Net.Office Database. Each database can contain hundreds of tables. Each database can also contains many DBMIS (Database Management Information System). In each DBMIS, has its own Schema + Tables.

-
See: EDBMIS Case Study (EDBMIS = Enterprise Database Management Information System)

- For example, you create main database named DB_ABC_INC. Then create another database for Sales Dep named: DB_SALES_DEP. Then create another database for Warehouse named: DB_WAREHOUSE. Keep creating... DB_SUPPORT_DEP, DB_MANUFACTURE, DB_ENGINEERING, DB_ECAMPAIGNS, DB_ECOMMERCE...
- In each database, you can build as many as Database Applications you want.  Each DB Applications is itself a RDBMS, and has its own schema.
- Each database has its own SQL APPLICATION MENU displaying on the left frame. Such as: DB_SALES_DEP has CUSTOMER MENU, REPORT MENU, MARKETING MENU, INVENTORY MENU. Database DB_ECOMMERCE has E-COMMERCE RDBMS MENU...  

- For example, use Net.Office Database,
company can create a database named DB_ABC_INC. In database DB_ABC_INC, you build many database applications DBMIS (Database Management Information Management). Such as: build An Invoice Database Management Information System has 10 tables + Schema. Then build a second database application, made up by 12 tables + schema for An Employees Tracking System Database Management Information System. And then build a third database application, made by 8 tables + schema design for database application: Time Sheet Table Database Management System...
-
In database DB_SUPPORT_DEP, build a database application DBMIS named: Parts Order, Items & Inventory Control System has 15 tables + relationship schema.
-
See: EDBMIS Case Study (EDBMIS = Enterprise Database Management Information System)
-
In database DB_ECAMPAIGNS, you store all tables that are used for email marketing, eCampaigner.
- For example, you have a Customer table in database
DB_SALES_DEP -> Then you Search a criteria for a list of customers who satisfy coupon, promotion for the August Campaign -> Net.Office Database lets you save this list of customers as a new table named August_Campaign table in database DB_ECAMPAIGNS -> Then launch email marketing eCAMPAIGN from this database. So that your original Customers table in DB_SALES_DEP will not mess up -> After campaign, you can delete this eCampaign August table.

- A Database MENU is a menu of many SQL Programs of that database. Each Management System, like INVOICE MANAGEMENT SYSTEM, has its own menu. Each SQL Program, like A Database Application (Database Apps), is used to run to do different database tasks. 
- For example,
database DB_ABC_INC has these database menus = INVENTORY AND PRODUCT MENU, INVOICE MENU, SALES AND MARKETING MENU...
- When clicking database name, like DB_MANUFACTURE, will list its own MENUS, and you will not see listing of Menus of DB_ABC_INC.
 


Picture: A Database Menu -
Each database, e.g., vndirect_Head_Office, has its own Database menu.

- Each Database has its own Database MENU, like INVOICE MENU for INVOICE MANAGEMENT SYSTEM, that is showing and listing only when you select that database.
Click on the Menu Bar to list all Database Apps or SQL Programs of that MENU
.
See INVOICE MENU.

- To open Database Menu INVOICE MENU of Database = vndirect_ticket, just click on the red bar INVOICE MENU. To close, just click on the red bar INVOICE MENU again. This INVOICE MENU is belong to database  = vndirect_ticket only. Other database like vndirect_Head_Office has its own INVOICE MENU, which is different with database vndirect_ticket 's INVOICE MENU.

- Each Menu, like INVOICE MENU, has a lot of SQL Programs (or: Database Apps) written to do specific database task. To run Database App, click on Menu Item like 2) List Total Sales, Tax of Invoices.

- You can change Menu Name, delete SQL Program Apps...


Picture: Net.Office Database to Create as many as 50 Databases.
For example: vndirect_ECommerce, vndirect_Europe_Office, vndirect_Head_Office..
are different databases in larger Enterprise of many Databases.
- Each Database contains its owns: Tables.  + Many its own Database Application Management Systems (DBMS) + Database Menu + Resources.

Since Cloud Net.Office Database is cloud database, anyone can work, access databases from home, in hotel, in warehouse, any locations, any offices around the world, anywhere that has access to the Internet. Cloud Net.Office Database is like a website, just login and use database system.
- Must have access User ID + Password login each database. Or else can't click open, can't access database, its tables, resources.


- In this picture, to Open a list of all Enterprise Databases

- Just click folder = All Enterprise Databases. See the list of all databases = vndirect_SALES, vidirect_helps, vndirect_hr, vndirect_mno, vndirect_support...

- To use, select a database = vndirect_ticket, just click on its name: vndirect_ticket. Must provide users ID + Password login database. Just click on the name of that database.
=> It will load all its Tables of this database + its own Database Menus, like: INVOICE MENU, CUSTOMER MENU, SALES AND MARKETING menu...+ All its own  database stuffs, resources ... The current database in use = vndirect_ticket.

- Net.Office Database allows to Write SQL query to Read data, Share data, Integrate Data, Centralize Data, Manipulate Data, Collaborate data, Search Data, JOIN Data across Enterprise, from different tables in different databases, in different EDBMS in large Enterprise. This is powerful.

=> For example, write a SQL program to JOIN and Read data of Customer table in database DB_SALES_DEP, and Employees table in database DB_HR_DEP, and Products table in database DB_WAREHOUSE to produce a result.


Picture: Cloud Net.Office Database allows to Create Table Relationship across Enterprise, and makes easy to Integrate Data, Share Data, Collaborate Data, Read data, and
JOIN Data of Tables in multi different databases, different EDBMS.

- For example, using Net.Office Database database, company can share table Employees of DB_HR_DEP, table Customers in database DB_SALES_DEP for other EDBMS, for other Databases => You can also
JOIN multi tables Orders, Customers in database DB_SALES_DEP with table Employees of different database DB_HR_DEP.

- Using software, each siloed Department, like HR DEP, has its own software system, its own data, like Employees data. Thus it is very hard to centralize Employees data, and to share and collaborate Employees Data, for all Departments. NO INTEGRATION OF DATA IF USING SOFTWARE.

- How to Create A Database Menu

- You write a SQL Program -> Click on icon SQL on Topmenu will popup a dialog = SAVE SQL PROGRAM. From this dialog, you can create the name of MENU like INVOICE MENU, the name of SQL Program Database Application like Get Listing Of New Invoices...So forth.. See picture.


Picture: How to create a Database Menu of SQL Programs. Click on picture to see larger. The first database can store, display, process photos.


- How to Create a new Database in Net.Office Database
-
To build EDBMS, you must first create a database. Table is stored in a database.
 
Database contains Table -> Table contains Records -> Records contains data and information. A record is a row in table.


Picture: So simple. From topmenu, click mouse on icon dbase to pull down menu -> Select Create New Database will popup dialog = Create New Database -> Enter: DB_ABC_INC, click Submit button. Now you had a new database name DB_ABC_INC. DONE!

From Database Menu, you can also do:
-
Drop Database = Delete a whole database including all tables in this database.
- Backup Database = Backup a whole database including all tables in this database.
- Restore Database = Restore a database including all tables in this database from a Backup.
- Import Database = Import all data and all Tables from a Database to another Database.

A Table
- Is a smaller database, a part of a big database. Table is made up by fields or also called columns. For example, column or field EMAIL, ADDRESS.. Table is also called as Database Object.
- You save data, like Address, Email ... in each column of table. This will create
a row or a record of table. A table in Office Database can contain millions of records (rows) of data.
- A table has a unique key =
Primary Key. It is used to make sure each record is unique, when do Update, Insert, Delete records
For example, you create table Customer. You use customer Customer_ID, Phone, Email, SIN, as Primary Key because there is no customer has the same Phone number, same Email, same Customer_ID = unique. If you use
First Name, as Primary Key, then possible there are 2 customers had same first name = John. Thus Fname is not unique key. Can't use as Primary Key.
- The best Primary Key is used
an Integer number, like Customer_ID, not a string like Email, Phone, for easy run SQL programming.
-
Customer_ID = unique generated Integer number increment when add a new customer. For example, Customer_ID = 1, 2, ... 10000..

=>
For example, your company database DB_ABC_INC has a Customer table, Invoice table. These tables are inside the big company database DB_ABC_INC. Sometime, we refer table as a small database for users easy to understand. In real life, your tables now are not stand alone, but they have the relationship with other tables. So that from one table you can relate data from other tables.

=> Table In Net.Office Database is called Big File Cabinet Table that can store unstructured big data like photo, video, map, music. Move, Carry them in Cloud. Play video, music in its database table. MS SQL Server, Oracle store raw data only. See explain in our Blog.

How to Create A Table using Net.Office Database - Use SQL code Create Table. This is quick, easy, one click to create a Table. No back and forth. No need developers. No programming.

1) Write SQL Create Table, like this Create Table customer in blue. If you don't understand Data Type like varchar (30)... See Understand Data Type from the left menu.
 
Create Table customer
(
Customer_ID int Not Null,

/* NULL is used to represent a missing value. So Customer_ID = Primary Key must have value.. like 100 */

Name varchar (30) not null,
EmployeeID int ,
Phone varchar (40),
Email varchar (40),
Address varchar (140),
primary key (Customer_ID)
)
- No case sensitive - field Name same as name
- /* comment not code */
- varchar, int .. called
Data Type - See how to below.
Create Table customer
(
Customer_ID int ,
Name varchar (30) ,
EmployeeID int ,
Phone varchar (40),
Email varchar (40),
Address varchar (140),
primary key (Customer_ID)
)
- same as left side


2) Paste this blue SQL code in Net.Office Database Code Area. Then click Submit SQL button. DONE. Next, enter data. That is it.


Picture: To Create a table named
customer using SQL code Create Table -> Then use quick popup Data Entry to enter data in table -> Then quick Search By Category Customers phone contains number 647

- To enter data,
either click on the primary key = CUSTOMER_ID for full Data Entry screen. Or click on edit icon in ACTION column for pop-up Data Entry.
-
To Insert Data from quick Popup Data Entry = Any time, click on New button, Form = blank -> Enter Data in blank form -> click Insert button.
-
To Update / Delete / Search data in Popup Data Entry = Select a Category ( = column, like PHONE, EMAIL, NAME, ADDRESS .. ) like NAME -> enter Hue in input search box. Click Search button -> Will load her data in form -> Update, Delete
- OR: click
icon EDIT on that record, like first row will Popup Data Entry -> Load data of Hue in Data Entry form. -> Now do Update / Edit / Delete / Insert  ( see photo )

=>
Click on picture to see larger. The first database can store, display, process photos.

- Very Important read: Create Tables, you need to understand Data Type of its fields like Name varchar (30). See how, Click here.

Office Database Input Data Entry in full screen mode, different with quick Popup Data Entry above.

- Click on the first column any number of Primary Key of a table will open a full screen of Data Entry. You can:
1) Insert/ Update/ Delete: From List all Tables, Open
table like my_support_center ( or click Primary Key number of any record will load Table  Customer from main screen  above ) -> select Search Category = NAME ( Category = column table = email, phone, name .. ), Enter partial = Rose in input box -> click Search button -> Load data of Name = Rose in form -> Then change Phone number, click Update button record of Rose. ( see photo )
- To Delete = click Delete button to delete Rose record. - To Insert: click New button Form = blank. Enter data in form -> click Insert button.

2)
Insert: Any time, click New button, form = blank -> Enter Data in blank form -> Click Insert new record into that table any time.
3) Click on the Primary Key like =3 of the
Display Records row below, Name= Rose P -> Data load in the top form -> Update / Delete
4)
Data Entry for any Tables: From List of all Tables top left -> Select a Table =
my_support_center -> Do Update, Insert, Delete records. Such as, -> click New button, data entry Form = blank. Then enter data -> click Insert button to save data.


Picture: Office Database Data Entry in full screen mode. Below is the
Display List of all records in that current table ( = my_support_center has only 5 records )
->
Scroll Prev, Next  list of record to Update, Delete data, like click on record = 3, NAME = Rose P in this case, will load data in form for Update. See photo
-> Or:
Search a name of that person like Henry based on Category = NAME -> Then Do Update, Delete data of that person

Data also is fetched in tables from other sources, like POS, E-Commerce, Digital Menu, Website form ...


Table is the most important component of database. Net.Office Database has a lot of functions for Tables.
For example: Alter Table, Delete Table, Change Table Name, Add extra Column like ADDRESS, EMAIL in table, Change Column Name, Size, Index Table, Add/Drop Primary Key, Copy table to another database, Encryption / Decryption/ Password Table..
. See Table Menu.

=> Do you know that Table In Net.Office Database is called Big File Cabinet Table that can store unstructured big data like photo, video, map, music. Move, Carry them in Cloud. Play video, music in its database table. MS SQL Server, Oracle store raw data only. See explain in our Blog.

Tables from MS SQL Server, Oracle are raw data tables.
They are used to store raw data, like Text, Numbers, Characters...They are not designed to store unstructured big data like photo, video, map, music...
 

Picture: MS SQL Table: Create Table products -> Insert Table 3 raw data row records.
Data are not just raw data, data are also file, photo, picture, music, video, map...

Picture: Oracle Database Table: List (= SELECT) Table EMPLOYEES display 6 raw data row records.
=> Employees database has no photos. Who is David? Can't see.
=>
Can't put photos, pictures, music, maps, videos... in raw data of traditional database.
 

Net.Office Database Export Table to Excel, or any Query result to Excel.
Also Import Excel sheet data in Table. Also Mouse Drag/Drop column, Resize column width



Picture:
Create table Customer -> Input Data ->  Export Customer table, or Export any SQL query result, to Excel. Result is Customers.xls Excel as seen in picture.
- You can
Export A Query, such as: find all customers who in area code = 905 -> Then Export the query list of customers to Excel.
- You can
Drag and Drop any column field like EMAIL, ADDRESS in different position of a table. In this picture, Drag & Drop column ADDRESS in position of column ACTION.

Import Data from Spreadsheet in a Table

Picture: Import data from 1000 row of Excel Customers.xls into table Customer

Understand Database Relationship in order to build big Enterprise Enterprise Database. This helps you understand how data and information are collected, organized, and processed.   

In real business life, data we collected will have relationship with another data.
For example, the customer data had relationship with the invoice data. Since customer data are stored in Customer database table, and invoice data stored in Invoice table. The relationship of data is also the relationship of tables.
=> You will understand how data and information are collected, organized, and processed.

EDBMS or Enterprise Database Management System is referring to manage the Enterprise Database. See: EDBMS Case Study

● Lucky, The table relationship is created based on common sense, by human, by logics, and not based on rule, or math, or computer science.
Lucky, there are only 3 database relationships: One-to-One, One-to-Many, Many-to-Many.
In order to link, to create table relationship, we use table keys.
In order to build and manage Database Relationship, we use SQL Database Programming. No other Technology.
Don't worry. We will make this difficult topic easy, even grade 12 can understand. We show you to build ERDBMS (Enterprise Database Management System) by writing code SQL like Database Developers.
We will go straight to hand on, to implement, to build RDBMS (Relational Database Management System). No need for tools, for unnecessary theory.
 

NOTE: If you are Database Administrator, DBA, Database Consultants, Business Managers, Engineers please check these videos of College database courses.

NOTE: If you are Computer Scientists, Software Developers, to know how to design database software application, to Architect, Design, and Normalization database software application. For theory,  Read this material: Database Architect, Design, and Normalization.

=> It doesn't matter how much you know, all comes down to this challenge. ** Can you do it **

1) DOCAN = Design data, Organize data, Collect data, Analyze data, Normalize data.

2) Can you architect, design, implement, and build Relational Database Management System for your company?
- For example, in a meeting, the company wants to build a Database Management System, RDBMS: Customers, Orders, Invoices, Warehouse Database System.
Or School needs: Students Courses Marks Schedules Teachers Database Management System.
OR: College Teachers, Students, Classes Attendants, Behaviours Tracking System.
Or company needs: Corporate Sales and Marketing Department Customers, Leads Management System.
OR: Global Technology Company Time Sheet 's Employee, Department Project
=> Can you build it?

3) Can you design, build, write code, program Business Database Software Application for your company?
- For example, in a meeting, the company wants to build a Database Software Application: - Customers, Orders, Invoices, Warehouse Database Software System.
Or School needs Business Database Software Application for: - Students Courses Marks Schedules Teachers Database Management System.
Or: - College Teachers, Students, Classes Attendants, Behaviours Tracking Software System.
Or company needs Business Database Software Application: - Corporate Sales and Marketing Department Customers, Leads Management Software System.
Or: - Technology Company Time Sheet 's Employee, Department Project.
Or:- Business Database Software Application for: - Manufacture's Product Problems and Issues Tracking Software Management System
=> Can you build it?
=> Can you use
Enterprise Java to build these Business Database Software Applications?

=> See 100 RDBMS DATABASE CASES OF STUDY:
100 EDBMS Cases of Study

Net.Office Database, built it SQL Database Programming, lets you build EDBMS (Enterprise Database Management System). And SQL, the only database programming language, is designed for EDBMS.

Now, let's analyse the Database Relationship.

The relationship between
Husbands and Wives are of course One-to-One because each husband can have only one wife, and vice versa, each wife has only one husband.
There is no rule, no math, no computer science, just by logics, by natures.

- The relationship between database
Customers and database Invoices is One-to-Many, because only each customer from the table Customers, for example customer ABC company, had ordered many times, thus customer ABC company had many Invoices, for example Invoice ID = 1000, 1045, 1059, 1120 ...And from the table Invoice, each invoice, example, Invoice ID = 1059, can belong only one customer = ABC. Invoice ID 1059 can't possible belong to another company. Thus we said this relation is One-to-Many because each customer in the table Customer can have many records or many invoices in the table Invoice. But, each invoice ( or each record) in the table Invoice can had one and only one customer (or only one record) from the other table Customer.

To connect Enterprise tables, we use Primary Key and Foreign Key. From these key, we use SQL JOIN, or Query on MULTI TABLES to get data in Enterprise Tables.

- Learn SQL. What is SQL? is Structured Query Language, Database Programming. It is used to communicate with database. It is a database language for Enterprise Database Managements (EDBMS). 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, Windows interface can do.
Databases like ORACLE, Ms SQL Server built in SQL.
- Learn SQL. Become Net.Office Database 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


Database Relation helps grow database bigger from one stand alone table with no relationship into many tables, hundreds of tables with relationships.

*** Let's get started to build a simple Enterprise Database Management System (EDBMS) Husbands and Wives.

But first, understand Database Relationship.


*** What is One-to-One Relationship? Uncommon relationship.

- Two tables are One-to-One Relationship when each record of the left table has one relation with another record of the second table, and vice versa. The record of the second table has only one relationship with one record of the first table.

For example,
the relationship between table Member Login that contains just the login info: Email, Password, and table Members, that contains detail info of members. This is One-to-One relationship because each member can have only one Email. And each Email can belong to only one member

For example, you collect data of all families, husbands and wives in your town. Your create 2 tables. The first table
Husbands contains all data of husbands, and the second table Wives contains data of the wives. These two tables have One-to-One Relationship because a husband named Peter King, in table Husbands can have one and only one wife, named: Amanda Harrison in table wives. And vice versa. Amanda Harrison has only one husband named Peter King in table Husbands.

NOTE: Database Relationship is based on logics, by nature. It is not defined by Computer Science nor Math.
For example, by nature, the Relationship of Husband and Wife is one-to-one Relationship by nature.

This is its Data Sheet of table Husbands and table Wives. Enter data in its table Husbands, table Wives.

HB_ID WIVE_ID NAME PHOTO BIRTH_DATE OCCUPATION SALARY
1 3 John Smith 1965-07-15 Engineer 40000
2 1 Peter King 1980-02-25 Scientist 60000
3 2 Harry Potter 1975-08-27 Accountant 40000
4 4 Mark Ng 1968-06-25 Teacher 35000
WIVE_ID HB_ID NAME PHOTO BIRTH_DATE OCCUPATION INCOME
1 2 Amanda Harrison 1985-05-27 Nurse 40000
2 3 Helene Dang 1978-04-28 Accounting 35000
3 1 Bonne Mitch 1977-05-17 Teacher 45000
4 4 Rose McKinnon 1975-07-25 Engineer 40000


How to connect tables having One-to-One Relationship?

In order to connect 2 tables One-to-One Relationship, you must insert Primary Key = HB_ID of table 1, Husbands, into table 2, Wives, and vice versa. You insert primary key of table 2 Wives = WIVE_ID into table 1 Husbands. If you don't connect Enterprise tables using key, then you can't find data that related to each tables.

For example, in table Husbands, if we know Peter King has wife with WIVE_ID = 1. Thus from the WIVE_ID =1, we can refer back to table Wives, will let we know that Amanda Harrison is the wife.

The code for One-to-One Relationship between Husbands and Wives tables.
 

Create table husbands
(
HB_ID int not null auto_increment,
WIVE_ID int,
/* Insert Primary key of table wives  to create One-to-One Relationship */
Husband_name varchar (40),
Husband_photo varchar (25),
Husband_birth_day date,
Husband_occupation varchar (40),
Husband_income double,
/* Can always add more fields later ok */
primary key (hb_id)
)
Create table wives
(
WIVE_ID int not null auto_increment,
HB_ID int,
/* Insert Primary key of table husbands   to create One-to-One Relationship */
Wife_name varchar (40),
Wife_photo varchar (25),
Wife_birth_day date,
Wife_occupation varchar (40),
Wife_income double,
/* Can always add more fields later ok */
primary key (wive_id)
)

- How to Create Table in Net.Office Database.
=> Using Net.Office Database to create table husbands, table wives, just copy the blue code Create table husbands (...) and paste in Net.Office Database Code Area.
- Then click on Submit SQL button. Then table husbands created. => next, enter data. See How To Create Table in Net.Office Database.


- Picture: Use Net.Office Database to create table Customer


Net.Office Database to find information between 2 tables having the One-to-One relationship

To list all Husbands and Wives between 2 tables, you use INNER JOIN SQL command. You can also use SELECT in multi tables.

SELECT husbands.hb_id, husbands.husband_name, husbands.husband_photo, husbands.husband_birth_day, husbands.husband_occupation, wives.wife_name, wives.wife_photo, wives.wife_birth_day, wives.wife_occupation
FROM husbands
INNER JOIN wives
ON husbands.hb_id=wives.hb_id


Other use of One-to-One Database Relationship: To separate a table into smaller table. Then setup One-to-One Relationship between them.

The One-to-One Relationship is also used for the situation when you want to break up a table into smaller table. And then you connect or link these 2 tables by insert the Primary Key of the small table in the big table. The benefit of splitting a big table into many smaller table and setup One-to-One Relationship is that it makes the big table more efficient, load faster, no data duplication, and easy to manage.

In the example of tables Husbands and Wives, later we add more contact info into both tables. Doing this will take a lot of work. And it is not easy to manage a lot contact info because when you change or update the contact info, you have to update both tables Husbands and wives. Thus, rather adding Contact info in both table Husbands and Wives, we create a new table called Contacts, then link or create a One-to-One relationship of table Contacts to both table Husbands and Wives. When you update or change to contact info, you just need to change table Contacts.

Contacts: 1-on-1 : Husbands
Contacts: 1-on-1 : Wives


How to connect table Contacts having One-to-One Relationship with Husbands and Wives?

To connect  One-to-One Relationship of the separate table and the main table, in this case, you insert the primary key of the separate table (the Primary Key CONTACT_ID of the Contacts table) into the main table (the Husbands and Wives table). The CONTACT_ID in the Husbands and the Wives tables are called the Foreign Key.

For example,  you add the contact info: PHONE, EMAIL, ADDRESS into table Husbands and Wives, both tables will share the same contact info because they are husbands and wives. Therefore, you want to put all contact into in a separate table named Contacts, then you setup a relationship One-to-One between table Husbands - One-to-One with Contacts, and Wives - One-to-One - with Contacts. And then in table Husbands and Wives, you just need to insert the Primary key of table Contacts = Contact_ID in tables Husbands and Wives.

Break up table Husband's contact info (the blue) into a smaller table named Contacts

Data entry spread sheet for table Husbands including Contact info. This table is not efficient, we must move the Contact info into a separate table named Contacts

HB_ID WIVE_ID NAME BIRTH_DATE OCCUPATION SALARY PHONE EMAIL ADDRESS
1 3 John Smith 1965-07-15 Engineer 40000 416-219-1900 john@yahoo.com 1235 Finch street, Toronto
2 1 Peter King 1980-02-25 Scientist 60000 905-314-1900 pking@hotmail.com 90 Keels street, North York
3 2 Harry Potter 1975-08-27 Accountant 40000 647-190-2190 harrypt@yahoo.com 19 Long street
4 4 Mark Ng 1968-06-25 Teacher 35000 213-190-3367 mark ng@hotmail.com 29 Halls street

=> Why New table Contacts?  - It is created to store contact info of Husbands and Wives. This is How 1-to-1 Relationship is created.
Because:
1) Easy to maintain, update contact info in separate table. When you change/update an Address, or add extra field (column) = Photo of the house for Address of Contact info, you don't need to open both table Husbands and Wives to update. You just open one table Contact and update.
2) Rather insert contact info in both table Husbands & Wives not efficient, heavy load, you separate contact info in a separate table. Thus table Husbands & Wives now smaller, quicker, faster loading.

This is its Data Sheet of table Contacts. Will enter Contacts data in its table Contacts.

CONTACT_ID PHONE EMAIL ADDRESS HOUSE_PHOTO
1 416-219-1900 john@yahoo.com 1235 Finch street, Toronto
2 905-314-1900 pking@hotmail.com 90 Keels street, North York
3 647-190-2190 harrypt@yahoo.com 19 Long street
4 213-190-3367 markng@hotmail.com 29 Halls street

Table Husbands now has linked One-to-One Relationship with table Contacts by having the key = CONTACT_ID. This is One-to-One Relationship because each husband (example Peter King) has pointed to only one Contact info (example 2 = 905-314-1900, pking@hotmail.com, 90 Keels street, North York). And each Contact info pointed to only one husband.

New data entry spread sheet for table Husbands. Take out many columns of the contact into, only need to include one column CONTACT_ID, and create One-to-One Relationship.
HB_ID WIVE_ID NAME BIRTH_DATE OCCUPATION SALARY CONTACT_ID
1 3 John Smith 1965-07-15 Engineer 40000 1
2 1 Peter King 1980-02-25 Scientist 60000 2
3 2 Harry Potter 1975-08-27 Accountant 40000 3
4 4 Mark Ng 1968-06-25 Teacher 35000 4


Table Wives also has the One-to-One Relationship with table Contacts by inserting the primary key CONTACT_ID of table Contacts in its table. This is One-to-One Relationship because each wife has pointed to only one Contact info. And each Contact info pointed to only one wife.

New data entry spread sheet for table Wives, just need including CONTACT_ID, and create One-to-One Relationship with Contacts table.

WIVE_ID HB_ID NAME BIRTH_DATE OCCUPATION INCOME CONTACT_ID
1 2 Amanda Harrison 1985-05-27 Nurse 40000 2
2 3 Helene Dang 1978-04-28 Accounting 35000 3
3 1 Bonne Mitch 1977-05-17 Teacher 45000 1
4 4 Rose McKinnon 1975-07-25 Engineer 40000 4


NOTE: The Husbands and Wives share the same Address, phone, same contact info.
Example, Amanda Harrison shares the same Address and contact info with her husband, ID=2= Peter King, Contact Id = 2.

 

The code to create One-to-One Relationship between two separate tables: Husbands, Wives with Contacts.

Create table husbands
(
HB_ID int not null auto_increment,
WIVE_ID int,
CONTACT_ID int
, /* Add CONTACT_ID primary key of table contacts to create One-to-One Relationship*/
Husband_name varchar (40),
Husband_photo varchar (25),
Husband_birth_day date,
Husband_occupation varchar (40),
Husband_income double,
/* Add more fields or change name fields later OK. No effect data in table */
primary key (hb_id)
)
Create table wives
(
WIVE_ID int not null auto_increment,
HB_ID int,
CONTACT_ID int
, /* Add CONTACT_ID primary key of table contacts to create One-to-One Relationship */
Wife_name varchar (40),
Wife_photo varchar (25),
Wife_birth_day date,
Wife_occupation varchar (40),
Wife_income double,
/* Add more fields or change name fields later OK */
primary key (wive_id)
)
Create table contacts
(
CONTACT_ID int not null auto_increment,
Phone varchar (40),
Email varchar (40),
Address varchar (140),

/* Add more fields or change name fields later OK, like add field = city, province, country */

House_Photo varchar (40),

primary key (contact_id)
)

Can use the same Primary Key for tables having One-to-One Relationship. Make it simple.

To make it simple, you can use One Primary Key for tables having One-to-One Relationship.
For example, Husbands: One-to-One Wives, and Husbands: One-to-One Contacts. You can have one Primary Key named: HB_WIVE_ID. And then use this Primary Key for all three tables. But you will lost the ability to find information of each table as separate entity. For example, find :"- Get data of all husbands who like hockey."
=> Use same Primary Key is good in situation you have a big Table many fields, like Table Employee, then you break this table into many smaller table for easy manage, fast loading.

The code

Create table husbands
(
HB_WIVE_ID int not null auto_increment,
/*Use same Primary Key = HB_WIVE_ID for One-to-One*/
Husband_name varchar (40),
Husband_photo varchar (25),
Husband_birth_day date,
Husband_occupation varchar (40),
Husband_income double,
/* Add more fields or change name fields later OK. No effect data in table */
primary key (
HB_WIVE_ID)
)
Create table wives
(
HB_WIVE_ID int not null auto_increment,
/*Use same Primary Key = HB_WIVE_ID */
Wife_name varchar (40),
Wife_photo varchar (25),
Wife_birth_day date,
Wife_occupation varchar (40),
Wife_income double,
/* Add more fields or change name fields later OK */
primary key (HB_WIVE_ID)
)
Create table contacts
(
HB_WIVE_ID int not null auto_increment,
/*Use same Primary Key = HB_WIVE_ID */
Phone varchar (40),
Email varchar (40),
Address varchar (140),

/* Add more fields or change name fields later OK */
Photo varchar (100),

primary key (
HB_WIVE_ID)
)


The bottom line to create One-to-One Relationship

For example, Husbands: One-to-One Contacts, and Husbands: One-to-One Wives

- To make it simple, you can use primary key name =
HB_WIVE_ID, same name primary key of table Husbands, for the Contacts table, and Wives table, thus these tables shared the same key.  - For example, table Husbands, Wives, Contacts can share the same primary key name = HB_WIVE_ID.

- But if you want to have different primary key name =
CONTACT_ID for the Contacts table, because Contacts table will also have the relationship with other tables, so it needs its own primary key name, then you should put the CONTACT_ID in table Husbands to be a foreign key.
 


-
Table Assets: One-to-One Relationship with table Status.
- Both has different primary key name.
- Put the Primary key of table Status = StatusID in Assets table. Similar the Husbands and Contacts tables.

Recommended: This One-to-One Relationship using the same Primary Key = Employee# for both table.
- This will maintain both tables to have exact value because both tables have exact same Primary Key.
- This good when you can use the same primary key name = Employee# for primary key for both tables.

- This One-to-One Relationship using the same Primary Key is used when you want to split a big table Employee into smaller table. Or extend a table. Then link both tables using the same Primary Key.

Table Ticket: One-to-One Relationship with table Customer because a customer needs one ticket to get in. And a Ticket i.e: 005 belongs to a customer, i.e: John Smith.

- Both has different primary key name.
- Insert Primary Key of Customer table = CustomerID in table Ticket. Similar the Husbands and Contacts tables.

=> This method when you have two tables are different entity, and each has its own key.

- Because Ticket is different with Customer, you can't use name =  TicketID as the Primary Key name for Customer table. You should use primary key name = CustomerID for Customer table.


One-to-One Table Relationship's Benefits: Scalability, efficient, load faster, easy to manage data

One of the best use of 1-to-1 Relationship is to expand, scale a table bigger by adding new table having 1-to-1 relationship.

- Or break down a big table into many smaller tables then create 1-to-1 relationship between them => It is more efficient, easy to manage, easy to update, change, load faster by breaking down a big table into many smaller tables.
- For example, you have table Employees. Rather adding the Contact info fields of Employees into table Employees, you create a new table called Employee_Contact. Then create a 1-to-1 Relationship between two tables.


Net.Office Database uses SQL JOIN command to join and list 3 or more Enterprise tables.

SELECT contacts.contact_id, husbands.husband_photo, wives.wife_photo, contacts.phone, contacts.email, contacts.address, husbands.husband_name, husbands.husband_occupation, wives.wife_name, wives.wife_occupation
FROM contacts
LEFT JOIN husbands ON contacts.contact_id = husbands.contact_id
RIGHT JOIN wives ON contacts.contact_id = wives.contact_id
ORDER BY contact_id ASC

-- Same result as Use SQL Search into Multi- Tables --

SELECT contacts.contact_id, husbands.husband_photo, wives.wife_photo, contacts.phone, contacts.email, contacts.address, husbands.husband_name, husbands.husband_occupation, wives.wife_name, wives.wife_occupation
FROM contacts, husbands, wives
/* Search into multi tables */
WHERE contacts.contact_id = husbands.contact_id
AND contacts.contact_id = wives.contact_id
ORDER BY contact_id ASC



Picture: Use SQL JOIN command or SQL Multi tables command, you can get all info in 3 different One-to-One Enterprise Tables, and display the info.

NOTE: Click on each column heading of table to sort that column UP or DOWN (ASC, DESC). Use quick Category Search to filter data by Category.

Another example: To separate ADDRESS in table Customers into a new table Addresses. Then link One-to-One Relationship between 2 tables.
Thus, each customer has only one address. And each address is belonging to one and only one customer.

NOTICE: In other to link One-to-One Relationship between the table Customer and the Address table, we put the Primary Key of table Addresses = address_id in table Customers. The address_id now becomes the Foreign Key in table Customer.
 


- Split field Customer_Address contact in table Customers as a separate table. Then establish 1-to-1 relationship between two table. Although you can have Customer_Address as a field in table Customers. No need to split. No thing wrong.

- Table Customers and table Address has 1-to-1 Relationship. Put the PK, Primary Key of table Addresses = address_id, in table Customers to establish the 1-to-1 relationship.

What happens if we don't link Enterprise tables using key?

Then two tables can't linked, can't connect. Thus, we have 2 stand alone tables. Thus your database contains all stand alone tables. Thus, you can't find who is the wife of that husband John Smith. You can't find the contact info of husbands and wives.

Now, let go to the most popular database relationship: One-to-Many.
 

 



***
What is One-to-Many Relationship? The most popular relationship.

Two tables are
One-to-Many Relationship when each record of the Left table (like Customer table) has at least one (many) relation with another record of the right table ( like Invoice table). And a record of the right table has only one relationship with a record of the left table.
For example, the Customers and Invoice tables have One-to-Many relationship. = Customer (left table): 1-to-Many : Invoice table (right table)
Because e
ach customer, for example John Smith, CUSTOMER_ID=1, has more than one invoice. Invoice_ID = 100, 103... And an Invoice_ID in the Right table, for example 100, can belong to only one customer ID=1, in this case: John Smith. It is not possible for INVOICE_ID = 100 belong to another customer. See data sheet.

=> A table can have multi one-to-many relationship with different tables. For example, table Customer can have 1-to-Many relationship with table Invoice. And 1-to-Many Relationship with table Products. And 1-to-one Relationship with table Contact.

NOTE: Database Relationship is based on logics, by nature. It is not defined by Computer Science nor Math.
For example, by nature, the Relationship of Customer and Invoice is
One-to-Many Relationship by nature, by logics. Because each Customer can have many Invoices. But an Invoice is belonged to a Customer only. This is based on logics. No Math, no Computer Science.


=> To create the One-to-Many Relationship between two tables, all you need to do is:
- Include Primary Key of the One table (the Left Table = Customer table) into the Many table (the right table = Invoice table). DONE!


NOTE: The left table is also called the One table, or the Parent table, or the Master table. The Right table is called the Many tale, or the Children table, or the Detail table.

-
The Data Entry spread sheet for Customer table.
CUSTOMER_ID NAME PHOTO EmployeeID PHONE EMAIL ADDRESS
1 John Smith 3 416-219-1900 john@yahoo.com 1235 Finch street, Toronto
2 Peter King 5 905-314-1900 pking@hotmail.com 90 Keels street, North York
3 Rose McKinnon 7 647-190-2190 rosemc@yahoo.com 19 Long street
4 Mark Ng 6 213-190-3367 markng@hotmail.com 29 Halls street
5 Shanon Dang 3 647-810-2190 shanon@abcd.com 2110 Nice street
6 Don Ng 8 647-660-1190 don_ng@yahoo.com 189 Sheppard street
7  Hue Y 2 647-222-2190 hue@hotmail.com 2190 Class street

- The spread sheet Invoice table
INVOICE_ID CUSTOMER_ID INVOICE_DATE SUB_TOTAL
100 1 2012-06-12 500.0$
101 3 2012-06-20 625.0$
102 2 2012-06-20 1025.0$
103 1 2012-06-25 350.0$
104 4 2012-06-26 250.0$
105 5 2012-06-26 150.0$
106 6 2012-06-29 100.0$
107 3 2012-07-02 120.0$
108 7 2012-07-03 130.0$
109 1 2012-07-03 30.0$
110 7 2012-07-04 200.0$
111 2 2012-07-04 140.0$
112 3 2012-07-04 210.0$
113 5 2012-07-05 300.0$
114 4 2012-07-05 150.0$
115 1 2012-07-05 250.0$

Why table Customer and Invoice have One-to-Many Relationship?

Because a customer = John Smith, CUSTOMER_ID=1, in the Left table, or the Customer table has 3 invoices ordered, INVOICE_ID = 100, 103, 109, 115. But a record ( or a row) in the Right table, in this case is the Invoice, has one and only one relationship with one customer. Example, INVOICE_ID = 100 belongs to one and the only John Smith. Or invoice = 105 is of Shanon Dang. If INVOICE_ID = 100 also belong to another customer, then this invoice is fake because impossible for an invoice belong to two different customers.

The code: Create Table and Setup the table key to link tables having One-to-Many Relationship

=> All you need to do is to add the Primary Key = CUSTOMER_ID of the One table, or the Left table, or the Customer table, in the Many table or the Invoice table.
Thus the table Invoice now has a new column = CUSTOMER_ID (integer). And the CUSTOMER_ID is called the Foreign Key of the Invoice table.

 
Create table customer
(
Customer_ID int not null auto_increment,
Name varchar (30),
Phone varchar (40),
Email varchar (40),
Address varchar (140),
primary key (Customer_ID )
)
Create table invoice
(
Invoice_ID int not null auto_increment,
Customer_ID int, /* Add CustomerID of Customer table to make 1-to-Many relationship with Invoice table.*/
Invoice_Date date,
Sub_Total double ,
primary key (Invoice_id)
)


To find info, data of tables having One-to-Many Relationship: Customer and Invoice table
 
Use SQL INNER JOIN to join and display 2 tables.

SELECT invoice.invoice_id, invoice.invoice_date, invoice.sub_total, invoice.sub_total* 0.13 as 13_percent_Tax, customer.customer_id, customer.name, customer.photo, customer.phone, customer.email, customer.address, employees.employeeid
FROM customer
INNER JOIN invoice
ON customer.customer_id = invoice.customer_id
INNER JOIN employees
ON customer.employeeid = employees.employeeid
ORDER BY invoice_date DESC
Use SQL Query for Multi- Tables

SELECT invoice.invoice_id, invoice.invoice_date, invoice.sub_total, customer.name, customer.phone, customer.email, customer.address
FROM customer, invoice
WHERE customer.customer_id = invoice.customer_id
ORDER BY invoice_date DESC


Picture: This query will list all Invoices, Invoice Date, Sub_Total, 13% Tax, detail info of Customers, and EmployeeID who sold these orders.

- Click on each column to sort UP or DOWN (ASC, DESC). Use quick Category Search to filter data by Category. For example, to list Invoice from the most SUB_TOTAL to the least, click on column SUB_TOTAL. Click again to sort from the least to the most SUB_TOTAL

-  Mouse hover on EmployeeID =6 will show all information about that Employee. Otherwise, user looks at the number EmployeeID = 6 will not understand anything. Table Customer has 1-to-Many with table Employees who are Sales Executives of customers.

 
To find how much each customer bought.

SELECT customer.customer_id, customer.name, customer.photo, sum(invoice.sub_total) as Total_Purchase, customer.phone, customer.email, customer.address
FROM customer
INNER JOIN invoice
ON customer.customer_id = invoice.customer_id
GROUP BY NAME
ORDER BY customer_id ASC
To find how much sales each day: Daily Sales Total and Tax Report

SELECT invoice.invoice_date, sum(invoice.sub_total) as Daily_Sales_Total , sum(invoice.sub_total) * 0.13 as 13_Percent_Sales_Tax
FROM customer
INNER JOIN invoice
ON customer.customer_id = invoice.customer_id
GROUP BY INVOICE_DATE
ORDER BY invoice_date DESC


See picture below
To find daily Total Sales from Date: June 1 to Sept 1

SELECT invoice.invoice_date, sum(invoice.sub_total) as Daily_Total_Sales
FROM customer
INNER JOIN invoice
ON customer.customer_id = invoice.customer_id
WHERE invoice_date >= '2012-06-01' AND invoice_date <= '2012-09-01'
GROUP BY INVOICE_DATE

 

To find Total of daily Sales with 13% Tax included.


Picture: Daily Total Sales Report


To find how much each customer spent total


NOTE: Click on each column heading of table to sort that column UP or DOWN (ASC, DESC). Use quick Category Search to filter data by Category.
 

*** Let's continue to expand Enterprise Database Management System (EDBMS) Husbands and Wives by Adding their Children information that has 1-to-Many Relationship.

The Children table is: One-to-Many Relationship to the Parents ...

We have learnt the relationship between Husbands and Wives table is One-to-One Relationship. We learned to write SQL code how to connect both table Husbands and Wives.
Then we expand table Husbands and Wives by adding Contacts table and setup One-to-One relationship.
Now, we continue expand table Husbands and Wives by adding Children table and setup One-to-Many relationship to table Husbands and Wives.

So how do we do expand more tables, add table Children and create One-to-Many Relationship with both tables Husbands and Wives?

1) Define the new relationship of new table Children.

We expand, add the relationship of the new table Children with table Husbands and Wives. It is a One-to-Many Relationship to both  Husbands and Wives because:

- A Child in the table Children can have only one father in table Husbands. And a father in table Husbands can have many children in table Children. It is impossible a child in table Children named Dan Smith of John Smith is his the father, is also a child of Peter King.

Husband: 1- Many : Children ( = A father can have many children, but a child can belong to only one father.)

- A Child in the table Children can only one mother in table Wives, and vice versa, an husband in table Husbands can have many children in table Children.

Wives : 1- Many : Children ( = A mother can have may children, but a child can belong to only one mother.) 

NOTE: In One to Many relationship, the table has 1, like table Husband, Wives, always put at left side.

( left table )
Wives : 1- Many : Children => Wives   Children. OR: One-to-Many Relationship of tables. Symbol = 1 ---

2) Define the keys. And write the SQL code.


The code for One-to-Many Relationship between Parent and Children

- All we need to do is add the Primary Keys of the tables Husbands and Wives tables, in the Children table.
 
Create table husbands
(
HB_ID int not null auto_increment,
WIVE_ID int,
CONTACT_ID int
,
Husband_name varchar (40),
Husband_photo varchar (25),
Husband_birth_day date,
Husband_occupation varchar (40),
Husband_income double,
/* Expand table, add more fields later ok */
primary key (
HB_ID)
)

- No change in table keys
Create table wives
(
WIVE_ID int not null auto_increment,
HB_ID int,
CONTACT_ID int
,
Wife_name varchar (40),
Wife_photo varchar (25),
Wife_birth_day date,
Wife_occupation varchar (40),
Wife_income double,
/* Add more fields later ok */
primary key (
WIVE_ID)
)

- No change in table keys

Create table contacts
(
CONTACT_ID int not null auto_increment,
Phone varchar (40),
Email varchar (40),
Address varchar (140),
/* Add more fields later ok */
primary key (
CONTACT_ID)
)

- No change in table keys

Create table children
(
CHILD_ID int not null auto_increment,
/* Add Primary Key of table Husbands = HB_ID in order to create One-to-Many with fathers, the husbands table */
HB_ID int,  
/* - Add Primary key = WIVE_ID  to create One-to-Many with mothers, the wives  table */
WIVE_ID
int,
 Child_firstname varchar (20),
Child_lastname varchar (20),
Child_birth_day date,
Child_education varchar (20),
/* Add more fields later ok */
primary key (
CHILD_ID)
)
- Change in table keys

Thus, we expanded the Husbands and Wives table to more tables with different relationship: table Contacts (One-to-One), table Children (One-to-Many)

- See example above, table Customer is 1-to-Many Relationship with table Invoice. Because a customer John Smith can have (bought) many invoices. But an Invoice like invoice 100, is belonged to customer John Smith only. Invoice 100 can't belong to another customer. => Thus we put Primary Key of table Customer = Customer_ID into table Invoice.
 
Create table customer
(
Customer_ID int not null auto_increment,
Name varchar (30),
Phone varchar (40),
Email varchar (40),
Address varchar (140),
primary key (Customer_ID )
)
Create table invoice
(
Invoice_ID int not null auto_increment,
Customer_ID int, /* Add CustomerID of Customer table to make 1-to-Many relationship with Invoice table.*/
Invoice_Date date,
Sub_Total double ,
primary key (Invoice_id)
)


A table can have multi different relationships with different tables.
For example, the table Husbands has One-to-One with table Wives, and One-to-Many with table Children.

More examples of tables having One-to-Many Relationship
 

- This schema from MS SQL Server
In this Enterprise Tables Schematic, there are many One-to-Many Relationship of tables. The symbol = 1 ---

For example:

- The Suppliers and the Products
has 1-to-Many Relationship.
- Because. one Supplier can supply many products. But each product, is bought or supplied from a Supplier. To link Supplies and Products table, we add Primary Key SupplierID of table Suppliers into table Products. The SupplierID in table Products is called: Foreign Key..

Products: 1-to-Many Suppliers


- The Customers and the Orders has 1-to-Many Relationship.
- Because a Customer in table Customers had bought one or many Orders. But an Order #101 was bought by a Customer. Not possible for Order #101 bought by 2 different customers. To link Customers and Orders table, we add Primary Key CustomerID of table Customers into table Orders. The CustomerID in table Products is called: Foreign Key.

- The Employees and the Orders has 1-to-Many Relationship.
- Because an Employee could sell many Orders. But an Order 101 was sold by an Employee. To link Employees and Orders table, we add Primary Key EmployeeID of table Employees into table Orders. The EmployeeID in table Products is called: Foreign Key.

- The Products and the Orders has Many-to-Many Relationship.
- Because an Order can have many Products on its order. And a Product can be ordered by many Orders. Thus we create a new table named Order Details to connect table Orders and Products. Table Order Details called adjunct Table or bridge table.
See Many-to-Many Relationship.



*** What is Many-to-Many Relationship?

Two tables are
Many-to-Many Relationship when a record ( like row 101) of the Left table (Orders) has at least one (many) relation(s) with many records (10, 12, 15 of the second table (Products). And, vice versa, a record (like ProductID 10 ) of the Right table (= Products) has at least one (many) relationship with many records (101, 103, 104) of the Left table (Orders).

Example, an order invoice = 101, ordered by customer ID = 5, had ordered many products = (10, Chicken Soup) , (12, Chicken Rice), (15,
Blue Sky Berry Ice Cubes).
And product (10, Chicken Soup) had been ordered in order Invoice 101, 103, and 104. See tables below.

Examples of Many-to-Many Relationship: Orders: Many-to-Many : Products

The relationship between table Orders and Products is Many-to-Many. WHY? => Because each order record, for example, order
101, can contains many products that are ordered, such as: 10, 12, 15 on the invoice 101. And vice versa, a product 10 = Chicken Soup, can be on many different orders, such as: order id 101, 103, 104.


Need to break up Many-to-Many Relationship into 2 x of One-to-Many Relationship

We can’t represent a Many-to-Many relationship directly in a database relation scheme. Many-to-Many database relationship is not acceptable.

*** WARNING *** If we do not resolve Many-to-Many Relationship, database will cause data errors, duplication, lost data integrity, even lost data.

To resole Many-to-Many Relationship, we must use a Junction table (or also called Bridge table), like table Order Details, in order to break Many-to-Many Relationship in 2 of One-to-Many Relationship.
 
Table Orders
OrderID CustomerID Order Date
101 5 2012-07-15
102 2 2012-07-15
103 5 2012-07-16
104 1 2012-07-16
105 3 2012-07-16
Table Order Details (Like order Invoice) is the Junction Table that is used to break up Many-to-Many Relationship of Orders & Products.
OrderID ProductID Quantity Unit Price
101 10 1 5.5
101 12 2 8
101 15 3 12
102 16 2 3
103 10 2 5.5
104 10 2 5.50
104 15 1 12
105 16 1 3
Table Products
ProductID Product Name Unit Price
10 Chicken Soup 5.50
11 Beef Soup 7
12 Chicken Rice 8
13 Noodle Soup 6
14 Beef Rice 5.50
15 Blue Sky Berry Ice Cubes 12
16 Homemade Hot Chocolate 3
17 Combo 8.50

- From the tables, we have table Orders has One-to-Many relation with table Order Details. And table Products has One-to-Many relation with table Order Details.
- Order 101 has multiple ordered products. Order 102 has only one order product = 15 =
Blue Sky Berry Ice Cubes.

How to link tables having Many-to-Many Relationship? The code.

1) Introduce new
Junction table (table Order Details)

2) In the
Junction table (table Order Details) will contain the primary keys OrderID and ProductID of the two tables having Many -to- Many Relationship, which is:
Orders and Products.
=> Add the Primary Key of the two break up Tables, in this case: tables
Products and tables Orders, in to the Junction table ( table OrderDetails).

NOTE: For safe, we should have Primary Key (ORDERDETAILS_ID) for the junction table (OrderDetails) because table must have primary key. A table can have only one PK.

3)
The code:

Create table Orders
(
OrderID int not null auto_increment,
CustomerID int,
OrderDate date,
primary key (OrderID)
)
Create table OrderDetails
(
ORDERDETAILS_ID int not null auto_increment, /*PK of OrderDetails */
OrderID int,    /* PK of table Orders, FK of OrderDetails*/
ProductID int, /* PK of table Products, FK of OrderDetails*/
Quantity int,
UnitPrice double,
primary key (
ORDERDETAILS_ID)
)

NOTE:
OrderID, ProductID is PK of table Orders, Products, also FK (Foreign Key) of OrderDetails
Create table Products
(
ProductID int,
ProductName  varchar(100),
UnitPrice double,
primary key (ProductID)
)

Other Examples of Many-to-Many Database Relationship

The Invoice example

In this table Invoice, Product, Many-to-Many example.

The Product and Invoice tables have Many-to-Many relationship.
Because an Invoice (e.g. 5631) can have many products  ordered (Product ID=1, 2) on its invoice. And a Product (e.g. 1) can be ordered on many Invoices (Invoice ID=5631, 5633, 5634 had ordered of Product ID=1). This is called the Many-to-Many Relationship.

Thus many-to-Many Relationship is not acceptable.
We must create a new table Invoice Detail as a Junction table or also called the Bridge table to split between table Product and Invoice.

To link the Invoice Detail table with the Product and Invoice table, it must contain the 2 foreign keys: P_ID of the Product table, and the Inv_ID of the Invoice table.

<=: See the left picture.


The SQL code of database table Many-to-Many Relationship: Product, Invoice Detail, Invoice

Create table Product
(
P_ID int not null auto_increment,
P_Name  varchar(100),
primary key (P_ID)
)
Create table InvoiceDetail
(
INVOICEDETAIL_ID int not null auto_increment, /* PK of InvoiceDetail table */

P_ID int,    /* primary key of table Product*/
Inv_ID int, /* primary key of table Invoice*/

primary key (
INVOICEDETAIL_ID)
)

- T
his Invoice Detail is called: the Junction or Bridge table between table Product and Invoice.
- P_ID, Inv_ID are called foreign keys (FK).
Create table Invoice
(
Inv_ID int not null auto_increment,
Inv_Date date,
primary key (Inv_ID)
)

More other examples of Many -to -Many Relationship



Picture: Table People and table Addresses have Many-to-Many Relationship.

Because each Person in table People can live or have many addresses in table Addresses.
And vice versa, Address in table Addresses can contain many person in table People.

- Thus, we must break this Many-to-Many by introducing new Junction Table People_xref_Addresses. And this People_xref_Addresses contains 2 foreign keys address_id and person_id, which are the primary keys of table People and table Addresses. See picture.
 


Picture: Table Book and table Patron have Many-to-Many Relationship.

Because each Book in table Book can be borrowed by many Patron in table Patron.
And vice versa, Patron in table Patron can borrow many books in table Book.

- Thus, we must break this Many-to-Many by introducing new Junction Table Borrowed. And this Borrowed contains 2 foreign keys Book_id and Patron_id, which are the primary keys of table Book and table Patron. See picture.
Beer
Table Beer: Many-to-Many Table Distributor. Because a beer (like 157) is distributed by many Beer Distributors (=AC001, AB899, AC009). And a Beer Distributor (AC009) can distribute many beers (=157, 158, 163). The Junction table = Beer_Distributor is used to break up Many-to-Many Relationship between table beer and table distributor. For example,
- Before: Table beer: Many-to-Many Relationship with table Distributor. => Not acceptable.
- Now: Table beer: One-to-Many Relationship with table Beer_Distributor.
- Now: Table distributor: One-to-Many Relationship with table Beer_Distributor.
=> As a result, we break up from 1 Many-to-Many Relationship before into 2 different 1-to-Many Relationship now.

 

- Table Person: Many-to-Many table StoreLocations. The Junction table = PersonStores.
- Person: Many-to-Many table Breweries. The Junction table = FavoriteBreweries.

 



Case Study:
Let's expand the Enterprise Database Management System (EDBMS) Husbands and Wives. Adding the Husband's Hobbies information

The Hobbies is Many-to-Many Relationship with the Husbands. Why? See explain below.

- We have learnt the relationship between Husbands and Wives table is One-to-One Relationship. Because A Husband can have only one Wife. And  A Wife can only have one Husband. NOTE: The Database Relationship is defined by nature, by logics. It is not defined by formula nor math nor computer.
- We learned to write SQL code how to connect both table Husbands and Wives.

- Then we expand table Husbands and Wives by adding Contacts table and setup One-to-One relationship.

- Then we expand table Husbands and Wives by adding Children table and setup One-to-Many relationship to table Husbands and Wives.

-
Now, we continue to expand table Husbands and Wives to collect data and information about the hobbies of Husbands and Wives. Let's adding a table Hobbies for Husbands.

New Table Hobbies
HOBBY_ID HOBBY_NAME HOBBY_PHOTO
1 Music
2 Golf
3 Tennis
4 Movies
5 Jogging
6 Hockey

So how do we do expand database by adding a table Hobbies?

1) Define the relationship of new table.

We continue to extend table Husbands and Wives with new table Hobbies. We begin to setup its relationship.

=> It is a Many-to-Many Relationship to Husbands table because you have a many-to-many relationship when a single record in one table can relate to many records in another, and a single record in that second table can also relate to many records in the first = A husband can have many hobbies and a hobby can be liked by many husbands.

For example, a record of table husband, example John Smith, record ( or row)  ID = 1, can have many many records of hobbies, such as: Music, Golf, Movies. And a record of hobby, example record HOBBY_ID = 2 = Golf, can have many husbands like. Therefore, the relationship is Many-to-Many

Husbands: Many-to-Many : Hobbies

However, Many-to-Many relationship of Husband and Hobbies is not acceptable in database design, so we introduce a new junction table: husband_hobbies in order to create 2 of One-to-Many relationship.

Husbands: One-to-Many : Husband_Hobbies
Hobbies: One-to-Many : Husband_Hobbies


2) Define the keys. And write the SQL code.

 
Create table husbands
(
HB_ID int not null auto_increment,
WIVE_ID int,
CONTACT_ID int
,
Husband_name varchar (40),
Husband_photo varchar (25),
Husband_birth_day date,
Husband_occupation varchar (40),
Husband_income double,
/* Add more fields later ok */
primary key (
HB_ID)
)
Create table husband_hobbies
(
HUSBAND_HOBBY_ID int not null auto_increment,
HOBBY_ID int, /* One-to-Many with the hobbies table */
HB_ID int,
/* One-to-Many with the husbands table */
primary key (
HUSBAND_HOBBY_ID)
)

- husband_hobbies is a junction table.
- Junction table should have Primary Key =
HUSBAND_HOBBY_ID

Create table hobbies
(
HOBBY_ID int not null auto_increment,
Hobby_name varchar (20),
Hobby_photo varchar (30),
/* Add more fields later ok */
primary key (
HOBBY_ID)
)

Let's bring back table: Husbands from previously defined from One-to-One Relationship

HB_ID WIVE_ID NAME BIRTH_DATE OCCUPATION SALARY CONTACT_ID
1 3 John Smith 1965-07-15 Engineer 40000 1
2 1 Peter King 1980-02-25 Scientist 60000 2
3 2 Harry Potter 1975-08-27 Accountant 40000 3
4 4 Mark Ng 1968-06-25 Teacher 35000 4


The data entry spread sheet for new junction table Husband_Hobbies

HUSBAND_HOBBY_ID HOBBY_ID HB_ID Explain Key connection
1 1 1 (HOBBY_ID=1) Music - John Smith (HB_ID=1)
2 2 4 Golf - Mark Ng
3 3 1 Tennis - John Smith
4 1 2 Music - Peter King
5 4 3 Movies - Harry Potter
6 5 1 Jogging - John Smith
7 6 2 Hockey - Peter King
8 6 3 Hockey - Harry Potter

From the table husband_hobbies, we see that a husband ID = 1, John Smith has many hobbies: Music - ID=1,  Jogging - ID=6, Tenis - ID=3.
And hobby, Music - ID=1, can have many husbands love, like: John Smith, Peter King.


Use Net.Office Database to join Many-to-Many Relationship and list table Husbands and Husband_hobbies. The code

SELECT husband_hobbies.HUSBAND_HOBBY_ID, husbands.husband_name, husbands.husband_photo, husbands.husband_occupation, hobbies.hobby_photo, hobbies.hobby_name
FROM husband_hobbies
LEFT JOIN husbands ON husband_hobbies.hb_id = husbands.hb_id
INNER JOIN hobbies ON husband_hobbies.hobby_id = hobbies.hobby_id
ORDER BY HUSBAND_HOBBY_ID ASC

 



MS SQL Server and Net.Office Database to join, list, search in multi tables. Net.Office Database photo sharing.

=> Database stores data and information. A picture adds a thousand words in database.

So you want to list the Husbands Name, his Photo, his Occupation, his wife Name, photo, her Occupation, their contact Address, the husband Hobby...
This involves join, and list, search into 5 tables: Husbands, Hobbies, Husband_hobbies, Wives, Contacts

SELECT husbands.husband_name , husbands.husband_photo, wives.wife_photo, wives.wife_name, husbands.husband_occupation, contacts.address, contacts.house_photo, hobbies.hobby_name as husbands_hobby, hobbies.hobby_photo
FROM husband_hobbies
LEFT JOIN husbands ON husband_hobbies.hb_id = husbands.hb_id
RIGHT JOIN hobbies ON husband_hobbies.hobby_id = hobbies.hobby_id
LEFT JOIN wives ON husbands.hb_id = wives.hb_id
LEFT JOIN contacts ON husbands.contact_id = contacts.contact_id
ORDER BY HUSBAND_HOBBY_ID DESC



Picture: Net.Office Database JOIN 5 tables and display photos. Net.Office Database made easy for sharing photos, displaying photos, and embedding photos.

- Click on each column heading of table to sort that column UP or DOWN (ASC, DESC). Use quick Category Search to filter data by Category.

- Mouse over photo to resize photo bigger to its original size. Move mouse out photo back to small size.

- It is very easy to put photos, pictures, files in database with no hard coding. For example, adding column Food_Photo in table Food_hobbies, you will do:

1) Add a new column called: Food_Photo in table Food_Hobbies using this SQL = Alter table Food_Hobbies add Food_Photo varchar (40)

2) Next, click this icon to upload photos, files from laptop, PC into the column Food_Hobbies.

Back on top

NOTE: myNet.Office lets you Insert this database list in front end webpage. People can search, scroll this list, share photos.


Picture: MS SQL Server JOIN tables
 


*** Let's continue to expand the EDBMS Husbands and Wives. Adding the Wife's Food Hobbies information

 Relation symbol: -> for One-to-One . And => Used for One-to-Many. And <=> Used for Many-to-Many

Let's review:

1) Husbands: One-to-One -> Wives
2) Expand, Husbands, Wives: One-to-One -> Contacts
3) Expand, Husbands, Wives: One-to-Many => Children.
 

Create table husbands
(
HB_ID int not null auto_increment,
WIVE_ID int,
CONTACT_ID int
,
Husband_name varchar (40),
Husband_photo varchar (25),
Husband_birth_day date,
Husband_occupation varchar (40),
Husband_income double,
/* Expand table. Add more fields later later ok  */
primary key (
HB_ID)
)
Create table wives
(
WIVE_ID int not null auto_increment,
HB_ID int,
CONTACT_ID int
,
Wife_name varchar (40),
Wife_photo varchar (25),
Wife_birth_day date,
Wife_occupation varchar (40),
Wife_income double,
/* Expand table. Add more fields later later ok */
primary key (
WIVE_ID)
)
Create table contacts
(
CONTACT_ID int not null auto_increment,
Phone varchar (40),
Email varchar (40),
Address varchar (140),
/* Add more fields later  ok */
primary key (
CONTACT_ID)
)
Create table children
(
CHILD_ID int not null auto_increment,
HB_ID int,    
/* One-to-Many with fathers, the husbands table */
WIVE_ID int,
/* One-to-Many with mothers, the wives  table */ Child_firstname varchar (20),
Child_lastname varchar (20),
Child_birth_day date,
Child_education varchar (20),
/* Expand table. Add more fields later ok */
primary key (
CHILD_ID)
)

4) Expand, Husbands: Many-to-Many <=> Hobbies

Create table husbands
(
HB_ID int not null auto_increment,
WIVE_ID int,
CONTACT_ID int
,
Husband_name varchar (40),
Husband_photo varchar (25),
Husband_birth_day date,
Husband_occupation varchar (40),
Husband_income double,
/* Expand table. Add more fields later ok */
primary key (
HB_ID)
)
Create table husband_hobbies
(
HUSBAND_HOBBY_ID int not null auto_increment,
HOBBY_ID int, /* One-to-Many with the hobbies table */
HB_ID int,
/* One-to-Many with the husbands table */
primary key (
HUSBAND_HOBBY_ID)
)

- husband_hobbies is a junction table.
- Primary Key is:
HUSBAND_HOBBY_ID

Create table hobbies
(
HOBBY_ID int not null auto_increment,
Hobby_name varchar (20),
Hobby_photo varchar (30),
/* Add more fields ok */
primary key (
HOBBY_ID)
)

5) Let's expand, Wives: Many-to-Many <=> Food_Hobbies

In order to add Food Hobbies for the Wives, we will do the following 2 steps:

1) Define the relationship of new table: Food Hobbies with table Wives.

It is a Many-to-Many Relationship of table Food_Hobbies to table Wives because you have a many-to-many relationship when a single record in one table (Wives), can relate to many records in another table (Food Hobbies), and a single record in that second table (Food Hobbies) can also relate to many records in the first (Wives).

A wife can love many foods and a food can be liked by many wives.

Wives: Many-to-Many <=> Food_Hobbies

However, Many-to-Many relationship of Wives and Hobbies is not acceptable in database design, so we introduce a new junction table: Wives_Food_Hobbies in order to create 2 of One-to-Many relationship.

Wives: One-to-Many =>  Wives_Food_Hobbies
Food_Hobbies: One-to-Many =>  Wives_Food_Hobbies


2) Define the keys. And write the SQL code.

Create table wives
(
WIVE_ID int not null auto_increment,
HB_ID int,
CONTACT_ID int
,
Wife_name varchar (40),
Wife_photo varchar (25),
Wife_birth_day date,
Wife_occupation varchar (40),
Wife_income double,
/* Expand table. Add more fields later ok */
primary key (
WIVE_ID)
)

NOTE: Nothing changed
Create table wives_food_hobbies
(
WIFE_FOOD_HOBBY_ID int not null auto_increment,
FOOD_HOBBY_ID int, /* One-to-Many with the food_hobbies table */
WIVE_ID int,
/* One-to-Many with the wives table */
primary key (
WIFE_FOOD_HOBBY_ID)
)

wives_food_hobbies is a new junction table is used in order to split Many-to-Many Relationship between: wives and food_hobbies

NOTE: The new junction table wives_food_hobbies should have Primary Key = WIFE_FOOD_HOBBY_ID

Create table food_hobbies
(
FOOD_HOBBY_ID int not null auto_increment,
Food_Hobby_name varchar (20),
Food_Hobby_photo varchar (30),
/* Expand table. Add more fields later  ok */
primary key (
FOOD_HOBBY_ID)
)

NOTE: The new food_hobbies table

The data sheet of table; food_hobbies
 

FOOD_HOBBY_ID FOOD_HOBBY_NAME FOOD_HOBBY_PHOTO
1 Chicken Soup
2 Beef Rice
3 Japan Soup
4 Coffee
5 Pho
6 Pho Mi

Let's bring back the Data entry spread sheet of the Wives table in the One-to-One Relationship

WIVE_ID HB_ID NAME BIRTH_DATE OCCUPATION INCOME CONTACT_ID
1 2 Amanda Harrison 1985-05-27 Nurse 40000 2
2 3 Helene Dang 1978-04-28 Accounting 35000 3
3 1 Bonne Mitch 1977-05-17 Teacher 45000 1
4 4 Rose McKinnon 1975-07-25 Engineer 40000 4


The Data sheet for junction table:  wives_food_hobbies

WIVE_FOOD_HOBBY_ID FOOD_HOBBY_ID WIVE_ID Explain Key connection
1 1 1 (FOOD_HOBBY_ID=1) Chicken Soup - Amanda Harrison (WIVE_ID=1)
2 5 4 Pho - Rose McKinnon
3 4 1 Coffee - Amanda Harrison
4 2 2 Beef Rice - Helene Dang
5 2 3 Beef Rice - Bonne Mitch
6 3 2 Japan Soup - Helene Dang
7 6 4 Pho Mi - Rose McKinnon
8 5 3 Pho - Bonne Mitch

Net.Office Database to join, search, list 5 multi tables: Wives, Food_Hobbies, Wives_food_hobbies, Husbands, Contacts. The code.

So you want to list the Husbands Name, his Photo, Wife Name, Wife Photo, Food Name, Food Photo, their contact Address, the husband Hobby...  Sorted by Wife Name.

SELECT contacts.email, husbands.husband_name, husbands.husband_photo, wives.wife_name , wives.wife_photo, food_hobbies.food_hobby_name as Food_Name, food_hobbies.food_hobby_photo as Food_Photo, contacts.address, contacts.house_photo
FROM wives_food_hobbies
INNER JOIN wives ON wives_food_hobbies.wive_id = wives.wive_id
RIGHT JOIN food_hobbies ON wives_food_hobbies.food_hobby_id = food_hobbies.food_hobby_id
LEFT JOIN husbands ON husbands.hb_id = wives.hb_id
LEFT JOIN contacts ON husbands.contact_id = contacts.contact_id
ORDER BY email DESC 



Picture: Net.Office Database JOIN 5 tables. Click on column heading to sort ASC, DESC. Use quick Category Search to filter data by Category.

Now, let's JOIN Husband & Wives, and their Hobbies, their Foods, their Houses, Their Contact... all together.
=> This Husbands & Wives CONTACT LIST is special because it contains PHOTOS and MAPS
.
You will not see this CONTACT LIST in any databases can do like this.
- This CONTACT LIST collects & analyzes data from 6 database tables:
- Table
HUSBANDS that contained data of HUSBANDS, such as: NAME, PHONE, EMAIL...
- Table
WIVES contains all kinds of data about Wives.
- Table
FOODS contains all kinds of data about Foods.
- Table
CONTACT contains all kinds of data about contacts of Husbands, Wives.
- Table
HOBBIES contains all kinds of data about Hobbies of Wives, Husbands.
- And table
HOUSES contains all kinds of data, map about Houses.
- Then Net.Office Database
JOIN all data to give you the CONTACT LIST that includes their NAMES, EMAIL, ADDRESS, the FOODS, HOBBIES they like, the Address, the Maps of the Houses they live, and the Photos of HUSBANDS, photos of WIVES, photos of FOODS, photos of HOBBIES, photos of their HOUSES, and MAP.
- Use mouse to resize photo in database bigger.
- View MAP of their Houses.


Picture: Husbands & Wives Contact List include HOBBIES & FOOD they liked, Photo of their houses, address, and map.
=> You will not see any databases that can do CONTACT LIST like this.

Ms SQL Server to Join tables


Picture: MS SQL SERVER JOIN  2 sport tables: table bbteam, and table bbplayer

Picture: MS SQL SERVER JOIN 3 tables: Orders, Order Details, Products

To Add a Relationship or to Drop a Relationship

To Drop a Relationship: After having created a relationship between 2 tables, to cancel its relationship, you just need to take out the Enterprise key. All your tables are unchanged.
Example, to cancel One-to-Many Relationship between table customer and table invoice, you just need to take out the Foreign Key = Customer_ID in table invoice.
The code is: Alter Table invoice drop Customer_ID

To Create/Add a Relationship between 2 tables: You just need to add the Primary Key of the Left Table into the Right Table. All your tables are unchanged.
For example, you already had
table customer and table invoice, now, you want to add One-to-Many Relationship between these two tables, you just need to add Customer_ID into invoice table.
The code is: Alter Table invoice Add Customer_ID int
 

Create table customer
(
Customer_ID int not null auto_increment,
Name varchar (30),
Phone varchar (40),
Email varchar (40),
Address varchar (140),
primary key (Customer_ID )
)
Create table invoice
(
Invoice_ID int not null auto_increment,
Customer_ID int, /* Add CustomerID of Customer table to make 1-to-Many relationship with Invoice table.*/
Invoice_Date date,
Sub_Total double ,
primary key (Invoice_id)
)


Office Database Relationship Manager to keep track and manage the all Relationships.

- A table can have many relationships with many other tables. When there are so many relationships in EDBMS, it is very hard to remember, to keep track, and to manage all relationships.

You can draw all relation diagrams on paper, on graph. But it is very hard to manage and keep track relationship data on paper diagram, graph diagram.
For example, the Husbands and Wives EDBMS has in total 9 relations between tables.

A tool called: Office Database Relationship Manager Tool in Net.Office Database is used to save and manage all Relationships.

** IMPORTANT ** You must use this tool to create Table Relationship because Net.Office Database looks up the relationship of this tool when you run JOIN queries.

=> With this tool, you can:
1) Add relationship
.= For example, you Create Table Customer and table Order. -> You know Customer : 1-to-Many Order -> You use this tool to create 1-to-Many Relationship.
2) Delete, Break the relationship. = It will break the 1-to-Many relationship between Customer & Order
3) Look at its table data structure, like the Create Table code.
4) Relation View = Create View of selected Fields interest in Relationship and ROID ( = Relational Object ID ). = For example, a table Customer has 20 fields, but you want to see 10 fields of data, such as, Phone, Email, Name ..
5) Sort Tables by click on each header of column, such as, click LEFT_TABLE = sort tables, <Prev, Next>. This let you see a List of Relationship of Table Products having Relationship with other tables.

=>
This tool only helps manage Relationship, but doesn't help you to find How to Relationship between Tables.
- For example, you have to find what is Relationship between table Customer and Order by yourself. -> Then you Create Tables of Customer, table Order -> Then you use this Tool to Create the Relationship between Customer and Order. So that you can keep track all Table Relationship.

=> We use this
Office Database Relationship Manager Tool to find all related data of relationship of a Table. For example, it keeps track table Product has 3 Relationship with table Supply, table Customer, table Order => Thus this tool helps us find all related data of Orders, Customers, Supply that related to Product.

For example, when you get data, including Product_ID key -> Office Database Relationship Manager Tool lets us know table Products has Product_ID primary key, and has 3 Relationships with table Supply, table Order, table Customer -> Thus use ROID ( Relational Object ID ) based on key = Product_ID, we can find all data related to Products => by look up Relationship Manager Tool. For example:

Since table Product Related to table Orders, we can Get Data :

- List of Orders related to this Product. Such as, - List all Orders of Products & Services, including Total Amount ( 5000$ ), Total Cost ( 3500$ ), Total Profit  ( 1500$ ), Total Sales Qty ( 250 ), Total Tax sold today, or this week, this month, from Date to Date?
"- List all Orders that had Product_ID = 2 = T-Shirt Summer Sport Yellow including Total Sales Amount ( 3000$ sold of this T-shirt  ), Total Cost ( 1800$ cost of this T-shirt  ), Total Profit  ( 700$ ), Total In-Stock Qty ( 200 items in stock of this T-shirt, Product_ID = 2 is T-Shirt Summer Sport Yellow ), Total Sales Qty ( 150 of this T-shirt ), Total Tax sold today, or this week, this month, from Date to Date? ".
"- Calculate Total Amount ( 2000$ ), Total Qty ( 100 ), TotalTax ( 200$ of 10% tax ) of Orders that had Product_ID = 2 from Date= 1-August to Date = 15 August? "
"- Listing Orders, its Date & Time, its Customers info, such as, Address, Country.. that are Shipping / Delivery / Pickup this today, next 3 days, this Month, from Date to Date? "
"- Listing Orders, its Date & Time, its Customers, Address, that are Shipping / Delivery / Pickup of Orders that had Product_ID = 2 from this week, this Month, from Date to Date? "
- For example, when customers made order online. They let us know Date & Time expecting to pickup by enter in Checkout - Form. NOTE: Data given is just an example.
-> Thus, list of getting data goes on...

Since table Product Related to table Customers, we can Get Data:
- List of Customers related to this Product. Such as, "- List all Customers that bought all kinds of Products & Services, including Total Amount ( 5000$ ), Total Cost ( 3500$ ), Total Profit  ( 1500$ ), Total Qty ( 250 ), Total Tax sold today, or this week, this month, from Date to Date?
"- List all Customers that bought Product_ID = 2 = T-Shirt Summer Sport Yellow, including Total Amount ( 3200$ ), Total Cost ( 1800$ ), Total Profit  ( 700$ ), Total In-Stock Qty ( 200 of this T-shirt ), Total Sales Qty ( 160 ), Total Count ( customers bought this product 15 times ), Total Tax old today, this week, this month, from Date to Date ?
- List Top 10 of Customers bought this product ID = 2
"
- List all products bought by Customer John Smith?  "
- How much Total Amount ( 500$ ), Total Cost ( 350$ ), Total Profit  ( 150$ ), Total Qty ( 25 ), Total Count ( 5 times he bought this product ) that customer John Smith bought the Product with Product_ID = 2  (= T-Shirt Summer Sport Yellow  ) ?"
-> List of getting data goes on...

Since table Product Related to table Suppliers, we can Get Data:
- List of Suppliers Supplies related to this Product, such as, "- List all suppliers that supply Product_ID = 2 = T-Shirt Summer Sport Yellow  "
"-
Who are suppliers to supply best price
( by listing all supply's prices then sort ) for Product with Product_ID = 2 = T-Shirt Summer Sport Yellow  "  -> > List of getting data goes on...

=> That's why you see, in one-screen, Office Database Get so many Data that other databases CAN'T



Picture: Use this tool to Create Table Relationship for table 1_view_contact (Left): 1-to-Many table 1contact (Right).

- And select fields of table 1_view_contact in order to create View Relationship (ROID View) in column RELATION_VIEW.
- In the picture, you see: One-to-Many Relationship of (Table Left) customers = 1-to-Many: orders (Table right). And the Relationship View or ROID View in column RELATION_VIEW.
- Net.Office Database Database Relationship Manager manages and lists all relationships in big Enterprise EDBMS.
- Table Relationship is all about the key. What inside the table, the table field, is not important.

From the Listing Table Relationship, we can easily see, track all relationships and the relation key they shared. Click here see Relationship Diagram

- Table products: 1-to-Many => orderdetails = Yes (Many-to-Many) in a Many-to-Many Relationship with table orders, because orderdetails is a junction table between Products: Many-to-Many: Orders
- Table employees: One-to-Many => orders. And employees ROID View.
- Table customers: One-to-Many => orders. And customers ROID View.
- Table products: One-to-Many  => suppliers. And products ROID View.

 

Conclusion Husband and Wives EDBMS

● We just gave you an example of a EDBMS database: Husbands and Wives. This EDBMS has all relationships: One-to-One, One-to-Many, and Many-to-Many.

● A table can have many different relationships with different tables. Example, table Husbands had One-to-One with Wives, and Contact tables, and One-to-Many with Children table, and Many-to-Many with Husband_Hobbies table. You create the table relationship based on common sense, logics. The Relationship is not created based on rule, or math, or computer science.

● Even after the table already been created, we can always go back to add more fields, example Add TITLE field, change the name of field of that table, or delete the file without effecting the table and its data. But please do not change name, or delete the Relationship Key, example CustomerID, which is the Primary Key, or the Foreign Key.

To create One-to-One Relationship of Tbl_A (left) and Tbl_B (right) :
Tbl_A ->  Tbl_B, put the Primary Key of Tbl_A, in Tbl_B, and vice versa, put the Primary Key of Tbl_B in Tbl_A.
- Example: table Husbands: One-to-One -> Wives.
- In the case, use One-to-One Relationship in order to split big table into smaller tables, you just only need to put the Primary Key of the splitting smaller table in the big table.
- Example, the Husbands and the Contacts table. Split the contact info of Husbands table, then create a smaller table Contact to store contact info of Husbands. Then create One-to-One Relationship by adding the CONTACT_ID, the Primary Key of Contacts table, in the Husbands table.
- Recommend: Use the same Primary Key for group of tables One-to-One Relationship. For example, use the same Primary Key = HB_WIVE_ID for group of tables One-to-One Relationship: Husbands, Wives, and Contacts since Husbands: One-to-One Wives, Husbands: One-to-One Contacts.

● To create One-to-Many Relationship of Tbl_A and Tbl_B:
Tbl_A =>  Tbl_B, put the Primary Key of Tbl_A (pkA), in Tbl_B. pkA is called Foreign Key of Tbl_B. DONE!
- Example:
Customer: One-to-Many => Orders. Because in this One-to-Many Relationship: "- a Customer ordered at least one Orders. And an Order can belong to one and only one Customer." Thus, table Customer is in the left position or the One table. And table Orders is in the right position or the Many table.

● To create Many-to-Many Relationship of Tbl_A and Tbl_B:
Tbl_A: <=> Tbl_B, create a junction table Tbl_J. This Tbl_J will contain the Primary Key of Tbl_A, and Primary Key of Tbl_B.
Example: Husbands: Many-to-Many <=> Hobbies. Thus create a Junction Table = Husband_Hobbies.

● Even after tables already having created, to create a relationship between two tables, you just need to add a key, to drop relationship, you just need to take out the key.
- To add a field = pkA Integer in table Tbl_B, the code = After Table  Tbl_B Add pkA int.  - To drop a field = pkA from table Tbl_B, the code = After Table  Tbl_B Drop pkA  

● To connect data and information of all related tables, we use JOIN command.

● We also showed you how to create the relationship, to create tables, to add more tables, expand database from 2 tables to 10 tables. ** We also show you the code **

● Following our steps, you now can add more tables, create more relationships, and expand your EDBMS.


Case Study: Build Database Management System Begins with Company's Invoice.

- Database, like Excel spreadsheet, can't just generate data by itself because it doesn't know what info, data, such as: Product Name, Unit Price, Address... Some thing or some body has to input data in database. Thus data will come from different sources like Invoice.
 

- Company Invoice will give you a lot data and information needed. Such as:

How to input data manually in company's EDBMS using Net.Office Database? There are 3 different ways to input data in EDBMS:

1) Staff login myNet.Office website as Admin -> Open Net.Office Database -> 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.


2) Use myNet.Office Member Collaboration Form  to create data entry form for tables in EDBMS -> 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 EDBMS. 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 EDBMS'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 EDBMS.

NOTE: Do not collect data that is calculated in database, such as: AMOUNT, TOTAL.. because database will do all the calculations.

Picture: Invoice is the most important fact number of a whole business. It needs to analyze by Database.

You Can't Manage anything if you Can't Measure the Numbers. You don't even Know if you lost something. => You need to get data, to get the numbers fast by 1 click.

 
- Compare this result of extracting data from invoices with the result of extracting data from Excel examples you will find below, they are the same.

- After extract invoice data into different database tables, please continue below, after extract data from Excel, how we design the database schema, write SQL Create Table, and put everything in database.

3) Use Net.Office Smart Form Builder to create smart form data entry for tables in EDBMS 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 EDBMS 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.

Data Source # 2) Data collected and automatically input from online business E-Commerce website using the same database EDBMS.
Don't separate Online Business Database and Off line Business Database into 2 different databases. Thus will cause a lot of headache and problems to manage data every where. Thus waste more time to input data from online business database into off line business database, and vice versa, in order to keep both databases the same data.


NOTE: If the company used different database, one for website online business, and one for in-house offline business. Then this will be very difficult for that company to manage data because the company has two different databases.

Data Source # 3) Get Input data from Excel spreadsheet in database if needed. => Spreadsheet Data must be database normalized first.
- If your business used spreadsheet as a substitute for database. Now, it is time to use database more efficient. Because spreadsheet can't do complex Data Analytics compared to database.
Data from spreadsheet must be normalized by 3NF ( 3 rules of Normal Form)  first to prevent duplicate rows, redundant data. Because Excel spread sheet is not database. It doesn't have relationship like 1-to-Many between spread sheets like EDBMS. It can't run SQL database language. Therefore, it stored data differently. Because no database, so people had no choice but to use spread sheet for simple analytic. Data in Excel spread sheet must be normalized so that data can be analyzed and used by database.

Data Source # 4) Get Input data fast from Net.Office Pos like taking orders fast from Invoice.

Database Normalization - How to?

Definition of Database Normalization: Normalization is the process of organizing data in a database. This includes creating tables and establishing relationships between those tables according to rules designed both to protect the data and to make the database more flexible by eliminating redundancy and inconsistent dependency.
For example, the process of extracting data from invoice. And then Create tables and its relationships is called: Database Normalization.

What kind of Database that uses Database Normalization? High-end databases like Oracle, Ms SQL Server, IBM DB2 ....
Database Normalization is about Database Design. It doesn't matter you use expensive high-end databases or not, if you design no good database, bad database design, not understand Database Normalization, your data will be not good. Different Database Developers architect different Database Design, and Write different database programming code.. - It is like driving a car, even you drive top expensive luxurious million dollars car, if you are no good driver, you still have accidence, even more dangerous to drive luxurious cars without good experience.

** Important ** No high end Database, only a tool, helps you good Database Design ( like Database Schema we gave you ), helps you write good Database Programming. You have to help yourself or hire developers. => However, use Net.Office, we already had Database Design, and SQL app for you.


Spread sheet is like a big table. You can't JOIN 2 or more spread sheets like you JOIN Customer table with Order table, with other tables in database in order to see holistic view of Customer. In this example, we will transform Invoice spreadsheet -> Invoice database so that you can get a lot of data from Invoice. You can't get such Invoice database's data if used spread sheet Invoice or paper invoice.

Spreadsheet's data needs to be normalized so that its data can be used by database.
Let's do Database Normalization for this Invoice Excel.

=> We show you step by step to normalize this Invoice Excel to database Invoice from 1NF to 3NF.

 
 
=> Invoice is real time Data. This is paper Invoice can be converted directly to  -> database Invoice. You can't get data from this paper Invoice.
 

- This spread sheet invoice is converted from the paper invoice above. You can't get data from spreadsheet Invoice. Spreadsheet Invoice is converted to Invoice Database. -> Now we can get data.

- This is the original flat Invoice Excel example used in order to store Orders sold... You don't see but we see a lot of row data duplication, data redundant.
- OK, right now you can't see. But after the normalization, you will see. What you see? Please wait and go through this exercise then you will see what you should see.

Please correct the Item ID 652 = 3" Red Free in Excel below => is the Item ID 692 = 3" Red Free of the example Invoice.



=> We show you step by step to normalize this Excel Invoice to database Invoice using Database Normalization 1NF to 3NF, so that you can get a lot of data from Invoice.
 
- 1NF Normal Form =
• Eliminate repeating groups in individual tables.
• Create a separate table for each set of related data.
• Identify each set of related data with a primary key.




 
- 2NF Normal Form =
• Eliminate redundant Data, the repeating of Row Data.
• Create separate tables for sets of values that apply to multiple records.
• Relate these tables with a foreign key.

 
Last 3 NF Normal Form =
• Eliminate fields that do not depend on the key.


The final data after going though 3NF. Excel has no more row duplications and data redundant.

But not yet, you need to 4 steps to bring (= import or enter) Excel data in database table: (See these steps below)
1) You need to create a schema or diagram (see diagram below)  for this Invoice
2) Create Tables use SQL program. (See SQL code below). Use Net.Office Database to create theses tables like Excel tables.
3) Data Entry from Invoice paper into database. For example, use Net.Office Pos get data from Invoice paper in database in few seconds like taking orders ... Note: How long does your staff create an Invoice?
NOTE: You can also Create Table and Populate data from spreadsheet Excel to Database Tables without SQL code. Click here.

4) Now use SQL Programs to do what ever you want to get data.

STEP 1) Create Database Schema and table relationship for Invoice Database.
It is OK
to draw this Table Relationship diagram on paper for easy to remember, keep track. You need to write code to create tables and relationships.


STEP 2) Next,  Write SQL codes.  Create Tables ...
Copy the blue code, Paste into Net.Office Database Code Area. Click [Submit SQL] button to create tables.
To know more Data Type, like Int, varchar (240), date.. For Data Type, Click here

STEP 3)  Data Entry: Next, use Net.Office Database to Create tables and Enter data from the Excel sheets in tables.
You can also Create Table and Populate data from spreadsheet Excel to Database Tables.


STEP 4) Write SQL Program:
Now, you got data input in Net.Office Database, what ever you want to do with data depends on your SQL Programming.

From Spreadsheet Invoice, Paper Invoice can't analyze, can't see holistic of invoice => to Invoice Database can analyze so many things. Open your mind to holistic view.

Now you can see the different between paper Invoice, spreadsheet Invoice, and database Invoice. Open mind a lot of people use Invoice spreadsheet or Invoice paper. They though they know a lot about Invoice, but don't.


=> What do you see from this paper invoice everyday at your company?

=> You don't see anything from this paper Invoice. That's why most paper Invoices buried in stack of papers or in hard drive never use.
What a lost for business.

=> But we see a lot of gold data in this paper invoice after we used
Net.Office to convert this paper invoice to database invoice for Data Analytics.

Let's get data from this Invoice Database Management System:

1
) - What are Products & Services sold the most, the least, hot sellers, worst sellers, seasons sellers?
-
Give you data about hot, worst seller Products, Pricing, Inventory... For example, know the hot seller products, least sellers, season sellers, you can order more or less, in Winter or Summer, good for warehouse space, stock Inventory, Pricing your products..
2) - Who are best Suppliers and their Contact info give the best Price of products?
- For example, How long did take your Purchase Managers to order and to get the best Price for 50 products, in 1000 Products inventory, from 100 Suppliers that have different Prices for the Products? => Database can search, query hundreds of Suppliers, their Contacts get best Price of 50 Products in 10s.
Save Purchase Managers
hours. => Excel Price List is not helping because Excel is not database.
3) - What are the most returned products? Who are the customers returned most products? WHY?
=> Give you data about Customer Care Management. Why did they return products?
4) - Listing all Products Inventory, short fall, Units On Orders, Unit in Stocks...
- Give you data about Inventory Management...
5) - Listing different Prices of Suppliers for each Product so that we can choose best Price of Supplier for each Product.
=> Give you data about Price Management, Purchase Management... So on... Can't list more..
6) - How much Total Sales, Total Taxes collected in period? Who are the Suppliers to supply that Product, their Contacts, Listing Prices?
7) - Who are top 10 customers, VIPs, repeat Customers, their Contact..? What they buy? How much VIPs, customers used to spend?
8) - List Invoices Daily, monthly, yearly Sub Total, Total Sales, Total Taxes? Who are customers still not pay for invoices, their balances?
9) - What are the pending invoice?
10) - Listing who are new Customers we get daily, monthly, yearly?
11) - Who are the Sales Employees sold the most invoices, the least.. And who their customers? Get listing of invoices / Employee?
12) - Get the list of Customers in details (Customer History) their Contacts, Profiles, Company, Total Purchase, Invoices from the most to least?
13) - Get the Listing of the top 10 Customers, including their Profiles, Contact Managers, their Total Revenues, their Total Purchase, And Products they bought from our company.
14) - Get the List of Customers who bought > 500$, and Launch eCampaign give them 5% coupon, promotion based on their Total Orders.
15) - Get the list of Customers who not buy, not come back for more orders in 6 months, in a year? Who are our Sales Execs responsible for these Customers on Invoice? Why their customers not come back? Can we do something to bring these customers back?
=> Give you data about Customer Management.
16) - Listing and Group By all customer's Orders, Total Sales, Taxes... sort order in ASC & DESC from big to small Orders, from small to big
17) - Use different JOIN to see holistic views of order, customer..

Only database can search through thousands of orders, products, customers, invoices, then join & match. Human can't do this.

18) - Listing all How much profit / invoice? Listing cost / invoice for all invoices? 
19) - List top 10 most profit invoices? List all invoices not making money if any?
20) - How many invoices, orders of each Sales Employee sold per day, per month, per year?
21)
- Based on Invoice data, Listing Who are our best Sales Employees of the Week, Month ? See their Photos, Resumes, Managers...
22)
- Based on Invoice data, Listing Who are our need improved Sales Employees of the Week, Month? See their Photos, their info..
23) - List simple things like Total Sales, Total Net Profits, Total Revenues per month, per period, per year, or from period to period.
24) - Get the Listing of the Departments, the Divisions, the Regions that generate the most revenues, the most profits.
Sort them in ASC, DESC get the most, the least, the top 10, 20...
25) - Get the Listing of the Managers of the Departments, the Divisions, the Regions that generate the most revenues, the most profits. Sort them in ASC, DESC to get the most, the least.
26) - Where the locations, stores sold the most, the least revenue by looking up invoices.. And Total Revenue of each location, store? Sort them in ASC, DESC to get the most, the least.
27) - Get the list of Orders delivery today, tomorrow, next days, in between date.
28) - Get a Listing of customers who need services, have appointment tomorrow. Then one click send them email to remind the services.
29) - List who is the in-house Driver or the Shipping Company that shipped the Orders in between date or between period.
30) - List Orders or Invoices that had most profits to least profits in between date or between period.
31)
- Get data of Products & Services of customer John Smith bought from date to date, any date, such as: from Jan 1 to April 30?
32)
Get the list of all Customers who bought Products A & Package A. Now we sell them Accessories AB related to Products A or Package AB related Package A
( Cross Selling / Up Selling ). One-click, send CTA (Call-to-Action) Form to them to Order, Donation, Register...


NOTE: Use Net.Office, you can always add more columns or fields in table to fit your needs, even table already created having data in it.
- For example, in this Orders table, we don't have
Cheque numbers, PO numbers, you can always add columns Cheque number, PO number, Account number, Account Name ... in Orders table. So that when you list, search for orders, you can see Cheque number, PO number, Account number, Account Name, Phone number, What ever number ... of each order included. => Use your creative ideas *** Database or Software, even AI (Artificial Intelligence) knows because human feed data for them ***


Case Study:*** Let's build a Enterprise Database Management System for MyRestaurant.com from ground up *

MyRestaurant.com is online restaurant that provides services and online delivery to more than 100 cities in the country.

MyRestaurant.com
company is needing a database for their company and for their website.
Can't run business in the modern day without database.
The database is used to store data and information of Suppliers, Products, Orders, Invoice Order Details, Employees, Customers, and more...
The same database is also used for their online business. Because they don't want to separate their business into 2 different databases: One for business and one for online.
Which makes very difficult to manage and process data and information.

Begin with the company Database schema and Create Tables


Picture: The schema of a business's database used for online and offline. This diagram courtesy from Microsoft SQL Server EDBMS. Other Schemas are complex than this one. Click more schema EDBMS Study. (Enterprise Database Management System) interest you. Big Enterprise Database like Oracle, MS SQL Server, IBM DB2.. All used schema.
-
You are Day Care Manager. What you see Day Care Center? 15 Tables Click here.
- You are Manufacture Manager. What you see about Manufacture Bill of Material ? Click here

- You are Restaurant Manager. What you see about A Delivery System ? Click here
- You are eCommerce Manager. What you see about E-Commerce System ? Click here or this e-com system
=> If the Managers said I don't need it to understand. Then the Managers don't understand what they are doing because schema is all about data, organize data, analyze data.
- This Ms Business Process Management (BPM) schema, I don't see anything? I don't understand. Only 7 tables, what they see? => Depend on what you know, and want to know. You may not see anything. But database EDBMS helps you see a lot from the 7 tables schema. Do you see Invoices were created from this schema? Even experience Managers don't understand, don't see. * If Data Scientists put on your shoes, they will see more and more and more* That's why called: Database Management Information System (DBMS, MIS), Database Software Application..
- What Net.Office Database help you sees this schema: Click here
 


- Click here to know How to collect Data and implement Data Type, like Varchar, Int, Double, Date ...

 - SQL Create Table for table Suppliers

SQL Code Table Data Entry
Create table suppliers
(
SupplierID int not null auto_increment,
CompanyName varchar (40),
ContactName varchar (40),
ContactTitle varchar (40),
Address varchar (100),
City varchar (20),
Region varchar (20),
PostalCode varchar (10),
Country varchar (20),
Phone varchar (20),
Fax varchar (20),
HomePage varchar (40),
/* Add more fields ok */
logo varchar (40),
primary key (SupplierID)
)
The suppliers table has the relationship 1-to-Many with the Products table:
 
- Suppliers: 1 - to - Many => Products.
Thus, Thus put its primary key = SupplierID of table has Suppliers (1) relation into the table in Products table (many) relation.

- Can always expand table, add more fields. For example to add field = EMAIL after ContactTitle column.

Alter table  suppliers add email varchar (50) after ContactTitle

- Data Sheet for table Suppliers
SupplierID ComapnyName ContactName   Address City Region PostalCode Country Phone Email Fax HomePage Logo
1 Wall Mart Ken Smith Director 1245 Keels Street Toronto ON M2W 1A5 Canada 1-800-219-1300 ken@wallmart.com 1-800-219-1301 www.WallMArt.com
2 Lowes Helex Tan Manager 45 Finch Street New York New York M1W 1A9 US 1-800-419-3290 helex@lowes.com 1-800-419-3289 www.Lowes.com
3 K-mart Ryan B VP 5 Else Street North York ON M3W 1B5 Canada 1-800-219-2290 ryan@kmart.com 1-800-219-2289 www.Kmart.com
4 BTT Super Market Peter Wells CEO 4 Main Street Toronto ON W3K 1A5 Canada 1-800-432-3290 peter@btt.ca 1-800-432-3239 www.BTT.com
5 Foods Inc Rose Koch CEO 425 East Street Toronto ON L3A 1D5 Canada 416-321-0790 rose@foodinc.com 905-419-3289 www.FoodInc.com
 

Create table categories
(
CategoryID int not null auto_increment,
CategoryName varchar (40),
Description varchar (40),
Picture varchar (40),
/* Add more fields ok */
primary key (
CategoryID)
)

The Categories table has the relationship 1-to-Many with the Products table

- Categories: 1 - to - Many => Products.
Thus, Thus put its primary key = CategoryID of table has Categories (1) relation into the table in Products table (many) relation.
 
CategoryID CategoryName Description Picture
1 RICE All Rice products  
2 SOUP All Soup products  
3 BEVERAGE All Drink products  
4 COMBO All Combo products  
Create table Products
(
ProductID int not null auto_increment,
ProductName varchar (40),
SupplierID int,   /* Primary Key of Suppliers table */
CategoryID int , /* Primary Key of Categories table */
Picture varchar (40),
UnitPrice double,
UnitsInStock int,
UnitsOnOrder int,
ReorderLevel int,
Discontinued enum ('yes', 'no', 'pending'),
/* Add more fields ok */
primary key (
ProductID)
)
The Products table has the relationship with OrderDetails, Suppliers, Categories:

- Product:    1 - to - Many => Order Details. Thus put its primary key = ProductID in OrderDetails table.

- Suppliers:  1 - to - Many => Products. Thus put its primary key = SupplierID in Products table.

- Categories: 1 - to - Many => Products. Thus put its primary key = CategoryID in Products table.

Data Entry:
Example, ProductID 1 = Chicken Soup, CategoryID = 2 => Look up in table Category, Chicken Soup in SOUP category = 2.
SupplierID = 5 because its ingredient bought from Foods Inc, ID =5.

Data Sheet for table Products. NOTE: MSRP = Manufacture Suggested Retail Price.
ProductID ProductName Photo SupplierID CategoryID UnitPrice MSRP_UNITCOST UnitsInStock UnitsOnOrder ReorderLevel Discontinued
1 Chicken Soup 5 2 5 3.5 100 30 20 no
2 Beef Soup 3 2 6 4 100 20 30 no
3 Japan Soup 1 2 6.50 4 300 15 20 no
4 Chicken Rice 3 1 5 2 100 35 30 no
5 Beef Rice 2 1 8 4 500 50 100 no
6 Blue Sky Berry Ice Cubes 2 3 3 1 100 60 20 no
7 Homemade Hot Chocolate 4 3 2.50 1.5 100 5 20 no
8 Combo 1 5 4 8 4 100 1 20 no
9 Combo 2 3 4 9 5 100 1 30 no
10 Fried Rice 4 1 7 3 400 10 20 no
11 Wine 1 3 150 90 100 0 30 yes
Create table orders
(
OrderID int not null auto_increment,
CustomerID int, /* customers table*/
EmployeeID int, /* employees table*/
OrderDate date,
RequireDate date,
ShipDate date,
ShipViva varchar (30),
Freight varchar (30),
ShipName varchar (30),
ShipAddress varchar (100),
ShipRegion varchar (20),
ShipCountry varchar (20),
/* Add more fields, like Ship_Company_Name, Estemate_Date_Arrival, Track_Number.. Ok. Or create a separate Shipper table, then create a relationship. */
primary key (OrderID)
)
NOTE: To add more cols, such as: Phone, Address,  after column ShipDate, run this SQL:
Alter Table Orders Add Phone  varchar(100) default '416', Address varchar(100) default 'x' after ShipDate
 

 
- Data Sheet for table Orders
OrderID CustomerID EmployeeID OrderDate RequireDate ShipDate ShipViva Freight ShipName ShipAddress ShipRegion ShipCountry
100 2 3 2012-07-02 2012-07-03 2012-07-02 UBS 6.0 Peter King, IBM 445 Warden Street Markham Canada
101 10 2 2012-07-02 2012-07-02 2012-07-02 Pickup 0.0 Erin, TNM 215 Nice Street North York Canada
102 5 7 2012-07-02 2012-07-02 2012-07-02 Fed Ex 5 H. Simpson, Dynamics, Inc 9005 King Street Toronto Canada
103 4 1 2012-07-03 2012-07-03 2012-07-03 UBS 10 Dave, NetInc 514 Main Street Toronto Canada
104 1 2 2012-07-03 2012-07-04 2012-07-03 UBS 20 John. Smith, Good Life 115 Keels Street NY US
105 2 4 2012-07-03 2012-07-03 2012-07-03 Purolator 5 Peter King, IBM 445 Warden Street Toronto Canada
106 3 1 2012-07-04 2012-07-07 2012-07-05 UBS 30 Hue Nguyen, X-Mart 75 Else Street HK China
107 6 8 2012-07-04 2012-07-04 2012-07-04 Purolator 3.0 Paul Will, Will Investment 210 Bay Street Toronto Canada
108 1 4 2012-07-05 2012-07-06 2012-07-05 FedDex 25.0 John. Smith, Good Life 115 Keels Street NY US
109 7 1 2012-07-05 2012-07-05 2012-07-05 Purolator 6.0 Bob. Byrd, TD 1008 Sheppard Street Toronto Canada
110 1 6 2012-07-06 2012-07-07 2012-07-06 UBS 20.0 John. Smith, Good Life 115 Keels Street Toronto Canada
111 9 3 2012-07-06 2012-07-06 2012-07-06 Fed Ex 5.0 Catherine, PNN 366 Hello Street Toronto Canada
112 8 6 2012-07-06 2012-07-06 2012-07-06 Purolator 5.0 Helene, CIBC Bank 103 King Street Toronto Canada
Create table customers
(
CustomerID int not null auto_increment,
ComapnyName varchar (40),
ContactName varchar (40),
Email varchar (40),
ContactTitle varchar (40),
Address varchar (100),
City varchar (20),
Country varchar (20),
Phone varchar (20),
/* Add more fields ok */
primary key (
CustomerID)
)
The Relationship: From ACME database schematic, we see that the customers table has: One-to-Many Relationship with table Orders.
Because: A customer can buy many orders. And each order can be bought by a customer. Logic right?

Set up Key Relationship: Insert the Primary Key CustomerID of the customers table in table Orders in order to link One-to-Many Relationship with table Orders. DONE! See table Order SQL Create Table blue code. CustomerID in table Orders is called a Foreign Key. 
NOTE: Use CustomerID as an number Integer is better because it is auto increment the number when adding new record of customer in table.

Create table customers in Net.Office Database:
Copy the left blue code Create Table for customers in Net.Office Database -> Code Area -> Then click button [Submit SQL Code]. DONE!

Data entry: next, enter data of customers. See the Customer data table... That is it.
Example, CustomerID =1, CompanyName = Good Life, ContactName = A. Smith, Email = asmith@yahoo.com

Expand table, add more columns: You can always add more columns or field in the customers table without any harm to table.
Example, add an extra column named: POSTAL CODE after ADDRESS field, you run this SQL code:

Alter table customers add PostalCode varchar (15) after Address
 

=>
- Data Sheet for table Customers
CustomerID CompanyName ContactName Photo Email ContactTitle Address City Country Phone
1 Good Life John. Smith johnsmith@yahoo.com Manager 115 Keele Street New York US 1-800-339-1300 x 324
2 IBM Peter King peterkg@ibm.com Director 445 Warden Street Toronto Canada 1-800-267-3290
3 X-Mart Hue Nguyen snguyen@hotmail.com Sales Staff 75 Else Street HK China 1-800-339-2290
4 NetInc Dave dave@yahoo.com - 514 Main Street Toronto Canada 1-800-242-3190
5 Dynamics, Inc H. Simpson hs@gmail.com Secretary 9005 King Street Toronto Canada 416-321-0790
6 Will Investment, Inc Paul Will pwill@hotmail.com Net.Office worker 210 Bay Street Toronto Canada 416-344-8390
7 TD Bank Bob. Byrd bb@yahoo.com Manager 1008 Sheppard Street L.A US 1-800-221-0780
8 CIBC Bank Helene helene@yahoo.com - 103 King Street Toronto Canada 647-219-1290
9 PNN Catherine catherine@BMM.com - 366 Hello Street Toronto Canada 1-800-221-0780
10 TNM Erin erin@yahoo.com - 215 Nice Street LA US 213-190-1290
Create table employees
(
EmployeeID int not null auto_increment,
LastName varchar (40),
FirstName varchar (40),
Photo varchar (20),
Title varchar (40),
Email varchar (40),
HireDate date,
Address varchar (100),
City varchar (20),
Country varchar (20),
Extension varchar (25),
Notes text,
ReporsTo varchar (20),
/* Add more fields later ok */
primary key (EmployeeID)
)
The Relationship: From ACME database schematic, we see that the employees table has: One-to-Many Relationship with table Orders.
Because: An employee sells many orders. Each order can be sold by an employee.

Sent up Key Relation: Insert the Primary Key EmployeeID of employee table in table Orders in order to link One-to-Many Relationship with table Orders. Done.  See table Order SQL Create Table code. EmployeeID in table Orders is called a Foreign Key.

Create table Employee in Net.Office Database:

1) Copy the above blue code Create Table for employees in Net.Office Database -> Code Area -> Then click button [Submit SQL Code]. DONE!

2) Data entry: next, enter data of employees, like LASTNAME, FIRSTNAME, upload PHOTO... That is it.

Expand table, add more columns: You can always add more columns or field in employees table without any harm to table.
Example, add an extra column named: POSTAL CODE after ADDRESS field, you run this SQL code:

Alter table employees add PostalCode varchar (15) after Address

=> Data Entry spread sheet for table Employees
-
NOTE: HOMEPHONE
column = Home phone number of employees just added even after Employees database already built & had data in it.
=> You will not see HOMEPHONE in this datasheet. => The reason we do this because we wanted to tell you that you can always add extra columns (or delete, change name, size, type of column) like HOMEPHONE later in database if necessary, even after database employees already designed and had data in it.
- To ADD HOMEPHONE in Employees database, run this code: Alter table employees add Homephone varchar (20) after Email. = Create new column HOMEPHONE after column Email.
- Or you can use GUI of Net.Office Database to add Homephone. No need to write SQL code.
EmployeeID LastName FirstName Photo Title Email HireDate Address City Country Extension Notes
1 Rezvani Selen Sales & marketing selen@myoffice.com 2000-06-25 123 King Street Toronto Canada 1-800-218-1900 x 1231 Very active
2 Ng Tina Sales & marketing tina@myoffice.com 2000-06-20 1249 Kent Street Vancouver Hong Kong 1-800-218-1900 x 1242 nice
3 Lauer Dirk Sales & marketing Dirk@myoffice.com 2000-06-25 1235 East Street Toronto Canada 1-800-218-1900 x 1277 Nice guy
4 Virender  Vaira Sales & Marketing Vaira@myoffice.com 2010-09-20 15 Mumbai Street Mumbai India 1-800-218-1900 x 1201 Very active
5 Da David
 
Computer Scientist, Software Engineer.

- Tech Evangelist, who not only built technology but also promoted technology and innovation for making a difference, for educating awareness.

 
david@myoffice.com


 
2000-06-25 253 Finch  Street Toronto Canada 1-800-218-1900 x 1278 - Write almost the coding and the architect of Net.Office software product.

- Work late at nights to meet deadline. Spent 90% of time for coding. Product Development, R&D is my job. No time left to do other stuff. But no choice.

- Advocate for productive Cloud Smartweb. A website that can do: Sell, Provide services, Collaboration, Database, Marketing...
A day website doing nothing will cost business a lot of time and money.

- We are looking for investors.. A lot of work to be done.
We want to maximize ROI for them as much as possible. Open to all kinds of possibilities, collaborations, and opportunities. Just came back trip from Far East in 2012.

- A small piece of a big pie is better than a large piece of a small pie - VC

"- Try not to become a person of success but rather to become a person of value" - Albert Einstein

- Good products got started humble in the beginning.
- Open to speaking, conferences, consulting, training, meeting at your business. My topics: E-Commerce, Business Database Information System, EDBMS, Cloud Computing, Business Email Marketing eCampaign, Social Collaboration Network, The Relationship between Business and Technology.
Email: ddanpros@hotmail.com
- Cloud will be the next big thing.
6 Ng Palyn Software Engineer Palyn@myoffice.com 2008-06-28 244 Sma Street Toronto Canada 1-800-218-1900 x 1244 nice
7 Stedhay Chad Sales & marketing chad@myoffice.com 2008-06-28 244 Bay   Street London England 1-800-218-1900 x 1237 nice guy
8 Lan Tina Sales & Marketing tina@myoffice.com 2008-09-18 244 East    Street Toronto Canada 1-800-218-1900 x 1221 always smile
9 Smith Erin Sales & Marketing erin@myoffice.com 2001-04-22 244 Main Street New York US 1-800-218-1900 x 1228 x
10 Holden John CEO john@myoffice.com 2000-01-12 244 King Street Toronto Canada 1-800-218-1900 x 1236 x
11 Terrin Dan Sales and Marketing dan@mynetoffice.com  2008-11-25 36 John Street Toronto Canada 1-800-218-1900 x 1232 x
12 Jan Helen Software Engineer helen@myoffice.com 2003-06-28 189  Hello    Street Toronto Canada 1-800-218-1900 x 1444  nice


Use Net.Office Database to create database Employees. Then upload employee's photos. It would be nice if we can see employee's photos in database. Enhance the look and feel. Right?

Database stored data and information. A picture is worth a thousand words will help enhance database a thousand words.

To create database table for employees: Copy the above blue code Create Table for employees in Net.Office Database -> Code Area -> Then click button [Submit SQL Code]. DONE!
Next, enter data of employees, like LASTNAME, FIRSTNAME, upload PHOTO...After created table, and enter data, to list all employees run this SQL code: Select * from employees

Net.Office Database Table Employees

  
Picture: Display Net.Office Database Employee Table -> Listing table EMPLOYEES. See name and faces.

Click see How Net.Office Database
Save SQL Programs as Menus for re-use, re-run.
-  Your staff write a SQL program to do some database tasks, they save the SQL program to re-use later. Net.Office Database automatically creates the Menus. To run SQL Programs, Query, Database Tasks... Click on Menu Bar, such as: INVOICE MENU. Click on INVOICE MENU again to close. Each MENU can contain > 100 Menu Items to do tasks. Click on Menu Item to run SQL program, Query...

Oracle Employees table


Picture: Display Oracle Employees table.


Picture: MS SQL Server => Listing table EMPLOYEE. See names but can't see faces. Who is it? A picture is worth a thousand words. RIGHT.


Net.Office Database search and join multi tables: Orders, OrderDetails, Customers, Products, Suppliers, Employees... Why Net.Office Database is a Photo and Social Database? See explain below.

- This will JOIN all Order Dates - The code for picture.
SELECT od.orderdetail_id as OD_ID, orders.orderid, orders.orderdate as OD_DATE, cu.customerID, cu.ContactName as Name, cu.photo as member_photo, p.productid, p.productname as product, od.unitprice as price, od.quantity as QTY, od.unitprice * od.quantity as Total, p.picture, emp.employeeid, emp.photo as satff_photo, su.supplierid, su.logo FROM customers as cu
INNER JOIN orders
ON cu.customerid = orders.customerid
INNER JOIN employees as emp
ON emp.employeeid = orders.employeeid
INNER JOIN orderdetails as od
ON orders.orderid = od.orderid
LEFT JOIN products as p
ON od.productid = p.productid
INNER JOIN suppliers as su
ON p.supplierid = su.supplierid
ORDER BY OD_ID ASC
- This will JOIN all Order Dates in between date -
SELECT orders.orderid, orders.orderdate, cu.customerID, cu.ContactName as Customer_name, cu.photo as member_photo, p.productname as product, od.unitprice as price, od.quantity, od.unitprice * od.quantity as Total, p.picture, emp.employeeid, emp.photo as satff_photo, su.companyname as supplier, su.logo
FROM customers as cu
INNER JOIN orders
ON cu.customerid = orders.customerid
INNER JOIN employees as emp
ON emp.employeeid = orders.employeeid
INNER JOIN orderdetails as od
ON orders.orderid = od.orderid
LEFT JOIN products as p
ON od.productid = p.productid
INNER JOIN suppliers as su
ON p.supplierid = su.supplierid
WHERE orders.orderdate >= '2012-07-03' AND orders.orderdate <= '2012-07-05'
ORDER BY orderdate ASC
- This will JOIN all Orders in Today date -
SELECT orders.orderid, orders.orderdate, cu.customerID, cu.ContactName as Customer_name, cu.photo as member_photo, p.productname as product, od.unitprice as price, od.quantity, od.unitprice * od.quantity as Total, p.picture, emp.employeeid, emp.photo as satff_photo, su.companyname as supplier, su.logo
FROM customers as cu
INNER JOIN orders
ON cu.customerid = orders.customerid
INNER JOIN employees as emp
ON emp.employeeid = orders.employeeid
INNER JOIN orderdetails as od
ON orders.orderid = od.orderid
LEFT JOIN products as p
ON od.productid = p.productid
INNER JOIN suppliers as su
ON p.supplierid = su.supplierid
WHERE orders.orderdate = curdate()
ORDER BY orderdate ASC

- This SQL program will search into multi 6 tables: Orders, OrderDetails, Customers, Products, Suppliers, Employees. Then return all detail values of each order. Let you know:
- the Order ID and the Order Date. Calculate the Total Sales, Tax...
- Details of the customers, such as: Name, Photo, Email...
- Then also let you know the Employees who sold these orders with contact Email.
- Then let you know the Product Name, Price, Stock Inventory, Units On order, and the Product's Supplier Name for each order.

=> You can track all orders today, every week, every month or 5 years from now, you still know clearly about each order: Orders, Order details, Products, Shipping, Customer Contacts, Employees, Supplier Contacts, Payment...


Picture: Net.Office Database JOIN 7 tables let you know:
-
The Invoice Order, Invoice Date, Invoice Total, Details Contact of Customer bought that Invoice, the Shipping, the Product sold of that Invoice, including Price, Qty, the Detail Contact of  Employees who sold that Invoice, the Details Contact (Phone, Email, Manager ...) of Supply of that Product sold of that Invoice
.
- You also know :
- How many Invoice Order of that Customer, like John Smith,  bought ...
- You also know :
- How many Invoices (orders), Invoice ID ... that Employee, like Tina & her Photo, has sold.
- You also know : -
The detail contacts, like: Manager, Phone, Email, Address, of the Supplier, that supplied, sold that product..


=> Net.Office Database is a first generation of photo, social cloud database -
A picture adds a thousand words for database. Net.Office Database JOIN 6  tables, show > 100 Columns / row using ROID.

=> See Net.Office Database, MS SQL Server, Oracle to CREATE TABLE. Click here - Click see Net.Office Database Data Entry Form in table: Click here. - To Save SQL Program, click here.
=> Picture new improve UI interfaces. Can move ROID dialog (Relational Object ID) any where. Click and see: Old UI interfaces  (Click on picture to enlarge)

=>
Net.Office Database can JOIN 20 tables, > 300 columns /row. A table can have more than > 50 columns. A PC screen 1280x800 fits in 15 columns / row without using horizontal bar back & forth see cols.
=>
One record showed holistic view of work flow: Order Detail -> Order -> Customer -> Product -> Employee -> Supplier. See ROID benefits. Click here.
For example, row 6 or record OD 6 show: An holistic view of Order 104. All data of a record / row connected, related directly or indirectly in one work flow in one row. (Social Relationship)
=> Let's begin
with the Order Detail of Order 104. Click on ROID OD 6 = Order Detail ID 6 of Order 104  -> Customer of Order 104 =  CustomerID 1 = John Smith. Click on ROID 1 = CustomerID1 show detail data of John Smith -> Products of Order 104 is ProductID 2. -> Detail data of Employee Sales Rep of Order 104, ROID = EmployeeID 2 is Vanny.. -> Data of Supplier of Order 104 is SupplierID 3 = Kmart.
=> ROID helps query, process data faster, display large and big Data Set. Example, imagine, Product ID 2 of table Products has > 50 columns. One click, ROID shows > 50 cols, big data set of Product ID2.
=> Use MS SQL Server, ORACLE, can't see all work flow / row like row 6 or record 6. Use Net.Office Database, just need to open 6 ROID of 6 tables then you can see all large data set of > 100 columns.

To test and verify your SQL Program. How? Check database generated values by SQL program vs. Data in Excel sheet:
- Database is just like computer: 1s, 0s. Right or Wrong. In the beginning, your database should have 10 rows for easy to test. To verify values, you manually look in each table data on Excel and compare values with data generated from database. For example, look at database row 6, Order Detail ID =6 -> Order 104 -> ProductID 2 = Beef soup, Price = 6$, Qty =1. You compare these values in with values of table Order Detail in Excel data sheet. In Order Detail Excel, you see this row 6 = OrderID 104, ProductID = 2, Unit Price =6, Quantity =1. So they are ok with values from database. See Order Detail Excel datasheet. To verify ProductID2, Product Name= Beef soup, Unit Price =6, you need to check with Products Excel Datasheet. Click here. Do the same thing to verify for other values.

Track Order Invoice, Invoice Date, Invoice Total, Invoice Tax, Invoice Shipping Date, Shipping Fees, Customers, their Address, their Contacts Details using pointer ROID (=Relational Object ID)..
 
SELECT orders.orderid, orders.orderdate, sum(orderdetails.unitprice * orderdetails.quantity) as Invoice_Total, (orderdetails * orderdetails.quantity * 0.13) as Invoice_Tax, orders.shipdate, orders.shipviva, orders.freight, orders.shipaddress, customers.customerID, customers.ContactName as Name
FROM customers
INNER JOIN orders
ON customers.customerid = orders.customerid
INNER JOIN orderdetails
ON orders.orderid = orderdetails.orderid
WHERE orders.orderdate >= "2012-07-02"
GROUP BY orderid LIMIT 0,20




In plain English, the similarities and differences Net.Office Database, MS SQL Server, Oracle.

=> Not all companies are playing the same fair game in term of Budget, Investment, Manpower ( e.g: 1 vs. 100, 10 vs. 1000), Resources, R&D ...
Database market is like car market. There are hundred of different kinds of cars, hundred of different kinds of prices, and hundred of different car companies.
 
 

Picture: MS SQ SERVER JOIN 3 tables: Customers, Orders, OrderDetails. ProductID = 11, 42.. No ROID.
- What is it ProductID = 11, 42...OrderID 10248, 10249.. in MS SQL SERVER? We don't know. Confused?
- What is it ProductID = 6, OrderID 101 in Net.Office Database? We know. Click on Order 101, ProductID 6, EmployeeID 6 shows detail data of ProductID 6, EmployeeID 6. (See photo). That's ROID (Relational Object ID).
=> ROID helps database process data faster, contains, shows
* large and big Data Set *. More, Click here.

Picture: ORACLE: JOIN 2 tables: EMPLOYEES and DEPARTMENTS. DEPARTMENT_ID = No ROID. For example, let's say DEPARTMENTS table has > 50 columns, such as: Department_Address, Department_offices.. Use ROID, one click on DEPARTMENT_ID 80 = Sales Dept, will show all large and big data set of 50 columns of that Department ID=80.

NOTE: Traditional database's tables contain raw data. Traditional databases by design do not contain photos, files. Net.Office Database's tables contain photos, files like file cabinet by design.
- For example, Database Doctor's Patient, traditional databases stored only Patient's flat data, raw data: NAME, PHONE, ADDRESS. Net.Office Database table Doctor's Patients, stored not only Patient's raw data: NAME, PHONE, ADDRESS, like traditional databases, but also contained Patient's files like Photos, X-Ray, blood test, medical Files...A whole File Cabinet of Patient. Searching for patient John Smith, you got a whole cabinet of his information: Phone, Address, Medical Files, Medicine Subscription...Click to open his Photo X-ray, his medial files, Word doc, Excel files, PDF files, scan files...
 
=> In any Cloud Database Software System, SQL box is the brain and Table is the heart. Net.Office Database creates Table as big File Cabinet Table and deliver big File Cabinet in cloud using ROID.
=>
Net.Office Database JOIN or CONNECT and FIT 20 tables / screen, access more than 300 columns / row / screen. In the picture, it JOIN 7 tables.
=> See Net.Office Database JOIN tables (above), MS SQl Server, Oracle JOIN tables. See MS SQL Server, Oracle, Net.Office Database Create Table. Click here.


=> Explain Net.Office Database JOIN photo above
From Net.Office Database 's ROID (Enterprise Object IDs), for example  EMPLOYEE1, PRODUCTID1... in above picture, you can do:
- Access
all table's data of this Employee1, Productid1. Update data of Employee1, Productid1 any time needed to update. No need to switch screen to open Products table and Edit/Update. Net.Office Database automatically lookup values in table Relationship, and create an option list for ROID to select. This Relationship is enforcing using Net.Office Database Relation Manager Tool. Click see.
For example, get value of SUPPLIERID =5 for table Products from listing values of table Suppliers that had 1-to-Many relationship with Products (Picture). This helps Data Entry fast and easy.
- Insert
data in any table, Employees, Products any time if needed. No need to switch screen to open Products table and Insert. Thus lost this current JOIN screen. Back and forth between screens.
- Browse or Explore
all data in table Employees, Products..., any tables in current screen.
- See, List, and Track
Reverse Relationship of the right Relationship table Orders. For example, we list all Orders, and Customers of this Employee1 Rezvani.
- Email
Employee1. Collaborate with Employee1. Chat Employee1 (N/A)... More in ACTION.
- Look at row 14, from the above JOIN picture, the EmployeeID =1 Selen Rezvani sold Order 109 because Employees tablet is linked directly with Orders table. (See Relationships Diagram ). And the Product ID=6 of Order 109  sold = Blue Sky Berry Ice Cubes because Products table is linked in-direct to Employee table through OrderDetails table that linked direct with Orders table. And we also know Selen Rezvani's CustomerID = 7, name= Bob. Byrd, so on.... And so forth for other data.. See more explain in detail of row 14. Click here.

NOTE: ** Email from Net.Office Database, icon , , is tracked emails if people open emails and click and when (time) on Url link. This ensures important email like Invoice Payment if opened and clicked by clients. This is an option. For example, you send John Smith email embedding the Url link to Invoice Payment. You can track if John Smith opened email and clicked on Url link to invoice payment.

- Net.Office Database treats Relational Object ID (ROID) important because it is the key to open and access a whole cabinet table. ROID increases huge Speed and huge Space (data storage) of database. Table in Net.Office Database is a File Cabinet that can stored Photos, Files, Docs, Pdf, Excel, Videos.... It is not just stored flat data (FIRSTNAME, EMAIL, ADDRESS...) table used to be.
- Net.Office Database Relational Object ID (ROID) helped delivery heavy big File Cabinet Table in the cloud easily. Why?
Click more.

=> Why Photos? Photos add add a lot of value to databases + A photo, a picture adds a thousand words + More fun + Visual experience + Pleasant look and feel. Great user experience.  + Most data and information stored in database like Animals, People, Employees, Students, Members, Customers, Food, Photos, Real Estate, Products..  need photos. Using Net.Office Database, you just need to upload photos, pictures, files, doc, pdf, excel, videos... any file format.. from your harddrive, laptop, PC in database table.

- More than just PHOTO,
Net.Office Database not only stored flat data like EMAIL, FIRSTNAME, LASTNAME... but also table in Net.Office Database can store photos, pictures, files, excels, docs, pdf, videos...Which means that now you can create table as heavy File Cabinet and delivery heavy File Cabinet in the Cloud using Net.Office Database ROID.
- For example, create extra fields in table Products to store Product Photos, Product's PDF, Videos, Excel, Product scan Files...Table Product is a File Cabinet. One click to open, download, view file...
- For example, table Customers, create many extra fields, such as: CUSTOMER_CONTRACT, CUSTOMER_DOCS, CUSTOMER_EXCEL... The upload files from local PCs into table Customers. When searching for customer = John Smith, not only you see his raw data PHONE, EMAIL, ADDRESS, but also you see his Contract, and other business documents related to John Smith in seconds.
- For example, table OrderDetails, create an extra field or column name = DIGITAL_INVOICE. Then scan invoices, then upload the scan invoice file in the column DIGITAL_INVOICE of table OrderDetails. When searching for order =123, staff can view, retrieve order's digital invoice 123. Business can be easily share, collaborate, search, retrieve file scan digital invoices any time, any where.
- For example, table Employees stored flat data, raw data like FIRSTNAME, LASTNAME... You can create field or column to store files, such as: PHOTOS, RESUME ... Then upload photos in field PHOTO, and resume files in field RESUME. When search for Employee =  Selen, not only you see her flat, raw data like FIRSTNAME = Selen, LASTNAME = Rezvani, but also you can see her photos, resumes...
- For example, table Doctor's Patients, stored not only Patient flat data like, NAME, PHONE, ADDRESS, but also contained Patient's files like Photos, X-Ray, blood test, medical Files...A whole File Cabinet of Patient. Delivery File Cabinet Table in Cloud. When searching for patient John Smith, you got a whole cabinet of his information: Phone, Address, Medical Files, Medicine Subscription...
- In general,
Cloud Net.Office Database to Create table into big File Cabinet Table, not only stored flat raw data, like most traditional tables, but also stored photos, meta files, any files, scan documents... Can't do this with databases before. Net.Office Database's Table is called big File Cabinet Table. 
- In any database system,
Table is the heart, and SQL Box is the brain. They are most important and powerful components of database.

- Net.Office Database Relational Object ID (ROID) helped delivery Net.Office Database big File Cabinet Table in the cloud easily.

=> Why Social? means Social Relationship.
- In response to growing social media, social world, Social Database not only store, process, and display data like traditional databases, but also database provide social relationship (= database have relationship), social commerce (= database can sell, promote, marketing), social presence (= database be social, connect, collaborate).
- For example, when searching, query database for John Smith, or segment of group of people, staff, customers, you are able to promote, coupon, sell products and services to John Smith, or to a group of people in database. Let them fill register form, donation form, feedback ..You email, chat, appointment, connect social media, and collaborate with people in database. You can't do these things with databases before. There are 2 kinds of Social Relationships: 1) Social Relationship Social Media Model in social world. And 2) The Social Relationship at work in a Social Relationship Work Model.

1) Social Relationship in social world, social media or Social Relationship Social Media, Social World Model: Maintain, manage the social relationship with people in database across multi social channels, like LinkedIn, Facebook, Twitters.. where ever they are. For example:

- When you search database, and see an employee, a customer, Net.Office Database lets you Chat with co-staff, warehouse about Stock Inventory, Shipping, or Chat with Sales Execs about Order 123, or Chat with Managers about Suppliers.. anywhere, every where. Or Send email, Post message.

- You can be Following and Follower of People in database. When you post message or they pos message, message Collaboration. Nurture the relationship. Socialize, Connect, Follow in social media.

- Net.Office Database lets you made appointment with group people, Staff or Customers in database. Setup auto reminder customer John Smith, or group of customers next appointment.

- When you search in database for a group of customers, who had not ordered in the last 6 months, Net.Office Database lets you use myNet.Office Email Marketing eCampaigner to launch an eCampaign, to invite them back to store or give them coupon, promotion...Or remind them back for customer services.

- When you do complex or simple search database for a group of customers satisfied these conditions: Who bought Products and Services A, from Jan/2011 to Jan/2012, AND their Sub-Totals of all their invoices must >= 100$ -> Now the company wants to sell or promote, inform, upgrade them to new Products and Services A+plus (up selling) -> Or the company wants to promote, refer them, sell them the Accessories, the related Products and Services of Products and Services A (cross selling). Net.Office Database lets you create a CTA (Call to Action) Form using myNet.Office Smart Form. Then send this form using myNet.Office Email Marketing eCampaigner. Let them fill a registration for an event, or buy ticket, or buy company's products and services, or send donation, quick selling, up/cross selling.

- When you search database to find John Smith data, like {Name, Email, Address...} not enough, Net.Office Database lets you link your customer's John Smith's social life, his social data in LinkedIn, Facebook...It means you understand more your customer John Smith 360 degree. One click, send John Smith an email, Call to Action form for John Smith to buy your products and services. One click, send John Smith an Invoice Payment. One click, have John Smith register for an event. Or one click, give John Smith a coupon, a promotion...

- Net.Office Database is working with myNet.Office Cloud Commerce to support e-commerce. Data from e-commerce website is collected and stored properly in Enterprise Database Management System (EDBMS) so that business can use SQL, process and analyze data. A lot of Web Developers don't even know EDBMS. => Many e-commerce website don't have Customers tables, Order table, Order Detail tables, Product, Supply table... If you ask business e-commerce:" - Do you know where are these tables in your e-commerce websites? " They don't know.

2) Another Social Relationship is the Social Relationship Work Model - The most important Social Relationship. Social Relationship also means the Social Relationship Work Model at work, which is the Relationship of Employees, Customers, Orders, Order Details, Payments, Products, Shipping, Suppliers, ... happened every day in any size business, in organization.

=> The Philosophy of Social Relationship Work Model is that, in the business, in the organization, every object, all connected and related either directly or indirectly each other. And we can get data of objects that are direct or in-direct connected
(or having Relationship) from other objects.

For example,
If you look at the row OrderDetails ID =14 in the JOIN photo above. The employee: Selen Rezvani with EmployeeID =1 in Employees table is linked direct to Orders Object (See this Relationships Diagram ). So we know that Selen Rezvani is the Sales Exec who sold this Order 109. How can we know What Products Selen Rezvani is selling? It is ProductID 6 = Blue Sky Berry Ice Cubes because the Products Object is linked direct to Order Details Object (See diagram). And OrderDetails Object is linked direct to Orders Object. Therefore, Products Object is linked in-direct with Employees Object from OrderDetails Object (see Diagram). Therefore, we know Selen Rezvani sold the Order 109, and the selling products ID =6 = Blue Sky Berry Ice Cubes, and Customer ID =7, Name= Bob. Byrd, so on....

- When the company, the organization couldn't know, or take a long time to find who is the Employee that was responsible for this Order, problem with Shipping, problem Stock Inventory, problem with Supplier, problem with Products, problem with Orders.. then it is very big problem for company's resource, productivity, back and forth, and big waste of time and money. The company, the organization must re-organize, design, and implement Social Relationship Work Model in their business.   

=>
See MS SQl Server, Oracle JOIN tables Click hereSee MS SQL Server, Oracle, Net.Office Database Create Table. Click here.

=> A lot of businesses with multi locations, multi stores have orders coming every minutes, every hours. But the Managers sitting some where in the Net.Office, in hotel, at home, still don't know it there are the orders coming, can't track the orders. Then this is big problem. Why order is important? Because every order is every rice, every bread, the life blood to feed a whole company. If you don't know about orders then what do you know about business?

=> Businesses don't have the system
that can store data, analyze data, process data, and track every seconds for every Order from: { Order table, its Order detail table, its Customer table, its Product table, its Stock Inventory table, its Shipping table, its Driver table, its Employee table, its Supplier table, its Location table, its Payment table...} Only 11 tables. Not much. Net.Office Database can JOIN 20 tables in one row. Using Net.Office Database, one click, not only you knows what is going for an OrderID 123 after the order was done in 5s, but also 5 years later, you still know what was going for an OrderID 123. => This is micro-Management. Is about the Managers who understand every step in order to provide advices and helps for their employees. Would the company wanted to hire Managers who know nothing? Absolutely, not. => myNet.Office -> Net.Office Database helped the Managers, just a mouse click, see through every step of the order, from the time the order arrived, to the time the order out of the warehouse.

=> The average Managers just know there is an order. They know order is just an order, not thing special. Some don't even know if just had an order.
Even worse, they only know the total Order's Sales from the report in end of the month. The average Managers don't think, analyze, and innovate. The average Managers repeat tasks, back and forth:"- Check the Accounting staff. Check the Warehouse, Shipping staff. Check Product staff. Check the Sales staff. Check the HR staff..."

=> On the other hand, the talent Managers know order more than just an order. They analyze and know every step of the order. They see something that the average Managers couldn't see. They answer many questions about orders, such as:

- W
ho is Order's Customer and their Contacts, company, their potential. Just one click (not hours), the talent Managers know  their Customer's order history, how may times, how much, when last time customer ordered.... The talent Managers know more about Order's Payment, Order's Sales Employee, Contact, Background, Performance, How many orders they are responsible? Who are their Customers.. Order's Shipping: Date and time, where, when.., Order's Driver, Order's Total, Order's Tax, Order's Location, Order's Products and its sizes, colors. Order's Stock Inventory, Order's Status: Lost, Pending. Order's Unit Cost, Order's Unit Price, Order's Quantity, Order's Supplier, Lost Orders...
=>
They even predict the future of Orders. How? By analyzing Order's Customers, Order's Products, Order Details... so on.. 
=> There are a lot of features in Net.Office Database let the Managers predict the future of Orders, hot Orders, hot Product Items, hot Customers, forecast Revenues based on all the fact data, true data, true numbers, real business generated data, big data, good data, trusted data from table Products, table Customers, table Orders, Order Details...
=> The talent Manages even know the performance of their Employees, their Offices, their Locations, their Stores: Employee's Total Sales, Total Orders, who are their Customers. Where are the best generated business products, locations, offices, stores?...





Picture: Net.Office Database JOIN 7 tables let you know the Invoice Order, Invoice Date, Invoice Total, Details Contact of Customer bought that Invoice, Product sold of that Invoice, including Price, Qty, the Detail Contact of  Employees who sold that Invoice, the Details Contact (Phone, Email, Manager ...) of Supply of that Product sold of that Invoice.

=> Net.Office Database Join 7 tables and Use ROID (Relational Object ID) give users so much data sets that have relationship.
=> Thus a whole holistic View, a whole Data Analytic View ... in one screen.



Case study - myNet.Office, Net.Office Database share and collaborate for all local, global offices and departments
 
=> We show example of 2 different views of the average Managers and talent Managers of hi-tech company.
=> This company has diverse engineers, diverse managers.

The average Managers see order is
just an order. After working 15 years, the Management asked:"- What do you see about Orders, Invoices? Can you do something about that? "
=> The average Manager answered: "- I don't see anything. I have been working for 15 years. I have seen thousands of Orders, Invoices. I see orders, invoices every day. No thing special. We don't need it. "
 
myNet.Office,
Cloud Net.Office Database
share and collaborate
for all
local and global Offices and
Departments
- myNet.Net.Office, Net.Office Database - All-in-one Net.Office solutions for Company local, global Offices and Departments.
- We have the database design schema for you. See Database Management Information System: DBMIS Case Study.  

NOTE: A lot Database Experts, Data Scientists are talking about designing Enterprise Database Management System (EDBMS), 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 chaos, inconsistency, lack of integrity, messy Enterprise Database Management Information System Waste a lot of time to fix & maintain. Good DBMS Design will One-Click-Get-Data.

- Larger Enterprise Databases used schema, such as: Oracle, MS SQL Server, IBM DB2, SAP, Sybase... Big Businesses, big Banks, big Organizations, big Financial Institutions, big Manufactures used Schema Databases and SQL Programming Language to run their billions of dollars businesses. Schema database and SQL have been on the market for more than 30 years. One good feature of schema databases is JOIN, only schema databases, because JOIN tables based on schema to tie large data sets from multi tables. No JOIN, efforts to join, to tie together multiple sources of data, large data sets together can be hard, time-consuming and incomplete. JOIN allows us to see data, objects in multi-dimensions, holistic view. 
- Huge demand for Relational Schema Database Market (also called: Schema Database, SQL Database, Table based Database), Oracle is leading with 37 Billion revenue in 2012, then Microsoft SQL Server 27 B, then IBM DB2, SAP... However, new simple, affordable, easy of use Cloud Databases started step by step slowly taking away market share of databases
.

-
A lot of Developers see Design Schema is hard to design, strict integrity, hard to learn. See Schema in DBMIS Case Study.
For example, one of our developers is teaching at College. In a test, he gave CS college students Invoice, asked: - Build database Invoice -> Design schema -> Create Tables -> Collect data. 70% students or 2/3 of class, couldn't design schema.
Only 30% could design schema.

- The Managers, who understand schema, are able to understand the data, collect data, and analyze data of the project, the job they are doing. For example, you see Invoice every day. But can you see the schema of the Invoice? If you can't see the schema of the Invoice -> Can't see
data hidden in Invoice -> Then you can't build database or help Data Scientists, Developers build EDBMS for Invoice -> That means you can't collect data for the Invoice -> It is the job of Scientists, Engineers, Developers to explain, educate, and provide different views to the Managers how to organize and manage the data at work.

To design DBMS, let's make it simple:
1) Design Schema + Create Relationship. Can always change schema, expand DB bigger. Add more tables, more columns, more relationships later even schema already created. Schema is not easy to understand and design. That's why we provide a lot of schemas to help, modify and use. See DBMS Case Study. After created tables, use this tool to create Relationship:
Net.Office Database Table Relationship Manager Tool.
2) Create Tables. Only Net.Office Database can do 1 click, Create Table.
- Other databases are so complex to Create Table. Required: API, Visual Studio, Compiler, SDK (Software Development Kit), Coding, Software Engineers, Developers with degree in Computer Science.
- You can also Create Tables and Populate data from spreadsheet Excel to Database Tables without writing SQL code.
3) Input data, fetch data, load data.
4) Write SQL Programs in SQL box, and INSTALL (Insert) programs in Net.Office Database for re-use. SQL is used to process, query, analyze, get, join data. SQL is the easiest database language, grade 12 required. Other database languages required CS Developer background.
Think SQL programs like Apps for databases.  Developers from anywhere can write SQL programs for company if see schema.
5) Maintain, Administration. All maintenance like backup, antivirus, hardware, server, network... take care by Cloud Data Center. No need to worry maintenance. No worry about: File Read/Write, Mapping/ Reducing, Clusters, Machines, Nodes, Disks, Servers, Hardware, Backup, Virus, Networks, Provision, Licences, Administration, DBA, Developers... Which is complex IT Infrastructure - The most headache.
- Complex IT Infrastructure.

NOTE: To know more The Database Architect, Design, and Normalization - Please read this Click here.

- What is EDBMS ?
Is Enterprise Database Management Information System. EDBMS is used to manage data and information. It could be Relational Database (RDBMS), or Non-Relational Database, or Structure Data or Un-Structure Data...

The name, the hype are not important
. How to make use the technology, the data to solve your problems is more important.
If you are good, you can use any tool to build anything, to solve any problems. There are many solutions to the problems. Choose the simplest solutions for the problems. The complexity solutions give the result of complexity project and complexity system.

We don't like to discus about what tool, what technology should be used, all depends on your needs.

=> The Management then called other Managers explained: "- In any sizes of businesses and organizations have Orders. And Order object is one of many common business objects: Orders, Invoices, Order Details, Payments, Customers, Supports, Employees, Projects, Products, Support, Return Products (RMA), Inventory, Locations or Offices, Prices, Contacts, Leads, Opportunities, Activities, Accounts, Sales & Revenues, Purchases, Suppliers, even Drivers... These objects create a Social Relationship Work Model. We need to organize, collect data for these objects. Even the in house Drivers who delivery. We can collect a lot data about them.
For example, we collect driver's data, such as, the Driver Name, Driver Car, Driver Contacts, Delivery Time, Delivery Trips, Delivery Cost, Streets, Locations, Company, Delivery Tips...so that we know on that date, who is the driver to delivery that order, and the location, the company, the delivery items..? How much delivery tips? How many delivery Trips / day? The cost / trip? The profit / trip? In the end of the month, we also know who, the best driver, collected the most tips, drove the most trips, total delivery cost, total profit, total tips, total trips of whole delivery operation..
As you see, data collected, even less important object like Drivers, helped us understand the
Analytics of Drivers a lot. Other very important data objects like Invoices, Orders, Products, OrderDetails, Customers...are strategic and crucial for our business.
" They then analyzed data, built Relationship, built EDBMS. So on..."

=> The average Managers said:"- Ah. Sorry. We never think about this because we don't understand, we don't care. Why don't you communicate me about this? Now I see. But to organize data, build database, we need MS SQL Server, or Oracle. Need DBA, build Database Network Infrastructure, Hardware Servers for multi locations, offices. Only big companies can't afford that. All is about cost. We can't afford a lot of money for high-end database Developers, Consultants, database Services, Server, Hardware, Software, Licences, Training. Huge cost."

=> The other Managers said:"- Not your fault. This Enterprise Management Information System, new Technology, new Digital Information Management, has nothing to do with experience. However, we should always update our experience, learn new Technology, new Innovation that helped us work more efficient. Good Managers adapt to change ( = modernize experience) will bring experience to next level, more experienced. For example, we, as Developers, always update our experience, learn new stuff, new tool constantly, all the time. All we tried to say is we should always keep learning, up-to-date our experience because new technology and Innovation are changing so fast. We want to contribute to business. That's why we build the Technology. We communicate honestly and scientifically in good will. It is our job as Research Scientists. The Management said, they don't like to hear sugar coating things. Stand on your ground. Express your view honestly. People will happy even if your view is different from them."

=> The Management said: "- Take care of our business. Everyone is doing a good job. We just tried to communicate for improvement, for our own benefits. No one cares about our business except us. We are happy to see every one busy, and works hard every day. But if we use Technology, we will be thousand times more productive than we are now. Because Technology helps us do things thousand times faster. In the Net.Office, we should leverage, maximize the electronic system, and push it to the limit. Thus, staff will be less stress, and have fun in the Net.Office.
- We love MS SQL SERVER, ORACLE...But we can't afford it.
Choosing database is like driving a car. We can't afford luxury cars, named brands, cost of hundred of thousands of dollars. And we  can't afford the cost of luxury database, 60K full-time Developers to operate and maintain, and the headache complexity of IT infrastructure. We can affordable HYUNDAI car, still gets us back and forth driving to work and be productive. It is not about the tool, the car, but about the people who use the tool, the drivers who drive the car. And when we are more productive, more sales, more revenues, hundred of millions like big businesses, then we will buy luxury cars, MS SQL SERVER, ORACLE for every one. OK.
=> Better than nothing. We should move to cloud database affordable. Businesses are moving in Cloud. Stored their data, files, Excel, Word, documents in Cloud. Banks stored hundreds of billions, stored data of hundreds of millions customers in Cloud. Let's use Cloud Net.Office Database, like website login and use database. We use it as public or private. We don't need:
- We don't need DBA, nor expensive high-end server Database Consultants, nor middle Salesmen VARs.
- We don't need to buy expensive hardware servers, setup Network, and expensive software licences, and Back Up, and Virus Protection.
- We don't need IT people and IT infrastructure complexity, headache because there is IT at Cloud Data Center take care 24/7 Hardware, Server, and Network. Thus we save a lot of money and headache for complexity and cost of maintenance and consulting services.
- We also use myNet.Office to create E-Commerce, Online Business website. Since we are in business of selling but website can't sell.
- We train all our staff to use Net.Office Database, myNet.Office."


=>
We need to improve for our own benefits. Our website can't sell. We don't have database system. We can't email marketing to customers to sell, promote products. We can't collaborate online. Our website is still static.
- We must create Facebook, Twitter, LinkedIn for social presence. We need to collect unstructured data in social media, people in Social Media talking about products and services, or at our website's consumer browsing habits.
A lot of data to collect. First, let's collect daily used most important business data. We need cloud Net.Office Database for all our Departments:

1) •The Manufacturing Department should receive a listing inventory shortfalls, inventory data, order list, best price list, suppliers...
=> Build Database Management Information System: - Product Problems and Issues Tracking Database Management System - Business Warehouse Inventory Management System.. So forth.

2) •The Accounting Department should be able to run a daily query listing any orders that shipped during the previous business day for billing purposes, daily, monthly Total Sales and Taxes. Use Net.Office Database to create digital invoices for orders. Net.Office Database looks up in table OrderDetails, one click, Invoice is automatically created whenever needed to send to customers for payment. All invoices paper should be scan and stored in table as digital copies for easy search. Net.Office Database also helps us do complete Data Analytics of Invoice. So on...
=> Build Database Management Information System: Business, Store Management Work Flow with Products, Orders, Customers Information System - Accounting, Invoices, Sales, Customers Inventory Retail Store ...

3) •The Shipping Department should be able to receive a list of orders that need to be shipped. One click, they have all data they need.
=> Build Database Management Information System: - Warehouse Distributors Management's Information System.

4) •E-Business Department: Build E-Commerce, Online Order System: Use myNet.Office Cloud Commerce to create E-Commerce website. Data collected from our website stored in a proper EDBMS, same company's main EDBMS. So that we can process data fast and efficient. We can always add more tables, and create Relationships, and expand our database. Right now, our company's e-commerce, online business website doesn't have EDBMS. Data are stored every where. Our e-commerce website doesn't have tables like, Order Details, Customers, Orders, Invoices, Payments, Products, Purchase, Suppliers, Shipping, Employees... It is un-organized website, like a toy. We can always add more data columns to the table if needed.
=> Build Database Management Information System: Database Management Information System for E-Commerce.

5) •In House Order, Order by Phone must use the same company's main database EDBMS. Use many different databases caused headache and data every where, not centric and synchronized. When there is an order, like Order By Phone, just enter data in table: Orders, Order Details - The same Data Entry tasks if we use other software. That's it. We can track: Shipping, Delivery, Drivers, Total Sales, Taxes, Stock Inventory, Price List, Order History, Driver Delivery.. Net.Office Database has feature, one mouse click, Invoice is generated automatically from table OrderDetails. We can send electronic invoice, invoice payment to customers anytime. We also need to create an in-house Drivers table to collect data of delivery Drivers. Database will take care the rest.
- How to send an electronic Invoice to John Smith? Open table Customers -> Click on icon = (in ACTION) will pop up an UI Dialog listing all John Smith's Orders in table Orders -> Select an order id, example: Order 129. Net.Office Database will look up data from different tables, re-construct data for Invoice 129 -> Net.Office Database will automatically send a tracking email Invoice 129 to John Smith -> John Smith opens email, click on Url link to pay for this invoice. So quick, easy, 1 minutes. Net.Office Database tracks if John Smith opened email or not.

6) •Invoice Generator: Invoice tells a lot good data, good metrics of business. Net.Office Database can generate invoice when you need because it stored Invoice's data in table OrderDetails. Click here see table OrderDetails.

Let's analyze Invoice
, the most common object we see every day. Net.Office Database can help your business do data analytics, see clearly fact numbers, good business metrics in 1 minute. Once-Click-Get-Data.
How long does it take you to do these Invoice Data Analytics, get data, do tasks?
=> If your tool took a day to do these tasks then it is not powerful. Use Net.Office Database take less than 1 minute.

=> You can do the same Data Analytics like this for
EDBMS Case Study. => But of course, ask different questions.
=> The solutions for these tasks already built-in Net.Office Database. Here are the questions:
1
) - What are Products & Services sold the most, the least, hot sellers, worst sellers, seasons sellers?
-
Give you data about hot, worst seller Products, Pricing, Inventory... For example, know the hot seller products, least sellers, season sellers, you can order more or less, in Winter or Summer, good for warehouse space, stock Inventory, Pricing your products..
2) - Who are best Suppliers and their Contact info give the best Price of products?
- For example, How long did take your Purchase Managers to order and to get the best Price for 50 products, in 1000 Products inventory, from 100 Suppliers that have different Prices for the Products? => Database can search, query hundreds of Suppliers, their Contacts get best Price of 50 Products in 10s. Save Purchase Managers hours. => Excel Price List is not helping because Excel is not database. Why? Click.
3) - What are the most returned products? Who are the customers returned most products? WHY?
=> Give you data about Customer Care Management. Why did they return products?
4) - Listing all Products Inventory, short fall, Units On Orders, Unit in Stocks...
- Give you data about Inventory Management...
5) - Listing different Prices of Suppliers for each Product so that we can choose best Price of Supplier for each Product.
=> Give you data about Price Management, Purchase Management... So on... Can't list more..
6) - How much Total Sales, Total Taxes collected in period? Who are the Suppliers to supply that Product, their Contacts, Listing Prices?
7) - Who are top 10 customers, VIPs, repeat Customers, their Contact..? What they buy? How much VIPs, customers used to spend?
8) - List Invoices Daily, monthly, yearly Sub Total, Total Sales, Total Taxes? Who are customers still not pay for invoices, their balances?
9) - What are the pending, return, cancel Invoices.. and WHY?
10) - Listing who are new Customers we get daily, monthly, yearly?
11) - Who are the Sales Employees sold the most invoices, the least.. And who their customers? Get listing of invoices / Employee?
12) - Get the list of Customers in details (Customer History) their Contacts, Profiles, Company, Total Purchase, Invoices from the most to least?
13) - Get the Listing of the top 10 Customers, including their Profiles, Contact Managers, their Total Revenues, their Total Purchase, And Products they bought from our company.
14) - Get the List of Customers who bought > 500$, and Launch eCampaign give them 5% coupon, promotion based on their Total Orders.
15) - Get the list of Customers who not buy, not come back for more orders in 6 months, in a year? Who are our Sales Execs responsible for these Customers on Invoice? Why their customers not come back? Can we do something to bring these customers back?
=> Give you data about Customer Management.
16) - Listing and Group By all customer's Orders, Total Sales, Taxes... sort order in ASC & DESC from big to small Orders, from small to big
17) - Use different JOINs to detect fake invoices, lost invoices, fraud invoices, fake customers, fake billing, fake orders, fake products on invoices.
Only database can search through thousands of orders, products, customers, invoices, then join & match. Human can't do this.
18) - Listing all How much profit / invoice? Listing cost / invoice for all invoices? 
19) - List top 10 most profit invoices? List all invoices not making money if any?
20) - How many invoices, orders of each Sales Employee sold per day, per month, per year?
21)
- Based on Invoice data, Listing Who are our best Sales Employees of the Week, Month ? See their Photos, Resumes, Managers...
22)
- Based on Invoice data, Listing Who are our need improved Sales Employees of the Week, Month? See their Photos, their info..
23) - List simple things like Total Sales, Total Net Profits, Total Revenues per month, per period, per year, or from period to period.
24) - Get the Listing of the Departments, the Divisions, the Regions that generate the most revenues, the most profits.
Sort them in ASC, DESC to get the most, the least, the top 10, top 20...
25) - Get the Listing of the Managers of the Departments, the Divisions, the Regions that generate the most revenues, the most profits. Sort them in ASC, DESC to get the most, the least.
26) - Where the locations, stores sold the most, the least revenue by looking up invoices.. And Total Revenue of each location, store? Sort them in ASC, DESC to get the most, the least.
27) - Get the list of Orders delivery today, tomorrow, next days, in between date.
28) - Get a Listing of customers who need services, have appointment tomorrow. Then one click send them email to remind the services.
29) - List who is the in-house Driver or the Shipping Company that shipped the Orders in between date or between period.

30)
Get the list of all Customers who bought Products A & Package A. Now we sell them Accessories AB related to Products A or Package AB related Package A ( Cross Selling / Up Selling). One-click, send CTA (Call-to-Action) Form to them to Order, Donation, Register...


=>For example, How long did you do this task, build this Application? Use Net.Office Database with: myNet.Net.Office Tools built-in like  myNet.Net.Office eCampaign + myNet.Office Smart Form + myNet.Office Cloud Commerce, you send CTA Form to 5000 customers collect money, in less than 1 hour. ** You can't do this tasks using other databases **
Use Case: A company used to sell Entertainment Tickets to 5000 customers using: Order by Phone, or Walk-in Location. The staff then back and forth customer service, ask customers: Credit Card, ID, Address, Phone.. then Process Credit Cars.. Then back-and-forth service with customers. Long waiting line, busy phone rings all days. On average, staff spent time per call or per walk-in customer was: 10 minutes/ call / service. Some times service took longer. Sometimes staff wasted a lot of time for people phone, asked info but not buy. Thus, Total Time staff spend for 5000 customers: - Total Time = 5000 custs x 10 min = 50000 min / 60 min = 834 hr / 160 hr (work hours / month) = 6 months.
=> So took staff
6 months very busy service & thousands noisy phone rings to serve 5000 customers.
Use myNet.Office, even staff take it easy in Net.Office, they still serve 5000 customers good. Why? Because customers did all the work: Orders, Pay Credit card, Fill form, Check-out.. by themselves. Took less than 1 minute to fill form because myNet.Net.Office Smart Form automatically populated form, their Address, Email, Phone... of the customer's data in database from reading their email key stored in database. So that customer didn't need to fill these info on the form. They just need to enter credit card info. Ticket receipts send to their email. DONE! Customers happy, because they don't want waste time, back-and-forth with staff on phone. Sometimes staff too busy other phone lines, no one picked up the phone, long waiting line, drive back-and-forth waste of gas & time...
- Order electronically, Customers got tickets in their email. Every thing is quite, automated, fast service, fast transaction. Money deposit in company's PayPal or Credit card account instantly. Email is tracked if opened or not. Customer updated their address, info right in Net.Office Database hosted in Cloud Data Center. Invoices, Customers data updated.
=> Use
myNet.Net.Office Tools, Net.Office Database, you can build A whole Business Database Application Net.Office Electronic Order System doing these tasks in less than 1 hour. Ask your staff do this task, then you know what we talk about.
NOTE: If your customers already accepted your emails in their Inbox not a spam. Then next time you send, email will be in their Inbox. Net.Office Database can track if email is opened or not, so that you call if their emails do not open.

31) - Get statistics the demographics of the customers. Such as: Ethnicity, Background, Community, Location, City, Town...What Group, Community, Ethnicity, Location, City... buy the most, the least our products? Politician love this question.
=>
Give you data about Segmentation, Targeted Groups... The list keeps going...

These are features of many high-end Business Intelligence, CRM software, high-end E-Commerce system.

***
RATHER JUST ONE CLICK GET ALL DATA, WE SPENT DAYS  GET THESE RESULTS ***
*** Regrettably, a lot businesses stored Invoice on paper in boxes never look. Or stored invoices on software that can't do Data Analytics like database. Can't collect and analyze data on paper. They don't collect Invoice data, or stored invoice in software that had no SQL box used to analyze data. Invoice is bread and butter, is the oxygen to feed the whole company. Invoice is a powerful metric to measure all kinds of business performance. From invoice's data, we can provide effective strategy. For example, from Invoice, we see Orders, Customers, Products, Inventory, Purchases, Employees, Suppliers, Payments...It is gold mine. Let's dig. Use Net.Office Database, just one click, we see all Data Listing in details. Net.Office Database had many SQL Programs to do all kinds of Data Analytics in its LIBRARY that you just copy and use them. One Click Get Data.
=> The average Managers asked (disbelieved) : "- A LOT OF QUESTION ????? - How can we see Data of Invoice stored in table Order Detail ??
- How can we create, generate Invoice from the diagram?
- How can we see far all Data Analytics of the Invoice, as a big picture, a big view, an holistic ecosystem involving many things, like: Orders, Employees, Suppliers, Products, Price, Payment, Customers ...??? "


=> And the average Managers continued (still disbelieved) : "- Looking at the schema diagram, we don't understand. We see nothing ??? How can we see: Invoice Management, Stock Inventory Management, Shipping Management, Order Management, Accounting Management, Product Management, Pricing Management, Purchase Management, Customer Relationship Management, Sales Management, Employees / Resource Management, Scheduling Management, Service/Support Management, Supply/Chain Management, Manufacturing Management, even Driver Management... ???"

- Even experienced Managers CAN'T DO DOCAN ??? DOCAN = Design Data, Organize data, Collect data, Analyze data, Normalize data. See DOCAN at: EDBMS Case Study
=> The Management explained (smiling) :"- For example, because the Invoice is made up by table Order Detail. ( Click here see table OrderDetails) In table Order Details contains 2 primary keys: OrderID of table Orders and ProductID of table Products. (See Diagram) Because table Orders link or had the relationship with table Employees, and table Customers. And table Products link or had the relationship with table Suppliers. Therefore, Net.Office Database JOIN all these tables, give you see a whole holistic view, all data & information that are relating to Orders, Order Details, Customers, Employees, Products, Suppliers... explained above. If you add more tables, like table Drivers, table Payments, you then can see all kinds of things relating to the Drivers, Payments.. of Invoices. For example, we can see who is Driver to deliver that Invoice? What kind of Payment of that Invoice: Cash, Credit Card..?
NOTE: Net.Office Database can JOIN
20 tables using ROIDs, (even MS SQL Server, ORACLE can't do). Thus let you see a big complex view and deep seeing of gathering a lot of data and information / row / screen. Plus see a picture is worth a thousand words. One Click A Whole Holistic View.

=> The Management continued asking :"- What do you see our staff, employees? For example, John Smith?"
=> The average Managers answered :"- Invoice we don't see. But Employees we see a lot. From Employees Database, we see their Name, Title, Email, Resume, Contact..."
=> The Management laughed :"- What you see is narrow 1-dimension. We go to Social Media LinkedIn, we can see profile of John Smith as you see. But we want to see more about Employees. How more and solution?
=> The average Managers surprised :"- How can we see more about John Smith? We don't know. We don't need it."
=> The Management continued laughing :"- Your answer: We don't know. We don't need is the best answer used for all solutions = No solution. It is easy to see simple things but not easy to see this: Social Relationship Work Model. Let's make it easy. Here is how.

For example,
John Smith is our employee in Employees database. We want to see where his work, so we connect (link or create a Relationship) Employees Database to our Department Database. We want to see his Customers data, who are they. We also want to see how many his Orders, Invoices? How much sales revenues he generated?.. Thus we connect Employees database to Order database that is connected to Customers and Order Details database. We also want to see his Time Sheet, his Project. So we connect Employees database to Time Sheet database, and Employee Project database. We also want to see his Products & Services he is selling or responsible. Since Products database is connected to OrderDetails database. Thus indirectly, John Smith is connected to Products database, and Suppliers database as well. Which is powerful that Objects, like Products database, can be connected indirectly with Employees Object, from another OrderDetails Object. We also want to know customer's complains and comment about John Smith, so we connect Employees Object to Customer Support database of Customer Service Department's
Business Help Desk, Support, Problem History System, a Sub-EDBMS built within company EDBMS. And thus keep going...
As you see,
from we see only 1 dimension of John Smith by looking up the Employees database, now we see deeply in many different dimensions.

=> As a result, we see: his Contacts, his Customers, who are they in details, his Orders, his Invoices, his Total Sales, his Time Sheets, his Projects and Project Time table, his Department, his Group, his Managers, his Activities, his Contact List, his Leads, his Opportunities, his Accounts, his Suppliers, his responsible Products & Services, his top 10 Customers, their Contacts, his top 10 Orders, his top 10 hot seller Products sold.. What are bad Products returned under his responsibility. Who are the Suppliers of products. What are Customer's complains, comments about John Smith or about products sold by John Smith. We can even see who are his customers not come back in 6 months. How many orders, invoices he sold. How much profits he brought in for the company / period. And the list of seeing keeps going...

And we see his true numbers in detail listing. Not guessing, not judging, not she said, he said... This is truly collaborating. A multi dimension holistic view of data and information of employee John Smith. That's what we need to see. In total, We see John Smith from only 9 tables. Net.Office Database JOIN more than 20 tables using ROID (Relational Object ID) and more than 300 columns  / row let us even see more of John Smith. And just one click, we see complete holistic view of John Smith listing pop up in front our eyes."

=> The Management continued :"- If we were in your shoes, in your jobs, we can help you see more. But We depend on you to see. Because you don't see 360Ί, or see narrow small view, 1 dimension. See small things. Or see unscientifically. So we the Management don't see, or see narrow small view. Right now, at Head Net.Office, we do simple Enterprise Social Search (ESS) for John Smith, we don't see anything our Staff, our Members, our Employees. Or waste too much time, lucky see his simple profile. Don't even see employee Photos.. Simple but very important data objects like Employees, our people, Invoices, our food to feed company, we see every day, but you don't see it? How about very complex Data Objects? Tired. Meeting done. Back to Net.Office. Thank you.".

NOTE: This
Social Relationship Work Model Methodology of collecting and analyzing data and information can be applied for any Objects like Students, Colleges, Orders, Invoices, Products, Inventory, Production, Price, Suppliers, Customers, HR, Employees... This methodology can be applied in: Engineering, Financial, Forecasting, Policy, Campaign, Sales & Marketing...
- This SRWM Methodology is powerful because it can see through Objects that are indirect links to other Objects.
- For example, employee John Smith in Employees Object that is linked to Managers Object. And Managers Object is linked to Departments Object. As a result, we can see detail data of John Smith's Managers, and data and information of his Departments as well.
=> The Philosophy of Social Relationship Work Model is: In the business, in the organization, every object, all connected and related either directly or indirectly each other. And we can get data of objects that are direct or in-direct connected from other objects.


Picture row14 explains Social Relationship Work Model + the use of ROID.

=> This Data Collection, Data Analytics gave a whole detail History of the Object Order 109, in just one row, you see: detail Invoices of Order 109, detail Sales Rep of Order 109, detail of Product of Od109, detail of Supplier of Od109, detail of Customer of Order 109... This can apply to other Objects like Employee Object. It is very powerful tool for business to make decision, problems solving, data analyze...

=> Question? If your company doesn't have database. Store data in Excel spreadsheet like we had about: Order Details, Orders, Products, Employees, Customers... The Boss wants detail report of Order 109, 105, 110 .. of 6 months ago because they looked fraud, suspicious. He wanted to know: How much the Totals Sales, Total Tax, Quantity, Price, the Description of Products, Unit Cost (MSRP) of Products sold of these Orders ? Shipped Date? Shipping Cost? Ship By, Ship Address? Who are the customers in details, their Contacts? Who are the Sales Rep of this Order, Contacts, Photo, in detail? Who are the Suppliers of these orders? The Drivers?..
H
ow long could you JOIN 6 tables, get all data of Order 109, 105, 110...?
-
Answer: Manually looking through Excel sheets will take at least 5 hours or 18000 seconds. Database process, JOIN multi tables like row 14 in 10 second. If there are hundreds of records JOIN multi tables like row 14, will take you years or impossible for human to gather, analyze data from multi large data sets. But database JOIN data less than 1 minute.

7) •The HR Department should have cloud Resume database for sharing, collaborating, available for all Managers. Their interviews, comments, jobs status must be updated for all Manager to view. In resume table should have Url link the candidates to their social media like LinkedIn. Do not store resumes in email. The Management, the HR, the Managers should be able to search for Candidates by criteria, and view their resumes anytime, any where. HR should also do the same thing to create Employees database so that the Management can view, know their Employees better, their Photos, their Department, Managers, Job Descriptions, Resume files, Contacts, Projects...
=> Design Database Management Information System:  Employee Time Sheet System - Employee Tracking Schedule System - Employee Data Mart. See: Our EDBMS Case Study.

8) •The Customer Service Department should have table RMA, Product Returned by customers submitted at our website. We should scan all our product returned paper as digital copy, scan RMA Forms.. and upload and stored in table. It is easy to collaborate, search documents, files. Customer Service Department should also create online Member Collaboration for customers to login our website and collaborate...
- Build
MIS System like: - Business Help Desk, Support, Problem History Information System. So forth..

9) •The R&D and Engineering Department should have sub-EDBMS, all data for engineering analytics, RMA, tracking product's problems...Data stored on spreadsheets should be stored in database for analytics and processing, sharing, collaborating, reporting data.

10) •The Sales & Marketing Department should update those orders with a tracking number once they are shipped. Create tables like: Leads, Opportunities, Activities, Contact Lists.. They also use leads, contacts, customers data for marketing, for Up/ Cross sales, for CRM, for Email Marketing, eCampaign, for sales analytics.
=> Design Database Management Information System: Customers Sales and Leads Management System - Track Customer Order Software System - Customer Relationship Management System (CRM) for Sales and Marketing Department.

11) •Build extra Management Information Software System (EDBMS) for each Department. Such as:
- Employee Time Sheet System - Employee Tracking Schedule System - Customers Sales and Leads Management System - Track Customer Order Software System - Warehouse and Parts Distribution Systems - Business Document Management System - Customer Relationship Management System (CRM) - Manufacture's Product Problems and Issues Tracking Software System
-
Parts Order, Items & Inventory Control System - Project Management System - Consulting, Clients, Projects, Resources Software System - Agent, Customers, Leads, Activities Software System -
Micro Supply Chain Management System - Warehouse Inventory Management Data Model...
NOTE: Software is designed to solve few specific problems. Database is designed to solve thousands of different problems. We provided the blueprint, the schema, the design of these systems. EDBMS Case Study Examples. Click see also Order Relationships Diagram

=> Database like any Software, Spreadsheet, you need to feed data. Database doesn't know new customer Name = John Smith. The more we feed data, the better for our Enterprise Database Management Information System (EDBMS), and for our business. Each Department is responsible for their own Input, Data Entry in database. Data can also be imported from tens of thousands of rows of Excel, CSV file, Text delimited files into tables. That is it. Database will take care the rest. Net.Office Database will STORE, JOIN, SEARCH, QUERY, PROCESS, REPORT, LIST, ANALYZE data. Net.Office Database
Data Entry Form: Click here..
* If you don't know what we need, then we need to learn, hire more people."

=> The Management continued: "- Rather JUST ONE CLICK to get listing a whole data in details, it took hours, even days to get whole data, a listing of data, find documents, files. Business used many different software packages data not integrated, created many department silos, no collaborations. Customers info, data stored every where in many places. No data governance and not centralized. We don't have many order channels, such as: Online Order, In House Order By Phone. We rely on only Customer Walk-in Order. This stops us from expanding wider area, reach out more customers, different communities, around the world. There are so many business problems, chaos, effect a whole company. That's why big businesses, big organizations, spend, NOT few hundreds for business software packages, but tens of thousands, hundreds of thousands for MS SQL Server, Oracle Database because they had same business problems like we had."

Finally, the Management concluded the meeting, and wanted to see: " Every one is doing a good job.
1) We want to see our business increase more sales, more revenues, and reach out more customers more communities, and expand wider areas, and around the world.
We need grow. HOW? 1) Create, Intro new Products 2) Expand, Open new Market. 3) Create new Channels.
2) We want to see
Add-on ordering channels like: Online Order, Order By Phone, beside Offline Order.
3) We want to see a powerful
E-Commerce ecosystem reach out more customers, communities, around the world. E-business or No business.
4) We want to see good
Tracking Systems for Delivery, Warehouse, Inventory.
5) We want to see engineering
Products problems solved.
6) We want to see Invoices database, Customers, Contact List database, Products, Suppliers, Price List database,
data organized properly in EDBMS (Enterprise Database Management System) => No EDBMS, efforts to join, to tie together multiple sources of data, data sets together can be time-consuming and incomplete.
7) We want to see tracking email electronic Customer Invoices online payment. We wasted so much time for calls asking payment.
8) We want to see
Database Digital Marketing, Cross/Up selling, professional Product Catalog online marketing.
9) We want to see
Email Marketing to update our Products and Services, and Inform, remind customers important services and appointment.
10) We want to see more
eCampaigns to give our best customers coupon, promotion.
11) We want to see
a Cloud SaaS Portal Website. Please re-do the static website. Can't do online business with this static.
12) We want to see more
Online Collaboration with customers. Customers login at our corporate cloud software portal and collaborate with us. We can't afford time and money to provide one-on-one personal service, and customer support, even big businesses can't.
13) We want to see
Automation, Collaboration, data centralized, sharing all Departments. Not to store data every where, in many silo, not integrated software thus hard to mange and control and get data.

=>
We wish to know earlier, we would save tens of thousands of inefficient hours, repeat year over year, but not too late. Now we understand why big businesses, big organizations are willing to spend hundred of thousands for MS SQL Server, Oracle to have their Enterprise Database because:
1) For all Departments build their own EDBMS, solve their data and information problems.
Run their operations more efficient, and productive.
2) For centralizing data, integration, all offices, locations, departments any where. Manage data and information in one source.
3) For Data Analytics
4) For sharing and collaborating data all Departments.
Eliminate silos, back and forth.
 
=> The Management continued: "- WE ARE NOT EFFICIENT. Currently, we had few in-house siloed software systems, cost thousands + many full time staff maintain. A lot of money. We got all the best systems. But we can't see data thing we want. Ridiculous. It is true. These software systems don't talk each others. HR, Employees has its own system. Purchases Department has its own system, its own database. Warehouse, Shipping, Inventory has its own system. Manufacture, Product Department has its own system. Customer Services Department has its own system, its own database. Sales Marketing Department has its own system and CRM, its own database. E-Commerce Online Business Department has its own system, its own database...=> To understand problems, we must wait hours, days, email, phone, meeting, back and forth for the Manager's reports. => For example, in the Net.Office, RIGHT NOW, we want to see data listing, reporting of all Invoices, Customers, Orders, Shipping, Products, Stores, Offices, Total Sales, Employees, Accounts, Opportunities, Leads,  Activities, Schedules, Meetings from many different offices, locations... But, we can't see data. What we want is simple. But we can't.
 


- Imagination pushed knowledge to next level. Imagination is the source of innovation, creativity. Think outside the box.
- GE slogan:
Imagination at work.

-
Thomas Edison: " - To invent, you need a good imagination and a pile of junk."

=> Which means you are an Inventor, a Product Manager, you should have imagination, and you should not be afraid of setbacks. Business, company should not be afraid of setbacks and failures when inventing, funding, building new products.
=> For example, HP, a powerful high-tech corporation, thousands of smart Managers, smart Project Managers, smart Product Managers (PM), smart Engineers, smart Research Scientist, and smart Analysts, smart Sales & Marketing Managers, invested 10 Billions in database AUTONOMY. Having such manpower & resources to analyze and research product, and still, HP got it wrong. Cost them 9 Billions dollars. There are always setbacks, failures no smart, talented people can predict, analyze. But HP did the right thing = Inventing, Investing in R&D, Funding, and Building new products are strategically important for company and business.

=>
** There are all kinds of Data and the needs
We are living in the world of Order, and the world of disorder, Structure and Un-structure.
Organization, Business should collect Data that you can use, and that are beneficial, and that applied for your type of business. Which is called good data.

- For example, Social Media Companies collect data format different with businesses, organizations. Your company is not
GOOGLE, FACEBOOK, LINKEDIN.. GOOGLE, FACEBOOK, LINKEDIN problems are very different with your problems.

=> If you are good, you can use any tool to build anything, to solve any problems. There are many solutions to solve the problems. Use the simple solution to solve the problem. Thus reduce the complexity, the time and cost of project  development.

=> For example, company needs Enterprise Database. Because the banks used Oracle. So the IT people recommend Oracle the best, but can you afford? The cost of Oracle including software licences, hardware, network, developers estimably about more than 200.000$ / year. Just for the salary of Oracle DBA is 60K a year.

- Big businesses, big banks collect all kinds of data. There are only 500 companies in Fortune 500. But, in any country, 95 % of businesses, millions of businesses are small businesses with less than 35 employees. You don't hear SMBs in the news, on TV. Global, there are hundreds of millions of small businesses. Millions of small businesses, mom and pop stores don't have resources to collect kind of data like Fortune 500 companies, like big businesses. They don't understand what kind of data, Data Analytic Tools used for? A majority of small and mid size businesses used some sort of PC business software. A lot of SMBs don't even have Databases. They can't afford high-end Enterprise Database Management Information System (EDBMS) => SMBs just need a low budget, no IT headache, easy to use EDBMS like Net.Office Database in order to run their business more efficient, sharing and collaborating data any time, any where, multi offices, multi locations. => The data that millions and millions SMBs businesses collect are daily used business data. SMBs don't have big volume data, big velocity data to collect.

What to do about data?
3 steps.
1) Select *The Right Data*. For example, if business does need to collect the data of in-house delivery drivers, or Invoice, Customer data, or data of website's consumer browsing habits, or Social Media's data, then do it. If not, then don't do it. Ask: Collect Invoice, Customer data first priority or website data. If your website is static then can't collect website data?
- So what is
*The Right Data*? Invoice, Customers, Employees, Products, Inventory, Warehouse... are important data. Depend on the needs. Look Data's EDBMS Case Study.
- So What Tools used to collect *The Right Data*?
Databases like Cloud Net.Office Database, MS SQl Server, Oracle, IBM DB2..
.And many other kinds of Databases.
2) Models – focus on developing models that analyze, predict and optimize. 
3)
People – transform the organization with simple tools and effective training so that managers can take advantage of Data's insights.

=> Good Managers know how to design data, to organize Data. The data gathered to make the decision, to solve the problem, is more important than making the decision, than solving the problem.

 
- Businesses, organizations are governed by Data and Information. Business, organization without database is ...

- Because lack of Data Analytic Skills, Critical Thinking Skills, the average Managers see things in one narrow small view.

=> Businesses will have more benefits and ROI to invest in building Cloud Enterprise Database Software Applications than to invest in building Cloud Business Software Applications. Enterprise Cloud Database Applications need to build SQL box to run SQL Programming Language. The brain of Database Applications. Without the SQL box, the Database Software Application has no brain. RIGHT.

- Software Application is designed to solve specific problems. Software is not powerful tool to do Data Analytics. Using software application, you can't see far more. Can't JOIN different large data sets. Use software application, you can see like 2-D movies.

=>
A Database Software Application is designed to solve hundreds of specific problems
(See EDBMS Case Studies). Think a Database Application equals to 100 Software Applications built inside its Database System. That's is why database like MS SQL Server, ORACLE costs tens, hundreds of thousands compared with few hundreds dollars cost of software application.

- Business is very much better
to have a Database Application that do to the jobs of 100 software applications than to have 100 software applications, which each does different jobs. And each software application is not intergraded data. This is big problems for businesses.

How Software and Database Collecting and Processing Data and information? UIs (limited power) vs. SQL Programs (un-limited power)
-
Software collect and process data using UIs (= Dialog, Windows User Interfaces) where users enter data. Easy steps by steps. - Database collect, process and analyze data and information using Tables, Schema (Diagram), and SQL Programs. Data of Database Software Application is entered in Tables that are organized by Schema, not in UIs or Screens like Software Application, different with Software Application has no concept of Tables and Schema. As you see, SQL Programs are more powerful, flexible, and scalable than UIs interfaces in order to do simple and complex tasks to process and analyze data and information. And it is so much easier and save so much time & money for the software development to write 1000 SQL programs to do 1000 tasks. And save 1000 SQL programs in Library to re-use, re-run (1 click get data) than to design 1000 complex UIs, menus, screens, windows, dialogs... that will take years of time and money for the application developments. And design web based UIs, Dialog Interfaces for database application is time consuming.
Click see How Net.Office Database Save SQL Programs so easy and simple to re-use and re-run (Click pic enlarge).

=>
However, there are situations, Database needs UIs built-in. For example, Getting input data from users in database is very challenging because SQL is not convenient and friendly for input data in. That's why Data Entry Form is used. Data Entry Form makes so easy to collect data from users. See:
Net.Office Database Data Entry Form

=>
Easy and quick User Experience (UX): Yes, UIs is easier and friendlier to use. But next time using that feature again, users need to repeat again many UIs steps to get data. That's why business software is very hard to use.
- If use database application, next time use that feature, users just need to click on SQL Program and get data. Thus Database is faster to search, process data and information. One click get data. Which is good User Experience for people non-computer skills who have hard time to go through many UIs step to get data.

- Database is designed to solve variety of different problems that have huge data and information.
-
Database is powerful tool to do Data Analytics, and Search, Query, Process, List data in many different ways. It is flexible, scalable to add on more tables, expand more data when needed, and ability to JOIN different data, different tables, and Data integrated in one system.

- For example, Database Application can
JOIN, PROCESS CALCULATE, SEARCH, QUERY, ANALYZE data from: HR, Accounting, Warehouse, Engineering, Employees, Customers, Orders, Invoices, E-Commerce, Products, Inventory, Prices, Suppliers, Delivery, Drivers...=> It gives you a big whole holistic view of data and information. Software application can't. So that you can see data in different dimensions, bigger view. - For example, use software you see like 2-D movies. But use Database, you see like 3-D, 4-D, n-Ds movies. =>
That's why database like MS SQL Server, ORACLE cost a lot and a lot tens of thousands.

- The Need of Software Application Design VS. Database Application Design

=> Software Application: If businesses need to solve few specific problems, then software is needed.
- For example: Employee Time Sheet System Software to solve Time Sheet problems, Accounting Software helps accounting. Software is fix not flexible. Can't ask software company to design new features for your own needs when needed. Software Applications are silos. Each software of different company will not integrated data with each others. NOTE: Ofcouse, you can build Employee Time Sheet System, Accounting System in database.

=> Database Software Application: If businesses need to solve a lot of problems, complex problems in many different areas (See:
EDBMS Case Study ) that collect and contain a lot data and information, that requires Search, Query, Analyze, Join, and Listing, Reporting data and information. Then Database Application is needed. Database has all data of different applications integrated in one system. Unlike Business Applications are SILOS, NOT INTEGRATED. Database Applications are flexible, integrated, not fix. Data, Tables are sharing between Database Information Software Systems. Make easy for enterprise collaboration. For example, a 1000  Customers table of E-Commerce Database System is shared and used as same Customers table for CRM Database System. Because both systems is in the same company EDBMS. (See: EDBMS Case Study ). SQL Database Programming helps process, join data tables of different Database Application Systems easily.
=> Database Flexible, Scalable not fixed like Software: Database Applications can easily change its models, its diagrams, extend its structure, extends database by adding more tables, more fields or columns in tables, creating more relationship. Database Applications can have many sub-databases (or sub EDBMS) of Database Software Systems..
=> That's why Database Applications cost a lot of money, tens, hundred of thousands.

- For example, you have database applications: Employee Time Sheet System - Customers Sales and Leads Management System - Track Customer Order Software System... (See:
EDBMS Case Study ) All data are integrated in one big
Database Management Information System. Thus it is easy to manage, share, and collaborate centralized data.
- Use different software not integrated each others.

Example, business had an Accounting Software with 1000 Customers data, and had another CRM software with same 1000 Customers Data. When you change or insert new customers for Accounting Software, you also have to change or insert new customers for CRM software. Thus very hard to manage & collaborate same Customer Data but in different places. Waste of time.
- Use Database, only one Customers table contains customer's data. This same Customers table, same Customer data is used and shared by all other database systems, for all Departments. Thus, when update, insert new Customer data in table Customers, all other Database Systems will share the same Customers data. It is called Data Centric.

=> Database Management Information System (DBMS) is  expansionable, scalable, customized, flexible, data centric, analytic, and easy sharing, collaborating data.
- You can always expand  database, expand database schema (diagram) by adding more fields in tables, adding more tables, adding more relationships. Thus database is growing and growing on demand. Use software, can't ask software company to design features for your needs.

=> Conclusion: A Database Application is equal to 100 Software Applications built inside its Database System.
(See: EDBMS Case Study ) Businesses will be much better to have powerful Database Software Applications than to have many silos Software Applications.
- Business has more benefits, and ROI if it has to invest in building Cloud Database Software Application than to invest in building Cloud Software Applications. => Because Database Software Application is the sources of Data Analytics, and make it easy for all kinds of Data Analytics Tools, very popular now.
=> But all depend on your business's needs: A Database Application or A Software Application, or a combined both: A Database and Software Application.


- Net.Office Database is very simple and most cost effective database compared with other high-end databases.



- This is table ORDER DETAILS where Invoice Data stored, and other tables like ORDERS, PRODUCTS of Big E-Commerce websites. As we suggested that e-commerce, online business websites should be designed properly this way, with EDBMS back-end. A lot eCommerce websites didn't build this way, no database EDBMS. They don't have tables like OrderDetails, Products, Orders... Because lack of knowledge, the business owners only pay attention to the front-end, and not to the back-end.


- myNet.Office, Net.Office Database help you business solve so many problems with less cost, no IT complexity. All-in-One Net.Office Solutions.





- Net.Office Database in the cloud. Business is moving Data in the Cloud for easy sharing and collaborating, and cut cost of hardware, software, and IT infrastructure..
- NOTE: See the Similarities and Differences between Cloud Net.Office Database and high end databases. Click here.
 


- myNet.Net.Office: A small budget, affordable, simple IT infrastructure, and productive Net.Office integrated All-in-One Net.Office solution, Online Marketing, cloud E-Commerce, and cloud Database for all kinds of businesses and organizations.

 


=>
We want just one click, get real time data. Others systems are too complicated. Required many screens, so many clicks, many UIs back & forth. Required 60K developers to run, operate, maintain. Don't you see? We are not developers, not IT people. If the Management can't see data then we can't make good decision. Then this is no good.

NOTE: - LinkedIn submit resume is the best example.
One click submit resume.
- How many clicks to Create this complex Table, using Net.Office Database you just need 1 click to Create Table. See how, click here.

14) The Management wanted to see simple. What ever technology, tool.. We want -> just one click -> See what ever simple or complex data in real time. We want to see data anytime, anywhere, at home, in hotel, in Net.Office, in travel, on mobile. 
=> If our systems can't do this, then get other system can do this. Or build our own Database Management Software System. The Management don't want to depend on Managers for data all the time, and for data transparency. Right now, we want to see: What are new Orders, new Customers, new Purchases, Schedules, Orders shipping out. But we can't see. Don't you see?

NOTE: This is statement from a CEO of a big size company with approximately 2000 employees, many offices, locations around the world. They felt very frustrated of the company's complexity and costly IT infrastructure. Their Management can't access data anytime, anywhere they wanted. Using myNet.Office, they one-click-get-data. When the company needs support, we sent SQL programs (script), like Apps, designed for their schema. Their staff just Insert Programs (Install) in Net.Office Database. Then run. No download, no installation, no in-house Developers. Simple See: Click here

15) - FINALLY, the Management continued, we wanted to see: "- A budget, cost effective, simple IT infrastructure, easy to use, and productive cloud Net.Office integrated All-in-One Net.Office Solutions for all Departments having just outlined above 15 recommendations in this meeting, must be implemented for the company and for all our Departments."

The Management continued: "- Without the Technology, the Internet, the Cloud, we can't leverage all our potential, be efficient, modernize company, compete globally, and move company to next level.
Have fun. Thank you. "

=> This organization, this company lucky had the good Management understood problems, and fixed.

=> Businesses, organizations are governed by data and information. Every day in the Net.Office, we are working on some sort of data and information. Data helped Managers make good decisions. Good Managers know to analyze data and to organize data.
Google is a culture of data driven decision making.
 


Net.Office Database is the 1st database that designed & implemented ROID Technology.
What is A Relational Object ID (ROID) ?

Is an ID (such as: CustomerID, ProductID, EmployeeID...) that points to big table object in order to access big data set of record of database table Object.
- Think ROID is the key (like table Primary Key CustomerID) in order to open a cabinet (e.g: table Customers is a file cabinet of customers) where all the files and folders stored in the cabinet.
- Think ROID is pointer to large big Data Set.
In computer languages like C/C++ used pointer, like address of the house, to point to an address of a big space in memory where to store large data. When retrieving data, the program only needs to know the address of the pointer, like house address, in order to get data.
We spend billions in R&D to make database, apps, hardware, network run faster (speed), contain more data (space). In Computer Science, there is a trade off between Speed and Space called Big O(n).
=> ROID is the solution for databases to improve and optimize for both speed and space in cloud where speed and space are very important.
=> ROID helps JOIN faster, connect more tables, large dataset because JOIN is powerful but it consumes database memory, resources. ROID is good for Cloud.
-
For example, when JOIN 10 tables, like carry 10 File Cabinet, very heavy, resources consuming. Thus, rather JOIN or carry 10 File Cabinets (10 tables), you carry only 10 keys pointing to 10 File Cabinets.
=>
More important, ROID solution doesn't cost BIG money to upgrade software, hardware, memory RAM, network in order to buy speed and space.

=> To create ROID and create View for ROID what columns of table should be displayed in ROID, use Net.Office Database Table Relationship Manager Tool. (<= Click see)

=> Net.Office Database is not in memory-database that used a lot of machines, RAM memory in order to store data that are spreading over so many machines. Even RAM memory is cheap but still cost a lot of money. And you also need to buy a lot of machines. Thus complex infrastructure.
 => Net.Office Database is pointer-database. It used pointer to point to large dataset and get data. Thus it doesn't cost money to buy more machines, more ram.

=> Relational Object ID (ROID) Benefits
1) ROID helps database query, search, process data faster, and contains more tables, contains and displays big data space of *large and big Data Set*
- For example, traditional Query 100 cols of 3 tables, each col, avg = 100 bytes, 100 cols = 10000 bytes / row. Use ROID to query only 3 ROID as pointer to 3 tables = 3 x 11 bytes = carry 33 bytes / row.
=> Thus database used ROID to query, and carry only 33 bytes VS. 10000 bytes / row (database no ROID) = 303 times / row faster for database to query, load data, carry data
=> Thus when display 100 rows or 100 records at a time, Database used ROID will query and carry data => 33 bytes x 100 row = 3300 bytes VS. 1.000.000 bytes  (no ROID) => 303 times x 100 rows = 30300 times faster Query, load data than traditional Databases query, load data, and carry data.

2) ROID saved and stored files, photos, videos, big data files in database using pointer less than 100 bytes to point to photos, files, videos, documents.
For example, Other databases save big data files, photos, videos, as heavy as hundreds of millions of bytes data, as big blob binary data in database, and spreading, mapping and reducing data, files over many servers, clusters, nodes, machines. Photos, files, videos, hundreds of thousands times bigger bytes then raw data. The field ADDRESS, raw data in database is # 200 bytes. The resume file in Word is about 100 KB # 100,000 bytes. A photo is about 1.5 MB of 1,5 Millions bytes. A video even thousands time bigger than photo. Some videos 1GB = 1 Billions bytes.
Another example, You have a photo as big as 1.5 MB = 1.5 x 1024 x 1024 #  1,5 Millions bytes. Using Net.Office Database, you upload that photo in field PHOTO of Employees table. The PHOTO field stored only 30 bytes pointer to the PHOTO, NOT 1.5 MB bytes data. This works the same for other files like Videos, Word, Excel, PDF...That's why using this ROID Technology, Net.Office Database is able to carry a whole table as big File Cabinet in the cloud, and able to store photos, files, videos... in the big Table File Cabinet. Using Net.Office Database, there is no Read / Write files, data, mapping data, files in disks, nodes, machines.

3)
Net.Office Database ROID Technology helps JOIN faster, connect more tables, large dataset because JOIN is powerful but it consumes database memory, resources. ROID is good for Cloud. ROID helps users connect, JOIN large data set of 20 tables, > 300 cols / row. Create a holistic view of all the dots of data & information in front their eyes. No back & forth! - For example, when you JOIN 10 tables, like carry 10 File Cabinet, very heavy, resources consuming, slow. Thus, rather JOIN or carry 10 File Cabinets (10 tables), you carry only 10 keys pointing to 10 File Cabinets.

4)
ROID helps database goes Social. Such as: Chat, Email, Connect, Appointment, Post Message, Micro Blog, Follow, Collaborate..

5)
ROID is the key helps database users open the big table file cabinet. And ROID delivers, moves the file cabinet in cloud faster.

6)
ROID helps users to Edit, Insert, Update data, Browse, View data at any data point ID like ProductID. (see and click on photo enlarge: Net.Office Database .)

7) ROID gets data in different Data Relationships = Net.Office Database gets data in - Reverse Relationship is the reverse of current relationship. And, Indirect Relationship.
=> Net.Office Database Reverse Relationship Algorithm and Analytics, see in photo Net.Office Database, ROID CustomerID 2, row 8 = Peter King, shows the Reverse Relationship between Employees, Customers object and Orders object: - How many Orders this Customer ID2 had bought? = Order 100, 105. - Who are the Employees Sales Reps of these Orders, of this Customer? Employees = 3, 4. => This Reverse Relationship helps company, managers easily track who are Customers, Employee Sales Exec of these orders, these products when needed, or had problems -
- Another example,
the Reverse Relationship between Products and Suppliers. In the normal 1-to-Many Relationship, we only see the SupplierID 2 = Lowe's is the supplier of ProductID 6 = Blues Sky Berry Ice. However, in the Reverse Relationship, we see SupplierID 2 = Lowe's is the supplier for many Products= Product ID5, Product ID6.
=> Net.Office Database Indirect Relationship Algorithm and Analytics: Shows the indirect relationship of objects in the Enterprise, like in Social Media's Second, Third connection.
For example, the Employees Object, the Customers Object, both indirectly connected with Products Object. You want to see their Indirect Relationship. That means, see: - What Products that this Employee (s) sold? - What  Products this Customer(s) bought? - Another example, Employees and Customers has Indirect Relationship. You want to know: - Who are the Customers of this Employee (sales Rep)? And vs. - Who are the Employees (Sales Rep) of this Customer? See Relationship Diagram
- Another example, you expand Database Management System by adding a database Managers. We want to know - Who are the Mangers of the Employees so we create a direct Relationship between database Managers with database Employees. Then create another database Departments to store information of Departments. We want to know: - Where and What Departments that Managers work. So we create a Relationship between Departments and the Managers. Thus, Employees object has indirect relationship with Departments Object. Now, you want to know: What Department (s) this Employee works? The Indirect Relationship will show you 1 or many Departments this Employee works at. An employee can work for 1 or for more departments. Indirect Relationship also helps you see: - Who are the Managers, the Departments in charge of making these Products? - Or, What are the best Prices from these Suppliers for Products?
-
Or, - Who, Where are the Suppliers, the Employees bought these Products?
=>
Everyday, in the Net.Office, we are working on data and information. These questions can take staff hours and hours to find. Using Net.Office Database, it takes less than few seconds to get data. One click, get data. => Which means, staff are thousands times more productive. => Which means, save the company thousands and thousands of hours per year by multiply for number Employees saving times. => Which means, help employees less stress, and have fun in the Net.Office.

** IMPORTANT ** Reverse Relationship, Indirect Relationship use for Data Analytics only. They are not used to create Database Relationship = 1-to-1, 1-to-Many, Many-to-Many, only 3 Relationships.

8)
ROID displays large Data Set orderly in group by table (=Data Presentation). Thus, easy to see data, analyze data, present data nicely in group by table category.
- For example, you click on ROID of table Products, ROID of table Customers, you see data set group by Products, group by Customers. Each Data Set is separately group by its table category. Traditional database will list a long list of data.

9)
ROID helps database run SQL Programs shorter, cleaner, and faster.
- For example, you want to display 40 columns of 60 columns of table Products, and 30 columns of 50 columns of table Customers. You will write SQL program like this:
- Select Products.Name, Products.UnitPrice, Products.UnitsInStock, Products.UnitCost...( list of 40 cols) Customers.Name, Customers.Phone, Customers.Email, Customers.Address...(list of 30 cols). Your code contains long list of 40 columns of table Products, and long list of 30 cols of Customers. Thus, very long list of columns SQL program. You would rewrite this SQL program like this using ROID.
= Select Products.ProductID, Customers.CustomerID. (= List of only 2 columns, 1 ROID col for each table. Not 70 cols) That is it. Now you access to 40 cols of table Products, 30 cols of Customers.


=>
However, Enterprise Object ID became useless and confused, better not use it, if users can't access to its table in order to View, Edit, Insert, Brows data and information. Like have the key but can't open, can't access the file cabinet. Then the key is useless. For example, MS SQL Server doesn't use ROID. Thus ProductID is very confusing. Better not to use it. Why? Click here.

Relational Object ID (ROID) increases huge speed, and huge space of database, and run SQL program faster.
=> In database, in computer science, speed and space are the most important.
Which means database is loading and displaying more data and running more faster. Space here we refer to the contain, the memory, the amount of data that database is carrying. Run SQL program, and query also faster because the search query contains only one column Relational Object ID (ROID) = 11 bytes, and not a long list of columns.

- In the picture example, database is loading only 7 Relational Object ID, which is: Orderdetail_ID, OrderID, ProductID, ShipperID, EmployeeID, SupplierID, CustomerID. Now, imagine if we run a query that JOIN and CONNECT 20 tables. That's a lot of data, information, and columns to display. When Create Table, in the code, the field Address varchar (250), which tells database to carry 250 bytes of data for Address. Field CustomerID Int = Data is an Integer (a number). Database carries only 11 bytes of data. Thus, if loading 20 Relational Object ID, each Relational Object ID represents for a table, the total bytes of data and information that database must carry for each row is: 20 ROID x 11 Bytes = 220 bytes. Which is very small bytes of data (= nothing), even less than an Address field = 250 bytes of data. Without Relational Object ID, database will carry at least 20000 bytes each row of 20 tables. That is 1000 times heavier of loading and carrying bytes of data and information for each row. And your computer will need a big TV screen to display all 200 columns of 20 tables giving each table on average has 10 columns (CUSTOMER_NAME is column, or field). Some tables can have more than 50 columns per table.
 
=> The number. Let's break down to bits and bytes: A table can have more than 50 columns. Each column or field can contain 250 bytes of data like ADDRESS field. Some columns are less than 250 bytes. Some column Text field can contain 64000 bytes of data. So we take the minimum number in this calculation by giving the table had only 10 cols (not 50), and each column on average is 100 bytes (not always = 250 bytes like Address). Thus 10 col x 100 bytes = 1000 bytes of data per row or record. Thus, 20 tables x 1000 bytes = 20000 bytes of data / per row that database has to carrying and displaying. Speed and Space is always a big issues for database. SAP had new database called HANA that can improve a lot of speed and space. Why we said display columns of 20 tables need a big TV screen? Because each table has 10 columns. Thus 20 tables = 20 x 10 = 200 columns. Look at the picture, we display 16 cols on a laptop. You can display more columns but must use slide bottom bar back and forth. Thus, to display 200 cols is a very long long line. It is impossible to see and analyze the data of 200 cols using the scroll bar back and forth. But using ROID, we can access to 200 cols  easily.

=> Using ROID to JOIN 20 tables, each rows displays only 20 columns rather than 200 columns. As a result:
- Improve SPEED: Net.Office Database LOAD 220 bytes / row (nothing) vs. 20000 bytes / row (no ROID) =
That is 1000 times more faster speed / row, or 20000 times faster / 20 rows
- Improve SPACE: Net.Office Database LOAD only 220 bytes of 20 keys vs. 20000 bytes of data / row = That is 1000 times more data space / row,
or 20000 times more data / 20 rows

Do the math when Net.Office Database is displaying and scrolling 20 rows at one screen we show in picture example, it is: 20 rows x 1000 times = 20,000 times more speed faster and more data. When Net.Office Database is loading and displaying 50 rows / screen, it is: 50 rows x 1000 times = 50,000 times more speed and more space.
=> Another example, when database moving, loading, carrying, displaying 20 big heavy cabinets (think a table is like a file cabinet), each file cabinet (table) contains ton of data, file folders. Data, file folders in file cabinet is like records of table because table stores data in records. Where? Look at each row on the picture of table Customers is a record. A table Customer can store tens of thousands of records of Customers. A table can also stores files (example, table resumes), like: PDF, Word Doc, Excel, Photo, Video... Thus, like file cabinet, a table, like Customers table, can contains tens of thousands of Customer's records. Each record contains files, doc, photos, videos, data, and information. A lot and a lot data in a table. Thus, when database carrying and displaying 20 big heavy table cabinets with huge data inside, is likely smoking user's computer, and not enough computer screen width to display > 200 columns of 20 tables. Not efficient. Problems solving?

 => The solution, should not move, carry 20 heavy cabinets. Just need to move and carry 20 keys (Relational Object ID) of the cabinet (table). As light as you can carry 20 keys in pocket. Then use the key, a click of mouse, to open, access all data, file in cabinets.

=> In Technology, we spend billions in R&D on how to make software and hardware run faster (speed), and carry more data (space). In this case, ROID helps database get both speed and space. => This is a big deal for databases in cloud where the demand for speed and space is very extremely important.

=> We just want to be sure and be fair sincerely that Net.Office Database is the first database that implemented and designed the ROID Technology.

- Moving and carrying huge data, many file cabinets (tables) in the Cloud are Not efficient.
- The Solution: Need to carry the key (ROID) only. This is big data, huge data scaleable =>

- It doesn't matter the size of the cabinet,1K bytes or 1 billion bytes of data. Because database needed to Carry only the key = 11 bytes. Then use key to open and access all big data, a whole heavy file cabinet table.
=>This is a good deal for database because on average, EDBMS has 15 tables. Click and look at EDBMS Case Study Examples. So we can be able to connect, to JOIN all the data, scalable data, all the dots of all relational tables in EDBMS into one work flow. It helps us to see data clearly, to analyse data easier, to dig deeper data, to track data more detail, to solve complex problems, more efficient because all data of all related tables are connected at one. ** No back and forth wasting times to get data ** Specially for non SQL database users, like the Bosses can see data clearly in one work flow.

** IMPORTANT **: We know that Enterprise Database Management System *** EDBMS is all about the key **** Thus, Relational Object ID is very important because it is a key to open a whole file cabinet. And it allows us to JOIN more tables, connect more dots. And it improves more speed and space when processing and displaying data.
=> But Relational Object ID became
useless
if you can't Edit, View, Insert, Update, Track its data. Because, have the key but can open the cabinet.
** If we have the key, but can't open, can't access, can't do something in the cabinet, such as: Insert, Add more files in cabinet, or Look, View files in cabinet.. Then better not to use the key, because it is useless and causes more confusion ***

***
For example, see the key ProductID = 2, OrderID = 104, CustomerID =9... Very confuse! What is it? Don't show me ID. I don't understand? See why click here.

=> This is unique feature of Net.Office Database, even MS SQL Server can't do this. We understand that MS SQL Server is one of the best servers on the market. Why MS SQL Server's ROID is useless? Because you can't Edit, can't Update, can't Insert, can't View data in MS SQL Server 's Relational Object ID. Because you * have the key but can't open the cabinet * See why? Click here.
 
=> To edit data or update data of table of a Relational Object ID, just click Edit icon in ACTION row of the Relational Object ID.
For example, to change Units On Order of Product ID 2 from 20 to 10. You update every fields (or columns) of Products table, like Unit Price.., not just Units On Order. You can edit Units On Order from opening table Products and update record ProductID =2. But this way is faster because you don't need to jump back and forth switching screen to table Products Data Entry screen and do the update.
 
=> To customize View, to create View of Relational Object ID, use Net.Office Database Table Relationship Manager Tool.
For example, if you want to add on the display Customer's Phone for View. Click and see Net.Office Database Table Relationship Manager Tool.

- To collaborate with Employees within enterprise, let's create a table called Employee_Project, with PK = EM_PROJECTID -> Then create 1-to-Many Relationship with table Employees -> Then Join and display EM_PROJECTID -> When company staff run a query report like this one, they mouse click on EM_PROJECTID will give them more detail about that EMPLOYEE. What project they are working on, Project Managers, Departments, Project Description, Project Budget, Project Team Members, Project Time, Project Deadline, Performance.... You can always add on more data fields in Employee_Project table.
=> What ever information, data you want to track, to collaborate employees, staff. See example of ShipperID object, or ProductID object, or SupplierID object.
=> Now the Boss, the Management can have an overview of their Employees. Who are they, their Photos? Where they work, their Net.Office? What are they working? Who are their Customers? Who are their Managers? What sales invoices they sold, Total Sales Revenues? ...And so on. You may need to design more tables that are related to the Employee_Project tables.

- To track Shipping of each Order, Create a table called Shippers with Primary key = ShipperID -> Then create a 1-to-Many Relationship with table Orders by Adding PK = ShipperID in table Orders. That is it. Done -> Next, Add in this query JOIN the ShipperID object. Users just mouse click the ShipperID will track the whole information shipping of each order.
NOTE: To add ShipperID in table orders to establish Relationship: Orders: 1-to-Many : Shippers, you run this SQL script:
SQL = Alter table orders add ShipperID Int after EmployeeID = Add key ShipperID into table Orders next to column EmployeeID. Int = Data Type of ShipperID is Integer number (not decimal number)

Create table Shippers
(
ShipperID int not null auto_increment,
ShippingID varchar (40),
/* UBS, FedEx Shipping ID..*/
CompanyName varchar (40),
Phone varchar (25),
/* Add more fields, tracking more details of shipping, what ever info if business needed, add any time OK. You can change the filed name. But don't change the Primary key. */
EmployeeID,
/* the employee who shipped, the driver */
Shipping_Date Datetime,
Estimate_Date_Arrival date,
Shipping_Note  varchar (200),
primary key (
ShipperID)
)
- To track Shipping of each Order in table Orders, you will do these steps:

1) Create an extra table Shippers (See left side) in EDBMS

2) Establish a relationship = 1-to-One with table Orders by adding the primary key ShipperID in table Orders. Why 1-to-One? Because 1 order is 1 shipping. If you just use the table Shippers to store only the Shipping Company Name, like UBS, FedEx.. then it is 1-to-Many because UBS can ship many orders. You can also include all fields in this Shipper table in table Order as well. Don't need table Shippers.
- But if you need to track the EmployeeID of shipping employee or the company Driver, then you need a separate table Shippers, because in table Orders already had EmployeeID. For example, the EmployeeID in table Orders is the Sales Rep. And the EmployeeID in table Shippers is the employee Driver who delivers this order. So 3 years later, you still know both the Sales Rep Employee, and the Driver Employee of that Order.

3) Input shipping data correspond to the related record of Order. Each order has its own shipping data object ID. Data updated instantly.

4) In this query, add an INNER JOIN table Orders with table Shippers.

=> Now you can track every shipping for every order
just using your mouse click on ShipperID.

- To know about Stock Inventory of each Product, just add ProductID in this query. Mouse hover on each ProductID will let staff get the quick shot at each Product Inventory, Units on Orders, Suppliers... To update data for products, such as: UnitsInStock, UnitsOnOrder, UnitPrice...just open table Products and update data of that record.
For example, to update UnitPrice from 6.0$ to 5.50$ for the product = Beef Soups, ProductID = 2, open table Products -> Click on record ProductID=2, and change UnitPrice. Now every one has the latest UnitPrice of ProductID=2, Beef Soup. Add more fields, tracking more details of Products, what ever info if business needed, add any time OK.

- To know about Supplier of each Product, just add SupplierID in this query. Mouse hover on each SupplierID  will let staff get the quick shot at the Supply of each Product. Add extra data field = SupplyPrice in table Products to track the difference price between Supply price and selling price = UnitPrice.

- To know about Payment of each order, just add PaymentID in this query.

With this kind of technology, from anywhere, anytime, staff now can get a lot more data and information, so quick and so fast, time efficient of each Order, each Product Stock Inventory, Unit on Order, the Supplier, each Shipping, each Payment, each Customer, each Employee by just 5 seconds using the mouse on each CustomerID, EmployeeID.. There is no more wasting time, days of back and forth, Email, Phone asking for: When will be shipping? How many Products in stock inventory, supplier? Who are Customer more detail info, their contact Email, Phone..? Who are Employee responsible for this order, and contact Email, Phone..

=> All about Data Collaboration, about Social Collaboration! Net.Office Database database is used as a centric data sharing, instantly updating, and collaborating,
a Relational Working Model at work. Now, not only the purchase Managers, the Sales Managers know, but also the Box, the Management know data update instantly so that they can provide advice and feedback on time.

Processing Order, E-commerce Question. Every day, businesses have to deal with Orders, Products, Suppliers, Shipping, Payment, Customers, Employees. These are the basic components of business. How long does it take your company, staff to gather all detail information updated instantly about: Order, Payment, Product, Shipping, Supplier, Total Sales, Tax, Employee responsible for order? Can your e-commerce website do a simple basic JOIN multi table query to get data like this example? That's why businesses, organization spent tens of thousands to buy SQL Database in order to solve their business problems because they understand cheaper business software package can't solve complex business problems. SQL Database helps businesses and organizations solve problems fast and efficient.  .

Database servers on the market.

Database market is like car market. There are many different bands, many different prices, many different features. Ofcouse, if you can afford 100K car drive to work, then it is good for you. Ofcouse, MS SQL Server has features that Net.Office Database doesn't have, or users don't need. Business paid
tens of thousands of dollars for high-end Server's software, hardware, and licences or for other databases. Not all businesses can afford that kind of money. Database Server, just like other Software Application, or Spread sheet, or Database Application, like Windows there are features users never use, never need it. For example, most users used maximum 20% of all features of Windows 7, 8 or software application.



Picture:
Relational Object IDs, such as OrderID = 10248, ProductID=11.., in MS SQL Server are useless and  confused.
JOIN 3 tables.


Picture
: This is Database Oracle JOIN 2 tables Employees E and Departments D

=>
That's why MS SQL Server JOIN only 3 tables = {Order, Order Detail, Customer} displaying so many columns(>40) / row because each table has more than 15 columns. As you see from this screen, MS SQL Server fits only 10 columns /row in 1 screen. Therefore, displaying > 40 columns, users have to scroll the horizontal bar to the end to see data of Unit Price, Quantity, Discount. Thus back and forth with the scroll bar to the beginning and to the end.

=> In this MS SQL Server screen, look at OrderID=10248, ProductID =11 => Can you tell what is Product ID =11? What is Order ID =10248? Can't Update Data for the OrderID = 10248 of table Orders. You just know the ID but don't know about information, data of IDs, such as: Product Name, Unit Price, Units in Stock, Supplier of ProductID = 11...?
- Using MS SQL Server, if you run query displaying many Relational Object IDs like CustomerID, ProductID, SupplierID, PaymentID, OrderDetailID, ShipperID, EmployeeID, ScheduleID...Then you will have very hard time to track on these IDs. Thus, it is hard for users to connect all the dots / row. Then you have to run different queries on many tables, back and forth on different screens.

=> Now, compared to our screen picture, it fits
17 columns of ROIDs / row into 1 screen. Net.Office Database JOIN more 7 tables = {Customer -> Order Detail -> Order -> Product -> Shippers ->  Employee -> Supplier }. Users get all data, all columns in just one row. Fit into 1 screen. No scroll bar back and forth, although you can scroll if so many columns over the screen boundary. Of course, JOIN 7 tables, users will see more data, more info than JOIN 3 tables. Users see data connected all the dots from the Order.. to the Employee... to the Supplier.

=>
Net.Office Database can JOIN
20 tables into ONE WORK FLOW. Hopefully, every day of work, you don't need that much data and information of 20 tables connected. 

=> 1 Relational Object ID access >= 15 or more 50 columns. That's why
Net.Office Database can JOIN 20 tables, 300 columns / row / screen  And still can access all data of all columns.

=> With Net.Office Database,
every one can tell data, can update data right away by a mouse click. In general, you can't Track data, can't Edit data, can't Insert data in Relational Object ID with Ms SQL Server. With Net.Office Database not only helps you track data Relational Object IDs just a mouse click, but also you can update data, insert data into Relational Object ID, and make ROID instantly available, for sharing data, collaborating data instantly up-to-date.

=> OK, from query on thousands of orders, the Boss asked: Can you tell:
- How many Units In Stock, Units On Orders, the Cost Price, the Suppliers of ProductID = 11, 42, 72, 65 ..., the Inventory?
Look at the sub-EDBMS for Inventory. Click here.
- Who are the best Suppliers of best Price for this ProductID = 42, 72, 65, 31...? Do we have a list of up-to-date Pricing of all Suppliers?
- Giving a Product ID = 42, 60, 31, 22, can you find or list the top 5 best prices from the top 5 Suppliers for each product? List all the contact details of these Suppliers?
- What are the Ship Date, Ship ID, Ship Address, Ship Company, Shipping Arrivals of Order ID =10248, 10249, 10250?
- Who are the Employees responsible for of these Orders: 10249, 10250.. their Contacts Email, Phone, their Bosses?
- Who are the performance of Employees had the most sales, the least sales, and no sales this week?
- Who are the Customers of these orders, their Contacts: Email, Address, Name, Title, Company, City..? Repeat or New Customers? Who are top 10 Customers?
So that we take care them well
- What Customers think about your company from analyze data?
- What sources of Marketing (TV, Paper, Internet, SEO, Social Media, Word of Mouth, Repeat customers targeted from Database Marketing...) that Customers know and buy your products and services?
- What are best products and services Customers like and buy the most, and top 10?
For example, run a query on the top ten total sales of products and services will answer this question.
- What are the most product's problems, most RMA returns from customers for the Product ID = 42, 31, 22, 65..?
- What are the top 10 problems of all products? Who are the staff? Date of problems?
For example, this sub-EDBMS helps company to manage product problems and tracking issues. Click here.
- What are the top 10 return products by customers, top 10 products having most problems? Quality Control Issues? And why?
- What are the top 10 best sales of products this month? What product's colors, sizes customers like the most? And why?
So that we order more these products, or just focus on these products
- Who are the top 10 customers who return the most products? And why they return?
- Why Orders lost, Money lost, Products lost, or delayed, mistakes, missing invoices, abnormality, fraud...? So on...
For example, Query different JOIN between Orders (Invoice) tables, Products table, and Customers table will tell you match and no mach between invoices and customers, and products...
- Find customers had not orders in the past 6 months, or not ordered at all ?
So that we give them some promotions to bring them back to store.
- Calculate Total Sales, Taxes, Profit, Lost, Revenue, each day, month, year? 
For example, use Query JOIN, GROUP BY, BETWEEN, will let you know the total sales, total taxes in between Date.
- So many questions about:
Customer, Product, Inventory, Supplier, Payment, Invoice Order, Order Detail, Shipping, Employee, Schedule...kept every one very busy every day...
=> Net.Office Database helps business to answer these questions easily.

=>
Sorry Boss, I can't handle all these data and information. Too much for me.
=>
Ofcouse, not your fault. No human can handle, remember all these data and information.

=>
Businesses, manufactures, organizations use a lot spreadsheets. Spreadsheets can't solve these problems because not database. No built-in SQL.
Look at this spreadsheet contains data about: Order, Invoice, Product, Customer. Data duplication, redundant, un-organized every where. That's why spreadsheet must be normalized before input in database. That's why most spreadsheets, just like papers, are unused inside harddrive. Thus all data from spreadsheet are useless. No one cares to look at. And also it is hard to share and collaborate data on spread sheets.

Picture: This spreadsheet contains data of: Orders, Invoice, Customers, Products can not be used to analyze data. Data duplicated, redundant, un-organized. WHY? Because spread sheets can't be related (Relational) like Database. Each spreadsheet is alone itself. Think spreadsheet like one big stand-alone table. That's WHY spreadsheet pack, store all data into one spreadsheet. => This spreadsheet, data need re-organize using database normalization into 4 relational tables: Order, Customer, Product, Order Detail. We already show you how to. Click here.

=>The Managers don't know because no database background.  That's why we need database to organize data => This is the daily Business Operation.

=> Assumingly, the Bosses, the Managers in the Net.Office, and they don't know SQL to get data, they also want to know. Thus the Bosses, the Managers can't see data as well.

=> Thus back and forth many Times, back and forth Emails, Phones...

=> In one Net.Office, on location,
every one can go to their staff's desks, and ask for data, or go to warehouse counting. => But, in large enterprise, this is a big problem, back and forth, with so many orders, so many products, so many shipping, so many suppliers, many departments, many employees, many staffs, many managers, every where, in many distant offices, in many locations, around the world. The Management can't afford the end of the month report. They want to know the data now: When an order is shipping? How many items in stock? ..so on...
 

 


Net.Office Database lets you easily upload photo, pictures, files, documents, videos, Pdf from harddrive, and store them in web database in Cloud. And Send Email from tables. Other databases, this task is not easy.

For other databases, insert photos, pictures, videos, files into database, and then display. It is not easy. It  required programming.
As you see, other databases, to insert images, videos, files in to database tables is a big deal. Require developers to program.

But use Net.Office Database, insert files, videos, photos is very easy, just like upload files and images from local harddrive into database.
 


But not for Net.Office Database, insert photos, images, videos, files in database is so simple and easy.

You click on the
upload files icon to upload your photos, files, documents, excel, Pdf files from your laptop, or PC, then insert into table in 20 seconds.

It is safe and secure to stores in Cloud Data Center that had IT people to take care and maintain than to store files, data in PC servers in Local Area Network (LAN).

Companies used Net.Office Database to create a EDBMS (Relational Database Management System), like A Cloud File Cabinet Relational Database Management System, for storing their products and services that include: Product Photos, Product PDF files, Product Document Words, Product Spread Sheet files, Customers Files, Support, Suppliers... And then upload these files, information, documents, photos on the cloud so that staff, employees, customers can share, work, search, and collaborate on Cloud File Cabinet Database.

Case Study

Before, HR department used to store resumes in email, in PC. It is hard to share and collaborate on resumes stored in email. Take a long time to search resumes, to pass resume back and forth from email. Recognized the inefficiency, the HR staff then used myNet.Office to create
A Cloud HR Resume Relational Database Management System. Then Upload Resumes, Doc, PDF files from PC harddrive into database Resume. Resumes now are safe, secure, and kept for a long time in database.
Now, not just HR staff, but also Managers, Bosses, can share, view, search, select, search, collaborate resume database online, any where, any time..



Picture: A simple Resume table. Upload Resumes Word doc files, PDF files from PC harddrive into database table.

NOTE: Expand this simple resume database, from only one table, to become a bigger EDBMS by adding more tables, create more relationships. Could you?

The button [Save As Query] lets you save all queries, SQL commands as short SQL programs, when need it, just click and run. Very quick. No need to re-enter SQL code again.



Net.Office Database easy Create Table in 1 click. Then do Data Entry Form to Input data or to Update data

Data entry, input, insert data, update data in database is a challenge. Net.Office Database Easy Data Entry UI Interface is very easy to use.
For example, after created table my_support_center (see SQL code at the right side),  to insert data or to update data in this table:

1) Click select this table =  my_support_center on the table listing from the left side. This will list or display, or load this table in Browse listing mode

2) Click on the top menu = Data Entry / Insert will open this Easy Data Entry ready to Insert data or to Update data in table my_support_center. The Data Entry has Record Listing below. Make it easy to update.


Picture: Net.Office Database Easy Data Entry UI and its scroll List- This table has 5 records.

3) To Update an existing record, click on top menu = Data Entry / Insert will open this Easy Data Entry. This Easy Data Entry has a scrolling list of records, in this case 5 records in this table. The listing list can display as many as 10 records per page at a time. You can scroll the list Next, Prev..
- To update record ID = 3, click on its Primary Key = 3. (See picture). All its data loading in the blue Data Entry. You change data. Then click on UPDATE button. 

4) To Insert new record: Click on button CLEAR on the blue Data Entry Form to clear all data in Data Entry. This will enable INSERT button as well. Because when loading data and UPDATE, INSERT is disable -> Enter data -> Click on INSERT button to insert new record ID = 4. When inserting the new records, you will see it displays in the list. Click Browse on top menu or click button BACK DB ADMIN back in listing mode.
- How long does it take you to create this table my_support_center? How many mouse clicks? How many steps of UIs (User Interface)?

- In 30 seconds if using Net.Office Database.
No back and forth with many mouse clicks, with many UI steps. Only need 1 clean short Create Table SQL code. DONE! Then do Data Entry.

- Click here see Data Type like Varchar, Double.

CREATE TABLE my_support_center
(
ID
int not null auto_increment primary key,
NAME
varchar (50),
Email varchar (50) not null,
Phone varchar (50) ,
Company varchar (50),
Submit_Date
Date ,
SUBJECT
Enum ( 'Question', 'Feedback/Ask', 'Help', 'Others Interest' ) default 'Help',
LIST_PRODUCTS_SERVICES
Set ( 'Hosting Server', 'Note Book', 'Hardware Product', 'Software Product', 'E-Development Services', 'Consulting Services', 'Training Services', 'Sales Inquiries'),
Description
Text,
Staff_name varchar(50),
Photo varchar(30),
Staff_Email varchar(50),
Staff_Phone varchar(50),
Support_Time
Datetime,
Office_Notes Text
)

- This table includes all Data Types, including complex Data Type like: SET, ENUM ...
- Click here see Data Type like Varchar, Double...


-
Table my_support_center
and its Easy Data Entry

Net.Office Database Data Entry Form - One screen Data Entry for all Tables. No switch back & forth.

- This table my_support_center is created less than 1 min. No back & forth many steps.  Copy blue code CREATE TABLE  -> Paste in Net.Office Database SQL Code Area -> Click button [Submit SQL] 
- This Data Entry Form is automatically created to enter data for new created table my_support_center. To understand field's Data Type, click here.
- The Data Entry Form lets you Insert new data for record. Edit, Update exist record. Delete record. Scroll Next, Prev records. Search record.

CREATE TABLE my_support_center
(
ID
int not null auto_increment primary key,
NAME
varchar (50),
Email varchar (50) not null,
Phone varchar (50) ,
Company varchar (50),
Submit_Date
Datetime ,
SUBJECT
Enum ( 'Question', 'Feedback/Ask', 'Help', 'Others Interest' ) default 'Help',
LIST_PRODUCTS_SERVICES
Set ( 'Hosting Server', 'Note Book', 'Hardware Product', 'Software Product', 'E-Development Services', 'Consulting Services', 'Training Services', 'Sales Inquiries'),
Description
Text,
Staff_name varchar(50),
Photo varchar(30),
Staff_Email varchar(50),
Staff_Phone varchar(50)

Picture: Another form format of Net.Office Database Data Entry Form is automatically generated to input data for above table my_support_center
- Using Net.Office Database Data Entry Form, you can input, data entry any tables.
It is one stop for input data for all tables.
1) Select a table from List all Tables, such as: my_support_center will load all its fields or category in the pull down list Select Category -> 2) At Select Category (or field) of the selected table, such as: NAME ->  3) Enter keyword search, such as: Rose. And click Search button. This will load the record that has Name = Rose into Input Data Entry Form

Net.Office Database -> Feature: Save your Query, SQL Programs. Net.Office Database automatically create database menu item for EDBMS. Make company's EDBMS easy to re-use and to maintain SQL code.

Think a SQl code is a Query, a SQL Program you or your staff wrote. Net.Office Database lets SQL programmers save all all their Query, SQL Programs. Then it automatically creates Database Menu Item for EDBMS. Next time, you or staff who don't know SQL can run these SQL Programs written by some one else.
For example, Net.Office Database create a menu Group called: Husband and Wives EDBMS. Then save the SQL Program and create a menu item= 16)
Join Husband, Wives, Contacts, and their Hobbies. When people click on the menu item will load the SQL code in SQl Area code and run this SQL Program you see in this picture.

How? -> Click on Save Query icon will open a UI interface Save Query. Can drag the UI (User Interface) anywhere on screen. It makes the background shading. This is new UI (User Interface) will be used for myNet.Office, Net.Office Database. After close the UI (User Interface), the screen is back to normal.
-> Enter SQL Group name = Husbands and Wives EDBMS, as Group Menu. This categorize the SQL Program in different Group menu. If not exist, Group menu will be auto created as a new Group menu.
-> Enter SQL Name =
Join Husbands, Wives, Contacts, and their Hobbies, used for the name of SQL Program. Number 16 is the ID number of this SQL Programs auto generated.
-> Enter the Comment for this SQL Program, maximum 64K characters of comment.
-> Finally click on Submit button. The Menu Group =  Husbands and Wives EDBMS, and the SQL Menu Item =
Join Husbands, Wives, Contacts, and their Hobbies are created in database menu. See picture.
 - The SQL code of program, the Author of program, the Date of the program, the SQL Group, the SQL Name of the program, the code Comment are also saved in database.


Picture: Use SAVE QUERY to save all SQL programs. It also automatically creates database menu item of this SQL Programs.

- To open saved SQL programs, click on Open SQL Query on the top left of frame -> List of database Menu frame under -> Click on each menu item to run SQL Programs.
- Click on the Menu Bar, like SALES AND MARKETING MENU, to list all SQL Programs under this menu. Click again to close its menu items. Scroll back and forth.

NOTE: The SQL program's code also is loading in to SQl Code Area so that any one can change or modify the code.

Benefits:

- Staff, people with no SQL Programming can run the reports, run the SQL programs pre-written by a SQL Programmer. Staff can also change data, variables of SQL program easily .

- The SQL Programmers don't need to re-write all the SQL codes again. Easy to maintain the SQL Programs.

- Save Query feature creates a database menu item for company's EDBMS. So that people know what to do with company's EDBMS.

- The pre written SQL Program can be modified data, change a little easily by any one including staff with no SQL programming skills.
For example, this SQL Program ran report total sales from
invoice_date >= '2012-06-01' AND invoice_date <= '2012-07-01' can be easily changed the invoice_date to different date.
SELECT invoice.invoice_date, sum(invoice.sub_total) as Daily_Total_Sales
FROM customer
INNER JOIN invoice
ON customer.customer_id = invoice.customer_id
WHERE invoice_date >= '2012-06-01' AND invoice_date <= '2012-07-01'
GROUP BY INVOICE_DATE


NOTE: In other software, to do this Report of Daily Total Sales, people must go through many UI , many steps, enter many data in order to produce this result. As you see, using a short SQL program, you can do powerful things that sometimes Business Software needs many steps User Interfaces to do.


Copy Rights 2012 @ Net Thru. All Rights reserved.

About Net Thru, is a global leading Internet software company and service provider to small and medium sized businesses worldwide. We are the pioneers in smart web. Smartweb is cloud website. A day website doing nothing will cost business a lot of time and money. Our product lines: myNet.Office Cloud Commerce, myNet.Office Smart Form Builder, Cloud web database Net.Office Database, myNet.Word, myNet.Page, myNet.Office Web Collaboration, myNet.Office Email Marketing... all integrated All-in-one myNet.Office. myNet.Office helps businesses, people, with no web skills, build and maintain themselves productive cloud website. myNet.Office is simple and affordable.

Contact: info@NetthruOffice.com