Database Design Exam Problem
Jun 28, 2003
I am going to sit for a database design exam. I am going through the practice questions and which are befuddling me. Can anyone give me pointers to the parts I am not clear with below?
The Problem
You are working for a legal firm that has an old antiquated Case Management System. The law firm’s documentation involves litigation material, recording findings, and general correspondence.
The final decisions are produced in Microsoft Word and are considered to be legal documents in the state of Virginia. At the moment there is no link to any party administration information stored in the Case Management system, so all addressing is re-keyed. The overall process is very paper intensive.
Question 1: Using, as your reference, the basic steps in Classic Systems Analysis, define the business problem described above.
Question 2: How might the overall problem be tackled?
Question 3: Complete an ERD with MS Visio to provide for a solution that will fit the requirements for the legal firm. Please note that the instructor will be running the MS Visio on SQL Server 2000 SP3 and Windows 2000.
The Question: I have problems with Question 1. What does “Classic System Analysis” mean here? Does this mean project management using the Waterfall method?
The ERD I can do. The non-tech stuff is the ambiguous part.
Thanks for any help. This conundrum has kept me up almost all night.
Bertina :)
View 1 Replies
ADVERTISEMENT
Mar 17, 2008
Hi,
I am studying for the above exam and have got a new laptop with the basic version of Vista pre-installed on it. I've got an evaluation version of SQL Server 2000 I got from a Microsoft event but the basic version of Vista I have, will not let me install it.
Can anyone advise me whether SQL Server Express will be useful in studying for the SQL Server 2000 Design 70-229 Exam?
If not, I see my options as fork out for an older OS licence - XP pro to put on the laptop which would allow me to install the evaluation edition. Not my first choice but it would do...
Thank you,
Mark Smith
View 5 Replies
View Related
May 13, 2015
I have a scenario like below
Product1
Product2 Product3
Product4 Product5
Product1 1
1 0 0
1
Product2 1
1 0 0
1
Product3 0
0 1 1
0
Product4 0
0 1 1
0
Product5 1
1 0 0
1
How to design tables in SQL Server for the above.
View 2 Replies
View Related
Feb 13, 2002
Ok, I'm doing a football database for fixtures and stuff. The problem I am having is that in a fixture, there is both a home, and an away team. The tables as a result are something like this:
-------
Fixture
-------
fix_id
fix_date
fix_played
----
Team
----
tem_id
tem_name
-----------
TeamFixture
-----------
fix_id
tem_id
homeorawayteam
goals
It's not exactly like that, but you get the point. The question is, can I do a fixture query which results in one record per fixture, showing both teams details. The first in a hometeam field and the second in an away team field.
Fixture contains the details about the fixture like date and fixture id and has it been played
Team contains team info like team id, name, associated graphic
TeamFixture is the table which links the fixture to it's home and away team.
TeamFixture exists to prevent a many to many type relationship.
Make sense? Sorry if this turns out to be really easy, just can't get my head around it at the mo!
View 2 Replies
View Related
Oct 29, 2015
I actually work in an organisation and we have to find a solution about the data consistancy in the database. our partners use to send details to the organisation and inserted directly in the database, so we want to create a new database as a buffer database to insert informations from the partners then make an update to the main database. is there a better solution instead of that?
View 6 Replies
View Related
Feb 24, 2006
Hello everyone,I have a webcontrol that uses database-structures alot, it uses the system tables in SQL to read column information from tables. To ease the load of the SQL server I have a property that stores this information in a cache and everything works fine.I am doing some research to find if there are anyway to get information from the SQL server that the structure from a table has changed.I want to know if a column or table has changed any values, like datatype, name, properties, etc.Any suggestions out there ?!
View 3 Replies
View Related
Jul 23, 2005
I have a system that basically stores a database within a database (I'msure lots have you have done this before in some form or another).At the end of the day, I'm storing the actual data generically in acolumn of type nvarchar(4000), but I want to add support for unlimitedtext. I want to do this in a smart fashion. Right now I am leaningtowards putting 2 nullable Value fields:ValueLong ntext nullableValueShort nvarchar(4000) nullableand dynamically storing the info in one or the other depending on thesize. ASP.NET does this exact very thing in it's Session State model;look at the ASPStateTempSessions table. This table has both aSessionItemShort of type varbinary (7000) and a SessionItemLong of typeImage.My question is, is it better to user varbinary (7000) and Image? I'mthinking maybe I should go down this path, simply because ASP.NET does,but I don't really know why. Does anyone know what would be the benifitof using varbinary and Image datatypes? If it's just to allow saving ofbinary data, then I don't really need that right now (and I don't thinkASP.NET does either). Are there any other reasons?thanks,dave
View 7 Replies
View Related
Aug 16, 2007
Hi All,Can u please suggest me some books for relational database design ordatabase modelling(Knowledgeable yet simple) i.e. from which we couldlearn database relationships(one to many,many to oneetc.....),building ER diagrams,proper usage of ER diagrams in ourdatabase(Primary key foreign key relations),designing smallmodules,relating tables and everything that relates about databasedesign....Coz I think database design is the crucial part of databaseand we must know the design part very first before starting up withdatabases.....Thanks and very grateful to all of you....Vikas
View 3 Replies
View Related
May 24, 2001
hi all,
Iam planning to write MCP exam for SqlServerAdministrator. what r the best books and sites to refer.
thanks
keerthi
View 1 Replies
View Related
Sep 28, 2004
Looking for testking 70-291 & 70-293, I have other exams to share.
let me know if intrested?
View 10 Replies
View Related
Feb 9, 2004
please help me to find a link that i can download the 70-229 sql v3.1 exam with no payment.
View 2 Replies
View Related
Mar 15, 2004
Hi,
am planning to appear for the exam 70 -299 Designing and Implementing Databases with Microsoft SQL Server™ 2000 Enterprise Edition.
anyone who has given that exam, please guide me
Thanks in advance
sudsur
View 1 Replies
View Related
May 12, 2004
well i took it and failed,
the test centre i went to in the UK had a pass mark for SQL Administration 70-228 of 70% out of 100%
does anyone know if this is a usual pass barrier or do some other UK testing centre's offer lower pass marks, and where to find them?
View 14 Replies
View Related
Apr 19, 2006
Hello, Im new so please be gentle. I'm just in the midst of studying for the SQL2K admin exam, and was going to to the Design exam straight afterwards. Ive heard that a person is much better off learing T-SQL before doing the design exam, is this the case? I will learn T-SQL anyway, but I'm wondering if learning before the design exam will make life easier for me?
Thanks for reading.
D.
Yes, we have no banana's.
View 5 Replies
View Related
Jan 4, 2000
Does anyone know of a good book that will prepare you for this exam. I know that in some early discussions that Mike Hoetch warned against some of the new books on the market.
Thanks
Ricky Kelley
View 1 Replies
View Related
Oct 31, 1999
hi!
i had the implementing database on sql server 7.0 exam this morning. there's a question that confuse me too much, it's fellowed
there are 3 columns on which you wanna create the composite index, A,B and C, A is almost identical, B is almost 50% identical and C is only 10% identical, i had the implementing database on sql server 7.0 exam this morning. there's a question that confuse me too much, it's fellowed
there are 3 columns on which you wanna create the composite index, A,B and C, A is almost identical, B is almost 50% identical and C is only 10% identical, then they asked which index enable the fastest query?
the choices:
A.clustered (A,B,C)
B.nonclustered (A,B,C)
C.clustered (C,B,A)
D.nonclustered (C,B,A)
i think the sequence must be C,B,A, but how about the clustered or nonclustered? i guess it's will be nonclustered.
ok, it's there.
could you help me? i wanna know when should be clustered besides the primary key and when should be the nonclustered.thanx!
View 3 Replies
View Related
Nov 12, 1998
1.You use new database dialog to create DB, but there's not available
Device, what is your quickest way to create a new device.
2.-Data and log are on same device, you issue:
DUMP database mydb to dump1
DUMP transaction mydb with truncate_only
What happened to trans log?
3 -Setting up Windows client to access your server, you enter the IP address
of the PDC, would this work?
View 1 Replies
View Related
Mar 1, 2001
Hi
Here is a mcdba admin question
Consider the following time line:
8:00 You accomplish the full database backup.
8:10 User1 enters the order 53 for customer 10, whose name in the database is
XXXXX (I
can't remember, but not Bill Smith)
8:12 User2 at remote server changes the name XXXXX to YYYYY
8:13 User3 changes the name YYYYY to ZZZZZ
8:14 User3 commit the transaction.
8:20 Media fails for database.
8:30 You restore the database from 8:00 backup. What is the status of the order
53 in the
database?
a) The order 53 is not in the database.
b) The order 53 is in the database and name is XXXXX.
c) The order 53 is in the database and name is YYYYY.
d) The order 53 is in the database and name is ZZZZZ.
Ans: B The name was already there.
The answer is B but I think th answer is A
becouse He or Her restroe the database from 8:00
I think the 53 order maked after 8:00 so
there is not order 53 in the backup database
How about you think and why !!!
Thanks kjs
View 2 Replies
View Related
Dec 27, 2005
finally on the road to becoming a full blown ass kicking mcdba!
passed it before christmas with the help of my girlfriend.
brilliant or what!
failed it last time back in 2004
all the best and have a cracking 2006 all!
View 3 Replies
View Related
Apr 5, 2007
I intend writing MCSD exams and would need some dumps on it.. if anyone happens to have, please kindly send me some @ gomesea@yahoo.com. I would glady appreciate it. Presently, I've written thr 70-305 exam.
View 4 Replies
View Related
Jan 7, 2004
Hello all,
I am preparing for 70-228 (SQL server Administration) exam. I was looking on the internet for some exam oriented questions or question bank kind of thing. I found couple of them but those are not sufficient. I would appreciate if you could let me know if you know any sites where i can get some more questions to solve. I would really appreciate if anybody has a questions bank and would like to share it with me.
Thanking in advance.
Mandar
View 1 Replies
View Related
Sep 20, 2005
What initial values of a and c are required such that the final values of a and b are:
a = 32
b = 4
…
int a,b,c
a = ?
b = 0
c = ?
for( b=0; a<12; b++ )
{
a = (a+a) * c;
}
…
I know its not the area but i'm hoping someone has an idea
View 20 Replies
View Related
Oct 25, 2007
I've gone through the Microsoft press study material for Exam 70-229. It is okay but not really comprehensive. I'd appreciate any supporting book that deals with the exam topics inside out... And info on any site which offers good practise exams is also appreciated.
Thank you.
View 2 Replies
View Related
Apr 8, 2008
hi guys i just wanna know a lil bit about 70-431 exam.
there is 35 question and 12 simulation quiz.
what i wanna know how many points per right answer? and how many points we recieve per right answer for simulations?
View 2 Replies
View Related
Oct 27, 2006
Hi
I'm not sure if this is the right forum to be posting this query as I am a newbie, but here goes. I will be taking the sql server 2005 exam in december and was wondering whether anybody could recommend any good books. The prepertion guide on the ms site has an overload of information which I am just getting lost in! I will also be purchasing these free e-courses on the ms site and wanted to know once I have purchased them how long will I have access to the courses. Also can I access them on the net from any machine.
I have just recently passed exam 70-315 and found that the exam questions were very similar to the TestKing questions which I made use of prior to the exam. So I will definetley be buying TK Q's for this exam also.
Many Thanks
Vik
View 6 Replies
View Related
Jan 30, 2008
hi can any one help me to get the pattern of 70-441 exam.
i need information total number of question in the exam..
and will there be any simulation as 70-431 exam.
View 3 Replies
View Related
Sep 20, 2006
hi there, i am planning to take the exam 70431 for sql server 2005 ...does any one have a good exam and course material either online or it will be great if it could be emailed to me. Thanks in advance
View 3 Replies
View Related
Aug 3, 2004
Hello,
My employer has recently offered to pay for my certification exam (70-229) so I am about to start preparing/revising. Having visited numerous sites to get an idea of what is needed, I am now overwhelmed with info.
Has anyone out there successfully completed the exam and if so can you recommend any sites/resources that you found useful (or any to avoid).
Regards
Simon
View 1 Replies
View Related
Jan 4, 2001
Can anybody suggest a couple of good books to use to prepare for the SQL Data Warehousing exam (70-019)? I'm starting to get ready for that exam to complete my MCDBA and was wondering if anybody had any good recommendations or those to stay away from.
Thanks for any help that you can provide in this matter.
Tom
View 1 Replies
View Related
Feb 6, 2004
I'll be taking this test and was hoping for some input, please.
1. How long is it ?
2. Anything in particular I should look out for ?
3. Should you only spend a certain amount of time on each question ?
4. Any place I can find any coupons for the heavy $125 fee ?
5. What company did you sign up through ?
6. Any other input, would greatly be appreciated !!
Thank you
View 2 Replies
View Related
Aug 2, 2001
anyone know of any useful sites, resources free test etc for sql 2000 admin exam
View 1 Replies
View Related
May 6, 2007
Hi Forum,
I am new to microsoft SQL server as I am from Oracle background. I am preparing to the MCP certification for Exam 70-229, Designing and Implementing Databases with Microsoft SQL Server 2000 Enterprise Edition. The exam shows as SQL server 2000 is there any exam for SQL server 2005.
Is it the write exam to give to start as fesher into microsoft platform. Iam into development not towards administration.
If any body has any Exam preparation questions please forward them to krishna.kanigelpula@gmail.com.
Regards,
Krishna.
View 1 Replies
View Related
Dec 21, 2006
Hello,
Anyone planning to take the exam 70-431?
It would be nice to share experience and motivation ... I am currently using SQL Server 2005 Bible as a reference, any other references you suggest? Any place where I could find exam samples?
LLOYD
View 1 Replies
View Related
