在接受采访时我问过这个问题。有人破解了吗？ [英] This question was asked to me in an interview.can somebody crack it?
问题描述
您可以为以下申请设计数据库吗？应用程序'扩展计划器'
- 当前功能仅支持添加正面和负面项目，其描述为
。计划的功能是能够按记录类型过滤单个项目
- 例如杂货/娱乐。数据库设计需要为将来的扩展准备好b $ b。
我们希望拥有成千上万的用户，每位用户有1000条记录。
我的尝试： < br $> b $ b
我不确定答案。这就是我的尝试：
3桌
客户
- --------
id
name
Transaction_Tye
-----------
Trn_type_id
Trn_Type_Name
交易
--------------------
Trn_id
id（fk）
Trn_Type_id（fk）
Tran_Description
Trn_Amount
Trn_date
•启用表/数据库压缩
•每晚消除索引碎片。
•每晚更新统计信息，并设置自动更新统计信息数据库打开。
•至少每小时备份一次数据库的事务日志，以便重用文件并限制自动增长。
•要么每晚进行完整备份，或每周进行一次完整备份和夜间差异。
•计划dule数据库完整性检查每周运行一次，因为它们可能不适合您的夜间维护窗口。
•设置所有维护作业，以便在完成或每个任务失败时向多个人发送电子邮件警报。
Can you design DB for following application? Application ‘expanse planner’
– current functionality only supports adding positive and negative items with
their description. Planned functionality is to be able to filter individual items
by type of record – for example groceries/entertainment. The DB design needs to be
prepared for future extensions.
We expect to have 100thousands of user with 1000 records per user.
What I have tried:
I am not sure of the answer. This is what I tried:
3 tables
customer
---------
id
name
Transaction_Tye
-----------
Trn_type_id
Trn_Type_Name
Transaction
--------------------
Trn_id
id (fk)
Trn_Type_id(fk)
Tran_Description
Trn_Amount
Trn_date
• Enable Table/ Database Compression
• Eliminate index fragmentation each night.
• Update statistics each night, and set Auto Update Statistics for the database to On.
• Back up the transaction log for the database at least once an hour to allow for reuse of the file and limited auto-growth.
• Either conduct full backups nightly, or conduct full backups weekly with nightly differentials.
• Schedule database integrity checks to run weekly because they probably won’t fit into your nightly maintenance window.
• Set all maintenance jobs to send email alerts on completion or failure of each task to more than one person.
推荐答案
我们不做你的作业：这是有原因的。它就是为了让你思考你被告知的事情，并试着理解它。它也在那里，以便您的导师可以识别您身体虚弱的区域，并将更多的注意力集中在补救措施上。
如果您不认为面试问题是家庭作业，那么您就是当你最终不得不面试申请人时会感到惊讶！
亲自试试，你可能会发现它并不像你想象的那么难！
如果您遇到特定问题，请询问相关问题，我们会尽力提供帮助。但是我们不会为你做这一切！
We do not do your homework: it is set for a reason. It is there so that you think about what you have been told, and try to understand it. It is also there so that your tutor can identify areas where you are weak, and focus more attention on remedial action.
And if you don't think that "interview questions" are homework, then you are in for a surprise when you end up having to interview applicants!
Try it yourself, you may find it is not as difficult as you think!
If you meet a specific problem, then please ask about that and we will do our best to help. But we aren't going to do it all for you!
费用计划员应该很容易;什么都不知道扩张规划者。
日期
项目说明
项目类型（如果你真的很有野心）
金额
An "expense planner" should be easy; don't know anything about "expanse" planners.
Date
Item Description
Item Type (if you really get ambitious)
Amount
这篇关于在接受采访时我问过这个问题。有人破解了吗？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
