Re: [sqlite] DBMS Normalization Query

[James K. Lowden]

On Wed, 2 Oct 2019 21:42:13 -0700 (MST)
shivambhatele  wrote:

> 1. When is the process of normalization used?
> 2. Boyce and Codd Normal Form
> 3. 1NF, 2NF, and 3NF

Good information on database theory is remarkably scarce on the web,
and difficult for the beginner to distinguish from bad information on
database theory.  And, actually, that's the case for almost any body of
knowledge.  If you want to master a discipline, books are a better
resource.  

I have tried referring people to wikipedia before.  It's not
necessarily wrong; it's more a question of completeness and explication.
You just can't replace a book with a web page or pages.  

I recommend 

An Introduction to Database Systems (8th Edition), 2003, 
by C.J. Date

It's useful to understand normalization in the context of relational
algebra: by removing redundancy, you defend against anomalies that
would otherwise result from mathematically correct operations.  So,
well, more than one chapter to read.  :-)  

--jkl
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] DBMS Normalization Query

[Chris Locke]

Short answer.  Duplicate data in a database is bad.  Take school
departments.  For each teacher, do you put "History", "Chemistry",
"Biology" for their department?  What happens if someone enters "Bioolgy"
instead?  So for your point #1, "as soon as duplicate data is possible".
Maybe not for surnames or firstnames, but certainly for address counties,
departments, car types, etc, etc.  As soon as there is a definite list for
some data.
#2, #3.  Wikipedia is your friend here.

On Thu, Oct 3, 2019 at 2:47 PM shivambhatele 
wrote:

> Hello All,
>
> I am looking to explore more about normalization in DBMS. I am confused
> about some points. Can anyone tell me about these points? I have to google
> it to read about all these points and I have found some blogs like this
> normalization in DBMS    but
> still, I am not cleared some points
>
> 1. When is the process of normalization used?
> 2. Boyce and Codd Normal Form
> 3. 1NF, 2NF, and 3NF
>
>
>
>
>
> --
> Sent from: http://sqlite.1065341.n5.nabble.com/
> ___
> sqlite-users mailing list
> sqlite-users@mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] DBMS Normalization Query

[shivambhatele]

Hello All,

I am looking to explore more about normalization in DBMS. I am confused
about some points. Can anyone tell me about these points? I have to google
it to read about all these points and I have found some blogs like this 
normalization in DBMS    but
still, I am not cleared some points

1. When is the process of normalization used?
2. Boyce and Codd Normal Form
3. 1NF, 2NF, and 3NF





--
Sent from: http://sqlite.1065341.n5.nabble.com/
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] sqlite database changes not committed immediately

[Wintech Tech]

Error there when database is Local system  as well as in a remote
Filesystem.

On Thu, Oct 3, 2019 at 4:14 PM Keith Medcalf  wrote:

>
> Those examples appear to be using a database resident on a remote
> filesystem.  Is the database located on a remote filesystem?
>
> --
> The fact that there's a Highway to Hell but only a Stairway to Heaven says
> a lot about anticipated traffic volume.
>
> >-Original Message-
> >From: sqlite-users  On
> >Behalf Of Wintech Tech
> >Sent: Thursday, 3 October, 2019 04:06
> >To: sqlite-users@mailinglists.sqlite.org
> >Subject: [sqlite] sqlite database changes not committed immediately
> >
> >Hi everyone ,
> >
> >i have posted below Questions on other forums , Please help me solve this
> >System.Data.SQLite error . (both are same errors)
> >
> >https://dba.stackexchange.com/questions/249902/sqlite-database-changes-
> >not-commited-immediately
> >https://stackoverflow.com/questions/58116937/auto-increment-isnt-correct-
> >when-running-two-instances
> >
> >if required i can post the same question in the email also.
> >
> >Thank you!
> >___
> >sqlite-users mailing list
> >sqlite-users@mailinglists.sqlite.org
> >http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>
>
>
> ___
> sqlite-users mailing list
> sqlite-users@mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Hello everyone, I found some strange behavior when using the Command Line Shell For SQLite.

[Richard Damon]

On 10/3/19 5:46 AM, 算 子 wrote:
> In column mode, each record is shown on a separate line with the data aligned 
> in columns. For example:
>
> sqlite> .mode column
> sqlite> select * from tbl1;
> one   two   
> --  --
> hello 10
> goodbye   20
> sqlite>
>
>
> But I found,only when columns text is ANSI,it can normal work.
>
> sqlite> .mode column
> sqlite> select * from 语言声明表;
> 语言指针        引用数量        语言名称        语言注释
> --  --  --  --
> 1           0           1           0
> 2           0           2           0
>
> If the columns text is utf-8,it can't work.
> What should I do for it?
> ___
> sqlite-users mailing list
> sqlite-users@mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

My guess is that column mode doesn't understand all the strangeness that
comes with Unicode and fonts, and probably expects that each code point
is exactly the same width. I note that at least on my computer the CJK
characters are wider than the ASCII characters, and thus makes columns
not align.

-- 
Richard Damon

___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Hello everyone,

[算 子]

When I open the sqlite.exe by cmd.It can print text normally(but the format is 
wrong).
But after I run"chcp 65001"(change the cmd code to utf-8) text become random 
code.
So,maybe the tool used WindowsOS's default code which itself running  on.
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Thank you, and I found the tool maybe used Windows's default code, not utf-8.

