Sql ANSI Padding: design

I am a .net developer, know how to get my data from the database
through SQL. I am getting interested in database design, and am
wondering if there are any sample banking database to download.
Basically, for practice, I would like to design a credit card
company's database, such that users can check their charge history,
payment history, current balance, current balance due, etc., pretty
much functionalities which most credit card services provide online.
Any suggestion about how to get started?
Thank you very much."gnewsgroup" wrote:
> I am a .net developer, know how to get my data from the database
> through SQL. I am getting interested in database design, and am
> wondering if there are any sample banking database to download.
> Basically, for practice, I would like to design a credit card
> company's database, such that users can check their charge history,
> payment history, current balance, current balance due, etc., pretty
> much functionalities which most credit card services provide online.
> Any suggestion about how to get started?
> Thank you very much.
>
Hi
Although not a complete schema
http://www.microsoft.com/sql/editions/express/starterschemas.mspx may give
you parts such as customer management etc. The transaction history is a very
similar situation to a invoice item/detail where each item is a card
transaction.
John|||On Apr 28, 8:10 am, John Bell <jbellnewspo...@.hotmail.com> wrote:
> "gnewsgroup" wrote:
> > I am a .net developer, know how to get my data from the database
> > through SQL. I am getting interested in database design, and am
> > wondering if there are any sample banking database to download.
> > Basically, for practice, I would like to design a credit card
> > company's database, such that users can check their charge history,
> > payment history, current balance, current balance due, etc., pretty
> > much functionalities which most credit card services provide online.
> > Any suggestion about how to get started?
> > Thank you very much.
> Hi
> Although not a complete schemahttp://www.microsoft.com/sql/editions/express/starterschemas.mspxmay give
> you parts such as customer management etc. The transaction history is a very
> similar situation to a invoice item/detail where each item is a card
> transaction.
> John
Very cool. Thank you very much. I will closely study a few of them
and may get an idea.|||On Apr 28, 8:10 am, John Bell <jbellnewspo...@.hotmail.com> wrote:
> "gnewsgroup" wrote:
> > I am a .net developer, know how to get my data from the database
> > through SQL. I am getting interested in database design, and am
> > wondering if there are any sample banking database to download.
> > Basically, for practice, I would like to design a credit card
> > company's database, such that users can check their charge history,
> > payment history, current balance, current balance due, etc., pretty
> > much functionalities which most credit card services provide online.
> > Any suggestion about how to get started?
> > Thank you very much.
> Hi
> Although not a complete schemahttp://www.microsoft.com/sql/editions/express/starterschemas.mspxmay give
> you parts such as customer management etc. The transaction history is a very
> similar situation to a invoice item/detail where each item is a card
> transaction.
> John
Thank you. I downloaded those databases, unzipped. But because they
don't come with the log file (*.ldf), I cannot attach them, and
therefore, cannot use it.
I googled, and found this:
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=85187
I followed the method provided over there by BashTheGeek, but could
not succeed. I am using SQL Server 2005 Express and got an error
which says something like I cannot ad hoc change the status of a
database.
I don't know why M$ could not have included the LDF file and make our
newbies' life easier. It's called starter database, right?
Any hint is highly appreciated.|||On Apr 29, 9:53 am, gnewsgroup <gnewsgr...@.gmail.com> wrote:
> On Apr 28, 8:10 am, John Bell <jbellnewspo...@.hotmail.com> wrote:
>
> > "gnewsgroup" wrote:
> > > I am a .net developer, know how to get my data from the database
> > > through SQL. I am getting interested in database design, and am
> > > wondering if there are any sample banking database to download.
> > > Basically, for practice, I would like to design a credit card
> > > company's database, such that users can check their charge history,
> > > payment history, current balance, current balance due, etc., pretty
> > > much functionalities which most credit card services provide online.
> > > Any suggestion about how to get started?
> > > Thank you very much.
> > Hi
> > Although not a complete schemahttp://www.microsoft.com/sql/editions/express/starterschemas.mspxmaygive
> > you parts such as customer management etc. The transaction history is a very
> > similar situation to a invoice item/detail where each item is a card
> > transaction.
> > John
> Thank you. I downloaded those databases, unzipped. But because they
> don't come with the log file (*.ldf), I cannot attach them, and
> therefore, cannot use it.
> I googled, and found this:
> http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=85187
> I followed the method provided over there by BashTheGeek, but could
> not succeed. I am using SQL Server 2005 Express and got an error
> which says something like I cannot ad hoc change the status of a
> database.
> I don't know why M$ could not have included the LDF file and make our
> newbies' life easier. It's called starter database, right?
> Any hint is highly appreciated.
Never mind, at an MSDN forum, one guy says that we when attach the
database, simply remove the log file in the dialog box, and attach
it. When it is attached the database will create a log file. That
was easy.|||On Apr 29, 9:53 am, gnewsgroup <gnewsgr...@.gmail.com> wrote:
> On Apr 28, 8:10 am, John Bell <jbellnewspo...@.hotmail.com> wrote:
>
> > "gnewsgroup" wrote:
> > > I am a .net developer, know how to get my data from the database
> > > through SQL. I am getting interested in database design, and am
> > > wondering if there are any sample banking database to download.
> > > Basically, for practice, I would like to design a credit card
> > > company's database, such that users can check their charge history,
> > > payment history, current balance, current balance due, etc., pretty
> > > much functionalities which most credit card services provide online.
> > > Any suggestion about how to get started?
> > > Thank you very much.
> > Hi
> > Although not a complete schemahttp://www.microsoft.com/sql/editions/express/starterschemas.mspxmaygive
> > you parts such as customer management etc. The transaction history is a very
> > similar situation to a invoice item/detail where each item is a card
> > transaction.
> > John
> Thank you. I downloaded those databases, unzipped. But because they
> don't come with the log file (*.ldf), I cannot attach them, and
> therefore, cannot use it.
> I googled, and found this:
> http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=85187
> I followed the method provided over there by BashTheGeek, but could
> not succeed. I am using SQL Server 2005 Express and got an error
> which says something like I cannot ad hoc change the status of a
> database.
> I don't know why M$ could not have included the LDF file and make our
> newbies' life easier. It's called starter database, right?
> Any hint is highly appreciated.
Never mind, I found at an MSDN forum where one guy says that when we
try to attach the mdf database file, simply remove the log file from
the dialog box and when it is attached, the database will create a log
file for it. That was easy.|||> I followed the method provided over there by BashTheGeek, but could
> not succeed. I am using SQL Server 2005 Express and got an error
> which says something like I cannot ad hoc change the status of a
> database.
The poster should have been more clear about the scenario in which to use
the sp_configure "allow updates" syntax. This option is not needed at all
when the database has been detached or otherwise cleanly shut down. In fact,
the ability to modify the system catalog, which is what that syntax allows,
is not even allowed in SQL Server 2005, That's why you're getting the error
that you are.
Use either sp_attach_single_file (see
http://msdn2.microsoft.com/en-us/library/ms174385.aspx for an example)
or the following syntax introduced in SQL Server 2005:
CREATE DATABASE <db_name>
ON (FILENAME = '<dir path><file_name.mdf'>')
FOR ATTACH
--
Gail Erickson [MS]
SQL Server Documentation Team
This posting is provided "AS IS" with no warranties, and confers no rights
Download the latest version of Books Online from
http://technet.microsoft.com/en-us/sqlserver/bb428874.aspx
"gnewsgroup" <gnewsgroup@.gmail.com> wrote in message
news:c761f2e5-ec29-425a-8a39-7c6395e4d79d@.b64g2000hsa.googlegroups.com...
> On Apr 28, 8:10 am, John Bell <jbellnewspo...@.hotmail.com> wrote:
>> "gnewsgroup" wrote:
>> > I am a .net developer, know how to get my data from the database
>> > through SQL. I am getting interested in database design, and am
>> > wondering if there are any sample banking database to download.
>> > Basically, for practice, I would like to design a credit card
>> > company's database, such that users can check their charge history,
>> > payment history, current balance, current balance due, etc., pretty
>> > much functionalities which most credit card services provide online.
>> > Any suggestion about how to get started?
>> > Thank you very much.
>> Hi
>> Although not a complete
>> schemahttp://www.microsoft.com/sql/editions/express/starterschemas.mspxmay
>> give
>> you parts such as customer management etc. The transaction history is a
>> very
>> similar situation to a invoice item/detail where each item is a card
>> transaction.
>> John
> Thank you. I downloaded those databases, unzipped. But because they
> don't come with the log file (*.ldf), I cannot attach them, and
> therefore, cannot use it.
> I googled, and found this:
> http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=85187
> I followed the method provided over there by BashTheGeek, but could
> not succeed. I am using SQL Server 2005 Express and got an error
> which says something like I cannot ad hoc change the status of a
> database.
> I don't know why M$ could not have included the LDF file and make our
> newbies' life easier. It's called starter database, right?
> Any hint is highly appreciated.|||On Apr 29, 1:01 pm, "Gail Erickson [MS]" <ga...@.online.microsoft.com>
wrote:
> > I followed the method provided over there by BashTheGeek, but could
> > not succeed. I am using SQL Server 2005 Express and got an error
> > which says something like I cannot ad hoc change the status of a
> > database.
> The poster should have been more clear about the scenario in which to use
> the sp_configure "allow updates" syntax. This option is not needed at all
> when the database has been detached or otherwise cleanly shut down. In fact,
> the ability to modify the system catalog, which is what that syntax allows,
> is not even allowed in SQL Server 2005, That's why you're getting the error
> that you are.
> Use either sp_attach_single_file (seehttp://msdn2.microsoft.com/en-us/library/ms174385.aspxfor an example)
> or the following syntax introduced in SQL Server 2005:
> CREATE DATABASE <db_name>
> ON (FILENAME = '<dir path><file_name.mdf'>')
> FOR ATTACH
> --
> Gail Erickson [MS]
> SQL Server Documentation Team
> This posting is provided "AS IS" with no warranties, and confers no rights
> Download the latest version of Books Online fromhttp://technet.microsoft.com/en-us/sqlserver/bb428874.aspx
>
OK, that's great. But in the MSDN forum, 2 people were saying how
helpful the answer provided by BashTheGeek was. So that sorta misled
me. :)
So,
CREATE DATABASE <db_name>
ON (FILENAME = '<dir path><file_name.mdf'>')
FOR ATTACH
will take care of the whole thing even without an LDF file?
Let me try it out. But, simply try attaching it after removing the ldf
file is easy, too.|||OK, that's great. But in the MSDN forum, 2 people were saying how
helpful the answer provided by BashTheGeek was. So that sorta misled
me. :)
Yes, you were mislead because the context of their particular scenario (i.e.
the database they were trying to attach had not been cleanly shut down) was
not made clear in the post.
--
Gail Erickson [MS]
SQL Server Documentation Team
This posting is provided "AS IS" with no warranties, and confers no rights
Download the latest version of Books Online from
http://technet.microsoft.com/en-us/sqlserver/bb428874.aspx
"gnewsgroup" <gnewsgroup@.gmail.com> wrote in message
news:8ee8eec9-4061-43b5-a237-79cfe0ae217e@.34g2000hsh.googlegroups.com...
> On Apr 29, 1:01 pm, "Gail Erickson [MS]" <ga...@.online.microsoft.com>
> wrote:
>> > I followed the method provided over there by BashTheGeek, but could
>> > not succeed. I am using SQL Server 2005 Express and got an error
>> > which says something like I cannot ad hoc change the status of a
>> > database.
>> The poster should have been more clear about the scenario in which to use
>> the sp_configure "allow updates" syntax. This option is not needed at all
>> when the database has been detached or otherwise cleanly shut down. In
>> fact,
>> the ability to modify the system catalog, which is what that syntax
>> allows,
>> is not even allowed in SQL Server 2005, That's why you're getting the
>> error
>> that you are.
>> Use either sp_attach_single_file
>> (seehttp://msdn2.microsoft.com/en-us/library/ms174385.aspxfor an example)
>> or the following syntax introduced in SQL Server 2005:
>> CREATE DATABASE <db_name>
>> ON (FILENAME = '<dir path><file_name.mdf'>')
>> FOR ATTACH
>> --
>> Gail Erickson [MS]
>> SQL Server Documentation Team
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights
>> Download the latest version of Books Online
>> fromhttp://technet.microsoft.com/en-us/sqlserver/bb428874.aspx
> OK, that's great. But in the MSDN forum, 2 people were saying how
> helpful the answer provided by BashTheGeek was. So that sorta misled
> me. :)
> So,
> CREATE DATABASE <db_name>
> ON (FILENAME = '<dir path><file_name.mdf'>')
> FOR ATTACH
> will take care of the whole thing even without an LDF file?
> Let me try it out. But, simply try attaching it after removing the ldf
> file is easy, too.
>

I dont want to go over thru a 100 page book on the subject.
Id like a quick introductory course on database design with examples and
terminology that i could read thats possibly less than 20 pages.
Is there such a link ?Database Design: http://www.kudzuworld.com/articles/DBDesign/
SQL:
http://www.dbbm.fiocruz.br/class/Lecture/d17/sql/jhoffman/sqltut.html|||On Sun, 17 Sep 2006 14:33:12 -0700, Hassan wrote:
>I dont want to go over thru a 100 page book on the subject.
>Id like a quick introductory course on database design with examples and
>terminology that i could read thats possibly less than 20 pages.
>Is there such a link ?
>
Hi Hassan,
Some googling brought me these twoo VERY short introductions on database
design:
http://www.datamodel.org/NormalizationRules.html
http://www.databasedesign-resource.com/normal-forms.html
However, p-l-e-a-s-e do not make the mistake to think that it's even
possible to become an expert in this subject by reading these pages or
any other "less than 20 pages" publication. In such a short span, only
an introduction or a quick, basic overview is possible. The reason that
most good books on DB design are welll over 100 pages is becuase that
amount of space is NEEDED to cover the subject matter.
--
Hugo Kornelis, SQL Server MVP|||Database Modelling in UML
http://www.methodsandtools.com/archive/archive.php?id=9

2012年3月20日星期二

Any way to protect our Report design

2012年3月11日星期日

any suggestions for this report design

2012年3月8日星期四

Any sample banking database to download?

2012年2月18日星期六

any good links on database design

any good links on database design

any good links on database design

Sql ANSI Padding

Blog Archive

About Me