有关数据库的笔试题

[村文化管理员笔试试题]展开全部其实对这方面的我了解的不够多。但是在农村，宣传可以挂横幅在显眼的位置。发传单也是个可行的方法，但是要考虑到部分村民不识字，以及老人老花或者是耳鸣等情况，可以面...+阅读

确实，这个问题得用点时间。我先给你开个头，有空给你补上：问题一：（需要说明下表和字段主键就OK了）需要建三个表：具体字段可以自己再加程序员信息表、部门表、上级部门表 ************************************** CREATE TABLE [Programmer] ( [ProgrammerCode] [int] NOT NULL , [ProgrammerName] [char] (10) COLLATE Japanese_CI_AS NULL , [ProgrammerSex] [int] NOT NULL , [BelongBranch] [int] NOT NULL , [other] [char] (10) COLLATE Japanese_CI_AS NULL , CONSTRAINT [PK_Programmer] PRIMARY KEY CLUSTERED ( [ProgrammerCode] ) ON [PRIMARY] ) ON [PRIMARY] GO ***************************************** CREATE TABLE [Branch] ( [BranchCode] [int] NOT NULL , [BranchName] [char] (10) COLLATE Japanese_CI_AS NOT NULL , [BelongTo] [int] NOT NULL , [OtherInformation] [char] (10) COLLATE Japanese_CI_AS NULL , CONSTRAINT [PK_Branch] PRIMARY KEY CLUSTERED ( [BranchCode] ) ON [PRIMARY] ) ON [PRIMARY] GO *************************************** CREATE TABLE [LeaderBranch] ( [LeaderBranch] [int] NOT NULL , [LeaderBranchName] [char] (10) COLLATE Japanese_CI_AS NOT NULL , [OtherInformation] [char] (10) COLLATE Japanese_CI_AS NULL , CONSTRAINT [PK_LeaderBranch] PRIMARY KEY CLUSTERED ( [LeaderBranch] ) ON [PRIMARY] ) ON [PRIMARY] GO ****************************************************** 问题2：各部门人数查询： SELECT BranchName,count (*) AS 程序员人数 FROM Programmers p INNER JOIN Branch b ON p.BelongBranch = b.BranchCode GROUP BY BranchName 上级部门人数查询： SELECT LeaderBranchName,count (*) AS 程序员人数 FROM Programmers p INNER JOIN Branch b ON p.BelongBranch = b.BranchCode INNER JOIN LeaderBranch l ON b.BelongTo = l.LeaderBranch GROUP BY l.LeaderBranchName —————————————————————————————— 问题三有空再给你答，呵呵~~