[算 子]

When I open the sqlite.exe by cmd.It can print text normally(but the format is 
wrong).
But after I run"chcp 65001"(change the cmd code to utf-8) text become random 
code.
So,maybe the tool used WindowsOS's default code which itself running  on.
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] sqlite database changes not committed immediately

[Keith Medcalf]

Those examples appear to be using a database resident on a remote filesystem.  
Is the database located on a remote filesystem?

-- 
The fact that there's a Highway to Hell but only a Stairway to Heaven says a 
lot about anticipated traffic volume.

>-Original Message-
>From: sqlite-users  On
>Behalf Of Wintech Tech
>Sent: Thursday, 3 October, 2019 04:06
>To: sqlite-users@mailinglists.sqlite.org
>Subject: [sqlite] sqlite database changes not committed immediately
>
>Hi everyone ,
>
>i have posted below Questions on other forums , Please help me solve this
>System.Data.SQLite error . (both are same errors)
>
>https://dba.stackexchange.com/questions/249902/sqlite-database-changes-
>not-commited-immediately
>https://stackoverflow.com/questions/58116937/auto-increment-isnt-correct-
>when-running-two-instances
>
>if required i can post the same question in the email also.
>
>Thank you!
>___
>sqlite-users mailing list
>sqlite-users@mailinglists.sqlite.org
>http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users



___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Hello everyone, I found some strange behavior when using the Command Line Shell For SQLite.

[Kees Nuyt]

On Thu, 3 Oct 2019 09:46:27 +, suan...@outlook.com wrote:

> In column mode, each record is shown on a separate
> line with the data aligned in columns. For example:
> sqlite> .mode column
> sqlite> select * from tbl1;
> one   two   
> --  --
> hello 10
> goodbye   20
> sqlite>
>
> But I found,only when columns text is ANSI,it can normal work.
> sqlite> .mode column
> sqlite> select * from ?;
>                         
> --  --  --  --
> 1           0           1           0
> 2           0           2           0
>
> If the columns text is utf-8,it can't work.
> What should I do for it?


It works for me, using UTF-8 language settings for the terminal,
and a font that contains enough of UTF-8.

~ $ uname -a
Linux f7p3 4.19.66-v7+ #1253 SMP Thu Aug 15 11:49:46 BST 2019 armv7l GNU/Linux

~ $ set|grep -E '(LC_|LANG)'
LANG=en_US.utf-8
LC_ALL=
LC_COLLATE=en_US.utf-8
LC_CTYPE=en_US.utf-8
LC_MESSAGES=en_US.utf-8
LC_MONETARY=en_US.utf-8
LC_NUMERIC=en_US.utf-8
LC_TIME=en_US.utf-8

Column names used: e-acute and a-umlaut

~ $ sqlite3 test.db
SQLite version 3.30.0 2019-09-25 18:44:49
Enter ".help" for usage hints.
sqlite> CREATE TABLE x (é integer primary key,ä TEXT);
sqlite> INSERT INTO x VALUES (1,'téxt');
sqlite> . mode column
sqlite> . head on
sqlite> select * FROM x;
é   ä
--  --
1   téxt
sqlite>.q

~ $ sqlite3 test.db \
".mode column" ".head on" ".width 1 4" "SELECT * FROM x" \
| hexdump -C

 c3 a9 20 20 c3 a4 20 20  20 0a 2d 20 20 2d 2d 2d |..  ..   .-  ---|
0010 2d 0a 31 20 20 74 c3 a9  78 74 0a|-.1  t..xt.|
001b

-- 
Regards,
Kees Nuyt
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] sqlite database changes not committed immediately

[Wintech Tech]

Hi everyone ,

i have posted below Questions on other forums , Please help me solve this
System.Data.SQLite error . (both are same errors)

https://dba.stackexchange.com/questions/249902/sqlite-database-changes-not-commited-immediately
https://stackoverflow.com/questions/58116937/auto-increment-isnt-correct-when-running-two-instances

if required i can post the same question in the email also.

Thank you!
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Hello everyone, I found some strange behavior when using the Command Line Shell For SQLite.

[算 子]

In column mode, each record is shown on a separate line with the data aligned 
in columns. For example:

sqlite> .mode column
sqlite> select * from tbl1;
one   two   
--  --
hello 10
goodbye   20
sqlite>


But I found,only when columns text is ANSI,it can normal work.

sqlite> .mode column
sqlite> select * from 语言声明表;
语言指针        引用数量        语言名称        语言注释
--  --  --  --
1           0           1           0
2           0           2           0

If the columns text is utf-8,it can't work.
What should I do for it?
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Import XLS file?

[Dingyuan Wang]

There is FreeXL (https://www.gaia-gis.it/fossil/freexl/index)
may suit your need.

2019/10/2 02:58, Winfried:

Simon Slavin-3 wrote

1) export your XLS data in CSV format
2) Use the SQLite shell tool to import the CSV data into your database


Thanks.

Is there a free (beer|speech) tool to convert an XLS file into CSV, for
Windows or Linux that you would recommend?



--
Sent from: http://sqlite.1065341.n5.nabble.com/
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users


___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users