1. 创建名为v_course的视图，该视图仅查看Course表中课程编号为“10101”的课程信息 2. 创建名为v_upcourse的视图，该视图从course表中检索courseid、coursename的信息。通过该视图将courseid为“10103”的coursename修改为“大学语文” 3. 在v_upcourse的视图中将courseid为10102的课程信息删除 4. 创建名为v_upscore的视图统计每一位同学的总成绩 5. 创建名为view1，显示所有女同学的学号、姓名、课程名称、成绩。 6. 创建名为view2，显示“20级物联网工程”的班级名称及各班级人数； 7. 创建名为view3，显示“李云洋”同学选修“大学语文”的成绩。

很抱歉，作为一个语言模型AI，我并不能直接执行数据库操作。不过，我可以提供一些SQL语句供您参考：

1. 创建名为v_course的视图，该视图仅查看Course表中课程编号为“10101”的课程信息

CREATE VIEW v_course AS
SELECT * FROM Course
WHERE courseid = '10101';

2. 创建名为v_upcourse的视图，该视图从course表中检索courseid、coursename的信息。通过该视图将courseid为“10103”的coursename修改为“大学语文”

CREATE VIEW v_upcourse AS
SELECT courseid, coursename FROM Course;

UPDATE v_upcourse
SET coursename = '大学语文'
WHERE courseid = '10103';

3. 在v_upcourse的视图中将courseid为10102的课程信息删除

DELETE FROM v_upcourse
WHERE courseid = '10102';

4. 创建名为v_upscore的视图统计每一位同学的总成绩

CREATE VIEW v_upscore AS
SELECT studentid, SUM(score) AS total_score
FROM Score
GROUP BY studentid;

5. 创建名为view1，显示所有女同学的学号、姓名、课程名称、成绩。

CREATE VIEW view1 AS
SELECT Student.studentid, Student.studentname, Course.coursename, Score.score
FROM Student
JOIN Score ON Student.studentid = Score.studentid
JOIN Course ON Score.courseid = Course.courseid
WHERE Student.gender = '女';

6. 创建名为view2，显示“20级物联网工程”的班级名称及各班级人数；

CREATE VIEW view2 AS
SELECT Class.classname, COUNT(Student.studentid) AS num_of_students
FROM Class
JOIN Student ON Class.classid = Student.classid
WHERE Class.major = '物联网工程' AND Class.grade = '20'
GROUP BY Class.classname;

7. 创建名为view3，显示“李云洋”同学选修“大学语文”的成绩。

CREATE VIEW view3 AS
SELECT Score.score
FROM Score
JOIN Student ON Score.studentid = Student.studentid
JOIN Course ON Score.courseid = Course.courseid
WHERE Student.studentname = '李云洋' AND Course.coursename = '大学语文';